redhat 6.3 安装mysql5.6教程

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

    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>  SET PASSWORD = PASSWORD('123456'); 

    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即可远程登陆。