redhat6.3安裝MySQL-server-5.6.13-1.el6.x86_64.rpm 首先下載下面三個文件： [plain] 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即可遠程登陸。
