RHEL6.4 install MySQL 5.6.27

RHEL6.4 install MySQL 5.6.27

RHEL6.4 install MySQL 5.6.27

Download (temporary address. If not available, please download it from the Oracle website)

Use rpm to install mysql Server:

Ftp://pepstack.com/pub/rpm/MySQL-server-5.6.27-1.el6.x86_64.rpm

To install the mysql client:

Ftp://pepstack.com/pub/rpm/MySQL-client-5.6.27-1.el6.x86_64.rpm

Ftp://pepstack.com/pub/rpm/MySQL-devel-5.6.27-1.el6.x86_64.rpm

Server Installation Process:

Delete the old one:

# Rpm-qa | grep-I mysql

Mysql-libs-5.1.66-2.el6_3.x86_64

# Rpm-ev -- nodeps mysql-libs-5.1.66-2.el6_3.x86_64.

Caution: you may need to delete the old file (if any ):

# Rm-f/etc/my. cnf

# Rm-rf/usr/var/lib/mysql

Install the new version:

# Rpm-ivh./MySQL-server-5.6.27-1.el6.x86_64.rpm

Client installation process:

# Rpm-ivh./MySQL-client-5.6.27-1.el6.x86_64.rpm

# Rpm-ivh./MySQL-devel-5.6.27-1.el6.x86_64.rpm

Start and log on to the server:

# Service mysql start

# Mysql-u root

ERROR 1045 (28000): Access denied for user 'root' @ 'localhost' (using password: NO)

Solve this error:

1. Stop the mysql service:

# Service mysql stop

2. Start the mysql service and skip verification:

# Mysqld_safe -- skip-grant-tables &

3. log on to mysql:

# Mysql -- user = root mysql

4. Set the root user password:

Mysql> update user set Password = PASSWORD ('abc1234 ');

Mysql> flush privileges;

Mysql> exit;

5. Now the mysqld_safe process can be killed:

# Killall mysqld_safe &

6. Restart the mysql service:

# Service mysql start

View Port:

# Netstat-nat | grep 3306

Client Logon (ipaddr is the IP address of the mysql server ):

# Mysql-u root-h ipaddr-pabcd1234