Ubuntu under MySQL settings allow remote connections

Ubuntu: Installing Mysql-server,sudo apt-get Install Mysql-server

MySQL install after successful view MySQL status:/etc/init.d/mysql status

Appears: The MySQL service is in a running state;

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/6F/5F/wKioL1WaZ4qAsZkBAAKhFTxq75k887.jpg "title=" 20150706192530.png "alt=" Wkiol1waz4qaszkbaakhftxq75k887.jpg "/>

Figure 1

If the display appears, the MySQL service does not start, 650) this.width=650; "Src=" http://s3.51cto.com/wyfs02/M02/6F/5F/ Wkiol1waajxdw2a2aaalk7auons256.jpg "title=" Qq20150706193006.png "alt=" Wkiol1waajxdw2a2aaalk7auons256.jpg "/>

Run: Sudo/etc/init.d/mysql start MySQL Service

The situation is started successfully: 650) this.width=650; "Src=" http://s3.51cto.com/wyfs02/M00/6F/5F/wKioL1WaaUHTbL6_AADgfdRSXYA347.jpg " Title= "Qq20150706193247.png" alt= "Wkiol1waauhtbl6_aadgfdrsxya347.jpg"/>

After you have determined that the MySQL service started successfully, allow remote connection settings for MySQL:

Method One:

1. Add the following in the/etc/mysql/my.cnf file:

bind-address = 127.0.0.1-> #bind-address = 127.0.0.1//That is, comment on this line of content

2. Run the command to log in to MySQL:

Mysql-u root-p (enter key)

Will alert you to the password for root (enter key)

The login succeeds if the following happens

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/6F/61/wKiom1WaaZyDhQBKAAQfwZxRoWU278.jpg "title=" Qq20150706194212.png "alt=" Wkiom1waazydhqbkaaqfwzxrowu278.jpg "/>

3. For the user table operation in the MySQL database:

Use MySQL;

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/6F/5F/wKioL1WabBaBn5FQAAA0SugEnJQ961.jpg "title=" Qq20150706194423.png "alt=" Wkiol1wabbabn5fqaaa0sugenjq961.jpg "/>

Select User.password,host from user;650) this.width=650; "Src=" http://s3.51cto.com/wyfs02/M01/6F/61/ Wkiom1waapkbokklaalhb6sfrh8326.jpg "title=" Qq20150706194607.png "alt=" Wkiom1waapkbokklaalhb6sfrh8326.jpg "/>

User: Indicates the users who are allowed to link to the database

Password: Represents the user password that allows the linked database

Host: Represents the hosting address that allows the linked database

4. Set allow remote connection to database

Using statements:

GRANT all privileges the data.* to ' datauser ' @ ' percent ' identified by ' Datauser ' with GRANT OPTION;

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/6F/5F/wKioL1Wabv6Qml86AAFIj6txcT0211.jpg "title=" Qq20150706195725.png "alt=" Wkiol1wabv6qml86aafij6txct0211.jpg "/>

In operation: select User.password,host from User;

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/6F/5F/wKioL1Wab0viXlJJAAMAJd3y1Ng479.jpg "title=" Qq20150706195842.png "alt=" wkiol1wab0vixljjaamajd3y1ng479.jpg "/>user table has a new set of user link information

Now test with other hosts to see if they can be linked:

Here I use the Navicat link:

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/6F/62/wKiom1WabkWAa0EsAAE9yWzWyVc959.jpg "title=" Qq20150706200203.png "alt=" Wkiom1wabkwaa0esaae9ywzwyvc959.jpg "/>

Click the test Link:

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/6F/5F/wKioL1WacEjRBgeXAAEIegowrFU173.jpg "title=" Qq20150706200253.png "alt=" Wkiol1wacejrbgexaaeiegowrfu173.jpg "/>

Prompt connection success;

Click OK to see if the database exists:

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/6F/5F/wKioL1WacI7CiXJaAAA0ZW_fU6c894.jpg "title=" Qq20150706200408.png "alt=" Wkiol1waci7cixjaaaa0zw_fu6c894.jpg "/>

Presence, said face set success.

You can now operate the database on any other computer.

This article is from the "Knight" blog, make sure to keep this source http://knight328.blog.51cto.com/7480408/1671437

Ubuntu under MySQL settings allow remote connections