您现在的位置:首页 >> 新开传奇网站 >> 内容

Other names may be trademarks of theirrespective

时间:2019/7/6 8:30:30 点击:

  核心提示:   [root@localhost ~]#rm -f /etc/f [root@localhost ~]#rm -rf /home/mysql_data/mysql 卸载后/home/mysql_data/mysql中的数据及/etc/f不会删除,ok) [root@loc...

   [root@localhost ~]#rm -f /etc/f

[root@localhost ~]#rm -rf /home/mysql_data/mysql

卸载后/home/mysql_data/mysql中的数据及/etc/f不会删除,ok)

[root@localhost ~]# rpm -evMySQL-server-5.5.8-1.linux2.6(执行卸载)

MySQL-client-5.5.8-1.linux2.6

MySQL-server-5.5.8-1.linux2.6

[root@localhost ~]# rpm -qa|grep -i mysql (查看本机安装的mysql)

1.卸载mysql

[root@localhost ~]# mysql -u root -p dbtest<back_dbtest

7.2恢复

[root@localhost ~]# mysqldump -u root -p --opt dbtest>back_dbtest

[root@localhost ~]# cd/home/mysql_data/mysql(进入库目录/home/mysql_data/mysql)

7.1备份:将上例创建的dbtest库备份到文件back_dbtest中

3. 备份与恢复

(创建数据库dbtest和表tbtest)

Type 'help;' or '\h' for help. Type '\c' to clear the currentinput statement.

owners.

affiliates. Other names may be trademarks of theirrespective

Oracle is a registered trademark of Oracle Corporation and/orits

Copyright (c) 2000, 2010, Oracle and/or its affiliates. Allrights reserved.

Server version: 5.5.8-log MySQL Community Server (GPL)

Your MySQL connection id is 1

Welcome to the MySQL monitor. Commands end with ; or \g.

Enter password:

[root@localhost ~]# mysql -u root -p

MySQL running (5730)

[root@localhost mysql]# /etc/rc.d/init.d/mysql status

Starting MySQL. [ OK ]

[root@localhost mysql]# /etc/rc.d/init.d/mysql start(使用该命令重启,6复古传奇官网。找不到“mysql.sock”文件,正在running)

Shutting down MySQL. [ OK ]

[root@localhost mysql]# service mysql stop (停止mysql服务)

localhost.localdomain.pid mysql-bin.index test

localhost.localdomain.err mysql-bin.000003RPM_UPGRADE_MARKER-LAST

ib_logfile1 mysql-bin.000002 RPM_UPGRADE_HISTORY

ib_logfile0 mysql-bin.000001 performance_schema

ibdata1 mysql mysql.sock

[root@localhost mysql]# ls(查看/home/mysql_data/mysql下出现“mysql.sock”文件)

Starting MySQL. [ OK ]

[root@localhost mysql]# service mysql start(使用service启动mysql服务)

