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

This article mainly explains "how to open Mysql remote access". The content of the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "how to open Mysql remote access".

By default, Mysql cannot be accessed from a remote machine. Remote access can be enabled through the following configuration.

My Mysql environment is ubuntu+mysql5

1. Modify / etc/mysql/my.conf, modify bind-address, specify the actual IP address of the machine, and your my.con will look like the following

[mysqld]

#

# * Basic Settings

#

Default-character-set=utf8

Default-storage-engine=INNODB

Bind-address = 192.168.1.107

User = mysql

Pid-file = / var/run/mysqld/mysqld.pid

Socket = / var/run/mysqld/mysqld.sock

Port = 3306

Basedir = / usr

Datadir = / var/lib/mysql

Tmpdir = / tmp

Language = / usr/share/mysql/english

Skip-external-locking

two。 Log in to mysql with root and execute the following command

Grant all on sonardb.* to sonar@'%' identified by '123456'

Grant all on sonardb.* to sonar@localhost identified by '123456'

Sonardb is replaced with the name you want to access, sonar is the user name you want to use, and 123456 is replaced with your password, thus enabling remote access.

Thank you for reading, the above is the content of "how to turn on Mysql remote access". After the study of this article, I believe you have a deeper understanding of how to open Mysql remote access, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

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.