Shulou(Shulou.com)05/31 Report--

This article will explain in detail how the win7 client connects to the CentOS6.6 MySQL database. The content of the article is of high quality, so the editor shares it for you as a reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

Server side:

OS: CentOS 6.6 x86_64

MySQL version: 5.1.73

Client:

OS: win7 32-bit

MySQL client tool: MySQL Workbench 6.3 CE

The win7 client connects to the CentOS6.6 MySQL database:

Steps:

One, one. Ensure that the MySQL database server is installed on the CentOS 6.6 x86slave 64-bit system.

You can use the command rpm-qa | grep mysql to see if it has been installed. If not, use the yum install mysql command to install it. Or install mysql in source code.

two。 Start the mysql server: service mysqld start

3. Enter the mysql command: mysql

4. Set the password for mysql: at the command prompt mysql > enter: SET PASSWORD FOR 'root'@'localhost'=PASSWORD (' billy123456')

5. Authorize the client IP on the mysql server:

-- assign permissions for root remote access to GRANT ALL PRIVILEGES ON *. * TO 'root'@'%' IDENTIFIED BY'billy123456' WITH GRANT OPTION

Note: the 'root'@'%'' in the command executed in the mysql console can be understood as follows: root is the user name,% is the host name or IP address, where the% represents any host or IP address, or you can replace it with any other user name or specify a unique IP address; 'billy123456' is the password assigned to the authorized user to log into the database In addition, it should be noted that what I have here is to authorize all permissions, and you can specify some permissions.

-- effective: FLUSH PRIVILEGES

6. Turn off Linux Firewall: service iptables stop

Install the client Mysql WorkBench download path: http://dev.mysql.com/downloads/workbench/

Choose the appropriate version based on the windows system you are using.

1. Need to install: vcredist_x86.exe before installing MySQL Workbench 6.3.7

two。 test.

About win7 client how to connect to the CentOS6.6 MySQL database to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.