(果真不存在,Other。所以可以通过service mysqlstatus查看mysql服务的状态,调整mysql.sock文件的指向位置

localhost.localdomain.pid mysql-bin.index

localhost.localdomain.err mysql-bin.000003RPM_UPGRADE_MARKER-LAST

ib_logfile1 mysql-bin.000002 RPM_UPGRADE_HISTORY

ib_logfile0 mysql-bin.000001 performance_schema

ibdata1 mysql test

[root@localhost mysql]# ls /home/mysql_data/mysql

(出现这个问题可以到/home/mysql_data/mysql目录下查看“mysql.sock”文件是否存在)

ERROR 2002 (HY000): Can't connect to local MySQL serverthrough socket '/home/mysql_data/mysql/mysql.sock' (2)

[root@localhost init.d]# /etc/rc.d/init.d/mysql start

Shutting down MySQL. [ OK ]

[root@localhost init.d]# service mysql stop(停止服务)

MySQL running (4130) [ OK ]

(因为mysql服务已经被注册为系统自启动服务,学习6复古传奇官网。需要编辑my.conf,想知道of。并重命名为f

[root@localhost init.d]# service mysql status

(出现此问题可以思考是否mysql服务已经启动)

ERROR 1045 (): Access denied for user 'root'@'localhost'(using password: NO)

[root@localhost mysql]# /etc/rc.d/init.d/mysql start

[root@localhost mysql]#reboot(重启系统)

2. 重启mysql服务

datadir=/home/data/mysql

# datadir=/var/lib/mysql

then

if test -z "$datadir"

bindir=/usr/bin

basedir=/usr

then

skip-external-locking

socket = /home/mysql_data/mysql/mysql.sock

#socket = /var/lib/mysql/mysql.sock

port = 3306

[mysqld]

# The MySQL server

# Here follows entries for some specific programs

socket = /home/mysql_data/mysql/mysql.sock

#socket = /var/lib/mysql/mysql.sock

port = 3306

#password = your_password

[client]

为保证mysql能够正常工作,拷贝其中一个(比如:学习may。f)到/etc/目录下,Other。则需要到/usr/share/mysql/下找到*.cnf文件,学习传奇手游开区时间表。如果/etc/目录下没有f配置文件,学习新开中变传奇最大网站。在调整目录前需要停止mysql服务或者杀掉mysql进程

[root@localhost home]#

/etc/f

[root@localhost home]# find /etc/f

[root@localhost home]# cp /usr/share/mysql/f/etc/f

/usr/share/mysql/f/usr/share/mysql/f

/usr/share/mysql/f /usr/share/mysql/f/usr/share/mysql/f

[root@localhost home]# ls /usr/share/mysql/*.cnf

配置文件一般都在/etc目录下,学习trademarks。在调整目录前需要停止mysql服务或者杀掉mysql进程

4. 修改配置文件f

[root@localhost home]#

[root@localhost home]# mv /var/lib/mysql//home/mysql_data/

3. 把/var/lib/mysql整个目录移到/home/data

[root@localhost home]#service mysql stop (停止mysql服务)

Enter password:

[root@localhost home]# /usr/bin/mysqladmin -u root -pshutdown(杀掉mysql进程)

2. 未保证mysql所有文件正常且不被损坏或占用,names。更改mysql目录

lost+found mysql mysql_data sunny

[root@localhost home]# ls

[root@localhost mysql]# cd /home

[root@localhost mysql]# mkdir /home/mysql_data

1. 创建mysql_data目录

MySQL默认的数据文件存储目录为/var/lib/mysql。听说trademarks。假如要把目录移到/home/mysql_data目录需要如下操作:最新轻变合击传奇网站

3.优化mysql,theirrespective。听听手游热血传奇开服时间。修改mysql的root用户的密码

4 rows in set (0.00 sec)

+--------------------+

| test |

| performance_schema |

| mysql |

| information_schema |

+--------------------+

| Database |

+--------------------+

mysql> show databases;

Type 'help;' or '\h' for help. Type '\c' to clear the currentinput statement.

owners.

affiliates. Other names may be trademarks of theirrespective

Oracle is a registered trademark of Oracle Corporation and/orits

Copyright (c) 2000, 2010, Oracle and/or its affiliates. Allrights reserved.

Server version: 5.5.8 MySQL Community Server (GPL)

Your MySQL connection id is 7

Welcome to the MySQL monitor. Commands end with ; or \g.

Enter password:

[root@localhost bin]# mysql -u root -p

2.进入mysql数据库

[root@localhost mysql]#

ib_logfile0 localhost.localdomain.err mysql performance_schemaRPM_UPGRADE_MARKER-LAST

ibdata1 ib_logfile1 localhost.localdomain.pid mysql.sockRPM_UPGRADE_HISTORY test

[root@localhost mysql]# ls /var/lib/mysql

5. 重新进入/var/lib/mysql/查看mysql.sock文件存在了

[root@localhost bin]# mysqladmin -uroot password"manager"

4. 继续上面的操作,看着may。停止则service mysql stop

[root@localhost sbin]#/sbin/chkconfig--delmysql

把MySQL从启动服务组里面删除

[root@localhost sbin]#/sbin/chkconfig-- addmysql

如果没有注册则执行将mysql加入到系统的启动服务组里面去

Starting MySQL. [ OK ]

[root@localhost sbin]# service mysql start

如果已经注册则执行service mysql start启动服务,你看。可以通过/sbin/chkconfig–list命令检查mysql是否被注册为系统服务

mysql 0:off 1:off 2:on 3:on 4:on 5:on 6:off

[root@localhost /]# /sbin/chkconfig --list

一般情况下mysql安装完成后会被注册为系统服务,在需要启动时运行下面命令即可。other。

3. 开机自启动

[root@localhost]# /usr/bin/mysqladmin -u root -pshutdown

2. 停止服务

[root@localhost]# /etc/init.d/mysql start

1. MySQL安装完成后启动文件mysql在/etc/init.d目录下,超级变态传奇网页游戏。那先启动mysql服务吧

启动mysql的方式有很多

1.启动mysql服务

通过上面的几种检查结果可以初步断定mysql服务还没有启动,不存在

MySQL is not running [FAILED]

3. [root@localhost /]# /etc/rc.d/init.d/mysql status

2. 紧接着进入/var/lib/mysql下面查看”mysql.sock”文件是否存在,names。没有查找到

[root@localhost bin]#

[root@localhost bin]# netstat -pan|grep 3306 #查询结果为空

1.2 用netstat -pan|grep 3306查看短款的情况也可以

Active UNIX domain sockets (servers and established)

udp 0 0 :::5353 :::*

udp 0 0 :::*

udp 0 0 0.0.0.0:631 0.0.0.0:*

udp 0 0 0.0.0.0:111 0.0.0.0:*

udp 0 0 0.0.0.0:875 0.0.0.0:*

udp 0 0 0.0.0.0:5353 0.0.0.0:*

udp 0 0 0.0.0.0:872 0.0.0.0:*

udp 0 0 0.0.0.0:68 0.0.0.0:*

udp 0 0 0.0.0.0 0.0.0.0:*

tcp 0 0 :::22 :::* LISTEN

tcp 0 0 192.168.10.249 192.168.10.247:445ESTABLISHED

tcp 0 0 127.0.0.1:25 0.0.0.0:* LISTEN

tcp 0 0 127.0.0.1:631 0.0.0.0:* LISTEN

tcp 0 0 0.0.0.0:111 0.0.0.0:* LISTEN

tcp 0 0 0.0.0.0:878 0.0.0.0:* LISTEN

Proto Recv-Q Send-Q Local Address Foreign Address State

Active Internet connections (servers and established)

[root@localhost bin]# netstat -an

1.1 netstat –an命令查看mysql默认端口3306的情况,听听names。没有查找到

(说明:安装完client后直接执行不行,theirrespective。告诉我们不能连接到MySQLserver,要求检查mysqld是否在运行并且socket文件'/var/lib/mysql/mysql.sock'是否存在

tcp 0 0 127.0.0.1:25 0.0.0.0:* LISTEN

tcp 0 0 127.0.0.1:631 0.0.0.0:* LISTEN

tcp 0 0 0.0.0.0:111 0.0.0.0:* LISTEN

tcp 0 0 0.0.0.0:878 0.0.0.0:* LISTEN

Proto Recv-Q Send-Q Local Address Foreign Address State

Active Internet connections (servers and established)

[root@localhost bin]# netstat -an

1.1 netstat –an命令查看mysql默认端口3306的情况,听听新开中变传奇最大网站。变成了26个,be。由安装完server后的14个,那又是什么原因呢?

1. 查看mysql默认端口号3306是否被占用

(说明:想知道trademarks。安装完client后直接执行不行,并且有了mysqladmin文件

Check that mysqld is running and that the socket:'/var/lib/mysql/mysql.sock' exists!

error: 'Can't connect to local MySQL server through socket'/var/lib/mysql/mysql.sock' (2)'

mysqladmin: connect to server at 'localhost' failed

[root@localhost bin]# mysqladmin -u root passwordmanager

4.设置mysql的root管理员账号密码

mysql_zap

mysql_waitpid

mysql_upgrade

mysql_tzinfo_to_sql

mysqltest

mysqlslap

mysqlshow

mysql_setpermission

mysql_secure_installation

mysql_install_db

mysqlimport

mysqlhotcopy

mysql_fix_extensions

mysql_find_rows

mysqldumpslow

mysqldump

mysqld_safe

mysqld_multi

mysql_convert_table_format

mysqlcheck

mysqlbug

mysqlbinlog

mysqladmin

mysqlaccess.conf

mysqlaccess

mysql

(说明:听说新开超级变态传奇网站。安装完成后查看(ll/usr/bin/mysql*),/usr/bin/目录下多了很多文件,看看may。看看新开传奇网站。共发现14个文件或目录(mysqlbug、mysql_convert_table_format、mysqld_multi、mysqld_safe、mysqldumpslow、mysql_fix_extensions、mysqlhotcopy、mysql_install_db、mysql_secure_installation、mysql_setpermission、mysqltest、mysql_tzinfo_to_sql、mysql_upgrade、mysql_zap)确实没有mysqladmin,看着。怎么办呢?开始排错吧:

1:MySQL-client ###########################################[100%]

Preparing... ###########################################[100%]

[root@localhost mytools]# rpm -ivhMySQL-client-5.5.8-1.linux2.6.i386.rpm

3.安装mysql client

mysqladmin is part of the mysql-client package, so you have toinstall that package in order to use mysqladmin, mysql etc

3. 网上资料说只有安装了mysql-client端才会出现mysqladmin

2.4 启动脚本/etc/init.d(启动脚本文件mysql的目录)

2.3相关命令所在目录/usr/bin

2.2配置文件目录/usr/share/mysql(mysql.server命令及配置文件)

2.1数据库目录/var/lib/mysql/

2. 再去查看一下mysql server安装完成后各目录中的文件变化吧

1. 首先就是到/usr/bin目录下面查看所有以mysql开头的内容(llmysql*),你知道新开超级变态网页传奇。例如/etc/crontab

(说明:系统提示找不到mysqladmin这个文件或目录,传奇手机网游复古1.76。需要先SRPM(SourceCode)编译成RPM,还有*.src.rpm结尾的,of。需要到/usr/bin下设置root账号

bash: /usr/bin/mysqladmin: No such file or directory

[root@localhost mytools]# /usr/bin/mysqladmin -u root password“manager”

2.进入/usr/bin目录设定mysql的root账户密码

一些man page档案

/usr/share/man

一些基本的软件使用手册与说明文件

/usr/share/doc

一些程序使用的动态函式库

/usr/lib

一些可执行档案

/usr/bin

一些设定文件放置的目录,想知道单职业传奇手游官网。然后再安装

/etc

2.4RPM安装的程序都会被安装到预设目录中:我不知道theirrespective。

2.3主要安装以rpm结尾的安装包,传奇手游开区时间表。表明已经安装成功,be。并将/mnt下的mysql安装文件拷贝到/usr/local/mytools目录下

2.2语法:rpm参数 待安装程序.rpm

2.1RPM是以一种数据库记录的方式来将你所需要的套件安装到你的Linux主机的一套管理程序

2. RPM(RedHat Package Manager)语法解析:我不知道6复古传奇官网。

1. 出现以上信息,在/usr/local/下创建mytools目录,请忽略回车)

Please report any problems with the /usr/bin/mysqlbugscript!

See the manual for more instructions.

strongly recommended for production servers.

databases and anonymous user created by default. This is

which will also give you the option of removing the test

/usr/bin/mysql_secure_installation

Alternatively you can run:

/usr/bin/mysqladmin -u root -h localhost.localdomain password'new-password'

/usr/bin/mysqladmin -u root password 'new-password'

To do so, start the server, then issue the followingcommands:

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER!

1:MySQL-server ###########################################[100%]

Preparing... ###########################################[100%]

[root@localhost mytools]# rpm -ivhMySQL-server-5.5.8-1.linux2.6.i386.rpm

1.安装mysql server

(二) mysql的安装与配置

MySQL-client-5.5.8-1.linux2.6.i386.rpmMySQL-server-5.5.8-1.linux2.6.i386.rpm

[root@localhost mysql]# ls /usr/local/mytools/ (官网下载)

Linux localhost.localdomain 2.6.18-128.el5 #1 SMP Wed Jan 2110:44:23 EST 2009 i686 i686 i386 GNU/Linux

[root@localhost mysql]# uname -ar

4. 本文使用的安装程序为:

cp /mnt/Mysql-* /usr/local/mytools

mkdir mytools

cd /usr/local

3.进入linux终端,请忽略回车)

例子:mount –t cifs –o username=”mylovedog”,password=””//192.168.1.10/\@share_folder /mnt

//your_windows_ip_address/\@share_folder /linux挂载区

password=”your_windows_password”(此处空格,使windows与linux成功通信1. 首先在windows上面建立一个共享目录@share_folder, mount –t cifs –ousername=”your_windows_username”,(请忽略回车)

2. 进入linux进行挂载

(一) 挂载目录,

作者:叶岚 来源:mfiii_mf3简介
相关评论
发表我的评论
  • 大名:
  • 内容:
  • 新开传奇网站(www.rxqyjx.com) © 2019 版权所有 All Rights Reserved.
  • 新开传奇网站(rxqyjx.com)是中国最大的传奇私服游戏开服表.为热血传奇私服玩家提供最热门的新开传奇私服开服资讯,分享最专业的传奇私服发布网行业资讯。 冀ICP备15020076号-1
  • Powered by laoy! V4.0.6