RedHat 6.3安裝MySQL-server-5.6.13-1.el6.x86_64.rpm

在RedHat 6.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 --replacefiles MySQL-s*.rpm

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

rpm -ivh --replacefiles MySQL-c*.rpm

[root@localhost download]# rpm -ivh --replacefiles MySQL-server-5.6.13-1.el6.x86_64.rpm 
Preparing...                ########################################### [100%] 
  1:MySQL-server          ########################################### [100%] 
[root@localhost download]# rpm -ivh --replacefiles MySQL-client-5.6.13-1.el6.x86_64.rpm 
Preparing...                ########################################### [100%] 
  1:MySQL-client          ########################################### [100%] 
[root@localhost download]# rpm -ivh --replacefiles MySQL-devel-5.6.13-1.el6.x86_64.rpm 
Preparing...                ########################################### [100%] 
  1:MySQL-devel            ########################################### [100%]

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

2. 初始化資料庫：

/usr/bin/mysql_install_db

3. 啟動mysql服務：

service mysql start

使用命令ps -ef | grep mysql 查看mysql進程：

[root@localhost ~]# ps -ef | grep mysql 
root    26047    1  0 18:14 pts/12  00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/localhost.localdomain.pid 
mysql    26227 26047  0 18:14 pts/12  00: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 
root    26545 24726  0 18:27 pts/8    00:00:00 grep mysql

4.第一次登陸設定root密碼：

首先查看 cat /root/.mysql_secret

root@localhost ~]# cat /root/.mysql_secret 
# The random password set for the root user at Fri Aug 30 15:57:18 2013 (local time): fMYcarvB

然後命令列：mysql -u root -p ，然後輸入上面的密碼即可：

[root@localhost ~]# mysql -u root -p 
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g. 
Your MySQL connection id is 5 
Server version: 5.6.13 MySQL Community Server (GPL) 
 
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. 
 
Oracle is a registered trademark of Oracle Corporation and/or its 
affiliates. Other names may be trademarks of their respective 
owners. 
 
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

設定root密碼：

mysql> use mysql 
Database changed 
mysql> update user set password=password('root') where user='root'; 
Query OK, 0 rows affected (0.15 sec) 
Rows matched: 5  Changed: 0  Warnings: 0 
 
mysql> flush privileges; 
Query OK, 0 rows affected (0.00 sec)

退出，重新登陸即可使用新的密碼登陸；

5. 設定遠程登陸：

使用root登陸到mysql後

mysql> update user set host='%' where user='root'; 
ERROR 1062 (23000): Duplicate entry '%-root' for key 'PRIMARY' 
mysql> select host,user from user; 
+-----------------------+------+ 
| host                  | user | 
+-----------------------+------+ 
| %                    | root | 
| 127.0.0.1            | root | 
| 192.168.128.142      | root | 
| ::1                  | root | 
| localhost.localdomain | root | 
+-----------------------+------+ 
5 rows in set (0.00 sec)

然後：

mysql> grant all privileges on *.* to 'root'@'%' with grant option; 
Query OK, 0 rows affected (0.08 sec) 
 
mysql> exit 
Bye 
[root@localhost ~]# service mysql restart 
Shutting down MySQL.. SUCCESS! 
Starting MySQL.. SUCCESS! 
重啟mysql即可遠程登陸。