CentOS Install MySQL

Environment and Resources

PC System: Centos 6.5 32-bit

MySQL Server 5.6

URL: http://cdn.mysql.com//Downloads/MySQL-5.6/MySQL-server-5.6.27-1.el6.i686.rpm

MySQL Client 5.6

URL:http://cdn.mysql.com//Downloads/MySQL-5.6/MySQL-client-5.6.27-1.el6.i686.rpm

See if MySQL is installed

#rpm-qa | grep MySQL

If there is, force delete

#rpm-E--nodeps mysql-libs-5.1.73-5.el6_6.i686

Install MySQL

1) Download MySQL server and MySQL Client

#wget http://cdn.mysql.com//Downloads/MySQL-5.6/MySQL-server-5.6.27-1.el6.i686.rpm

#wget http://cdn.mysql.com//Downloads/MySQL-5.6/MySQL-client-5.6.27-1.el6.i686.rpm

2) Unzip

#rpm-IVH mysql-server-5.6.27-1.e16.i686.rpm

#rpm-IVH mysql-client-5.6.27-1.e16.i686.rpm

Note: If the following error occurs

Workaround:

#yum Install libaio.so.1 libnuma.so.1

Using MySQL

1) After installing the default profile in/usr/share/mysql/my-default.cnf, copy the my-default.cnf to/ETC/MY.CNF

#cp/usr/share/mysql/my-default.cnf/etc/my.cnf

2) Start MySQL

#/etc/init.d/mysql start

3) MySQL Client connection

#mysql-uroot

Workaround: (Modify root user password)

/etc/init.d/mysql Stop (service mysqld stop)
/usr/bin/mysqld_safe--skip-grant-tables
also open an SSH connection
[[email protected] ~]# MySQL
mysql>use MySQL
mysql>update User Set Password=password ("") where user= "root";
Mysql>flush privileges;
Mysql>exit

4) Use the MySQL client connection again

#/etc/init.d/mysql start (start MySQL service)

#mysql-uroot

CentOS Install MySQL