Redhat6.3 MySQL-server-5.6.13-1.el6.x86_64.rpm Installation

Redhat6.3 install the MySQL-server-5.6.13-1.el6.x86_64.rpm first download the following three files: [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 and then log in with the root account for installation: 1. install server, devel, and client: 1. install server, devel, client: rpm-ivh -- replacefiles MySQL-s *. rpm-ivh -- replacefiles MySQL-d *. rpm-ivh -- replacefiles MySQL-c *. rpm [root @ localhost download] # rpm-ivh -- repla The cefiles 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 ##################################### ###### [1, 100%] [root @ l Ocalhost download] # rpm-ivh -- replacefiles MySQL-devel-5.6.13-1.el6.x86_64.rpm Preparing... ######################################## ### [100%] 1: mySQL-devel ##################################### ###### [100%] to remove and install, you can use rpm-e MySQL-server, rpm-e MySQL-devel, and MySQL-client; 2. initialize the database:/usr/bin/mysql_install_db 3. start mysql service: service mysql start run the command ps-ef | grep mysql to view the mysql process: [root @ localhost ~] # Ps-ef | grep mysql root 26047 1 0 00:00:00 pts/12/bin/sh/usr/bin/mysqld_safe -- datadir =/var/lib/mysql -- pid-file = /var/lib/mysql/localhost. localdomain. pid mysql 26227 26047 0 00:00:01 pts/12/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 -- s Ocket =/var/lib/mysql. sock root 26545 24726 0 00:00:00 pts/8 grep mysql4. set the root password for the first login: first check 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 then command line: mysql-u root-p, then enter The above password: [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,201 3, 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; 'o R' \ H' for help. type '\ C' to clear the current input statement. set the root password: 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) Quit. Log On again and use the new password to log on. 5. set remote login: Use root to log on to mysql and then 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) then: mysql> grant all privileges on *. * to 'ro Ot '@' % '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! Restart mysql to log on remotely.