CentOS 6.5 under RPM Yum Warehouse Online installation mysql5.7 non-compile

1. View the current local repository MySQL (there is not necessarily a native installed meaning, can be understood as a resource file)

grep MySQL

2. Removal

Yum -y remove mysql-libs*

3. Open the MySQL website http://dev.mysql.com/downloads/repo/yum/

4. Select MySQL version as needed, here I choose the second one

　　

　　

5. No registration required, the address is on this page

　　

6. Copy this address and enter it under terminal

wget http://dev.mysql.com/get/mysql57-community-release-el6-8.noarch.rpm

It's done soon.

Next, just wait for the installation

7. Initialization after installation is complete

On #mysql自启动
/etc/init.d/mysqld Start #启动mysql

Mysql_secure_installation #设置mysql the root account password

will appear enter current password for root press ENTER

Does the Set root password appear again? [y/n] Press ENTER

Enter the password to confirm the password.

Then there will be four confirmations, namely:

Remove anonymous users? [y/n]
Disallow Root login remotely? [y/n]
Remove test database and access to it? [y/n]
Reload privilege tables now? [y/n]

All go straight to the carriage.

Complete.

If MySQL doesn't log in, it's 5.7. The default is not a blank password.

VI /ETC/MY.CNF

Insert two rows after [mysqld]

skip-grant-Tablesskip-networking

Then restart Mysqld, and it will become a blank password login.

Report:

Navicat remote connection Linux under MySQL server error 1130

mysql-hlocalhost-u root-p go to MySQL

Use MySQL to switch to MySQL this database

Update user Set Host = '% ' where user = ' root ';

A mistake is reported, but it can be ignored

quit MySQL

/etc/init.d/mysqld Restart restart MySQL

CentOS 6.5 under RPM Yum Warehouse Online installation mysql5.7 non-compile