redhat6.3安装MySQL-server-5.6.13-1.el6.x86_64.rpm

首先下载下面三个文件：

MySQL-client-5.6.13-1.el6.x86_64.rpm
MySQL-devel-5.6.13-1.el6.x86_64.rpm
MySQL-server-5.6.13-1.el6.x86_64.rpm

然后使用root账号登陆，进行安装：

1. 安装server、devel、client：1. 安装server、devel、client：

rpm-ivh--replacefilesMySQL-s*.rpm

rpm -ivh --replacefiles MySQL-d*.rpm

rpm-ivh--replacefilesMySQL-c*.rpm

1. [root@localhostdownload]#rpm-ivh--replacefilesMySQL-server-5.6.13-1.el6.x86_64.rpm
2. Preparing...###########################################[100%]
3. 1:MySQL-server###########################################[100%]
4. [root@localhostdownload]#rpm-ivh--replacefilesMySQL-client-5.6.13-1.el6.x86_64.rpm
5. Preparing...###########################################[100%]
6. 1:MySQL-client###########################################[100%]
7. [root@localhostdownload]#rpm-ivh--replacefilesMySQL-devel-5.6.13-1.el6.x86_64.rpm
8. Preparing...###########################################[100%]
9. 1:MySQL-devel###########################################[100%]

要移除安装可以使用rpm-eMySQL-server、rpm-eMySQL-devel、MySQL-client即可；

2.初始化数据库：

/usr/bin/mysql_install_db

3.启动mysql服务：

servicemysqlstart

使用命令ps-ef|grepmysql查看mysql进程：

1. [root@localhost~]#ps-ef|grepmysql
2. root260471018:14pts/1200:00:00/bin/sh/usr/bin/mysqld_safe--datadir=/var/lib/mysql--pid-file=/var/lib/mysql/localhost.localdomain.pid
3. mysql2622726047018:14pts/1200:00:01/usr/sbin/mysqld--basedir=/usr--datadir=/var/lib/mysql--plugin-dir=/usr/lib64/mysql/plugin--user=mysql--log-error=/var/log/mysqld.log--pid-file=/var/lib/mysql/localhost.localdomain.pid--socket=/var/lib/mysql/mysql.sock
4. root2654524726018:27pts/800:00:00grepmysql

4 .第一次登陆设置root密码：

首先查看cat/root/.mysql_secret

1. root@localhost~]#cat/root/.mysql_secret
2. #TherandompasswordsetfortherootuseratFriAug3015:57:182013(localtime):fMYcarvB

然后命令行：mysql-uroot-p，然后输入上面的密码即可：

1. [root@localhost~]#mysql-uroot-p
2. Enterpassword:
3. WelcometotheMySQLmonitor.Commandsendwith;or\g.
4. YourMySQLconnectionidis5
5. Serverversion:5.6.13MySQLCommunityServer(GPL)
7. Copyright(c)2000,2013,Oracleand/oritsaffiliates.Allrightsreserved.
9. OracleisaregisteredtrademarkofOracleCorporationand/orits
10. affiliates.Othernamesmaybetrademarksoftheirrespective
11. owners.
13. Type'help;'or'\h'forhelp.Type'\c'toclearthecurrentinputstatement.

设置root密码：

1. mysql>usemysql
2. Databasechanged
3. mysql>updateusersetpassword=password('root')whereuser='root';
4. QueryOK,0rowsaffected(0.15sec)
5. Rowsmatched:5Changed:0Warnings:0
7. mysql>flushprivileges;
8. QueryOK,0rowsaffected(0.00sec)

退出，重新登陆即可使用新的密码登陆；

5.设置远程登陆：

使用root登陆到mysql后

1. mysql>updateusersethost='%'whereuser='root';
2. ERROR1062(23000):Duplicateentry'%-root'forkey'PRIMARY'
3. mysql>selecthost,userfromuser;
4. +-----------------------+------+
5. |host|user|
6. +-----------------------+------+
7. |%|root|
8. |127.0.0.1|root|
9. |192.168.128.142|root|
10. |::1|root|
11. |localhost.localdomain|root|
12. +-----------------------+------+
13. 5rowsinset(0.00sec)

然后：

1. mysql>grantallprivilegeson*.*to'root'@'%'withgrantoption;
2. QueryOK,0rowsaffected(0.08sec)
4. mysql>exit
5. Bye
6. [root@localhost~]#servicemysqlrestart
7. ShuttingdownMySQL..SUCCESS!
8. StartingMySQL..SUCCESS!

重启mysql即可远程登陆。

分享，快乐，成长

转载请注明出处：http://blog.youkuaiyun.com/fansy1990