Detailed explanation of how to access MySQL database remotely through Workbench

Preface

Workbench is installed on one computer, and now you need to access the MySQL database on another Ubuntu server. However, access to MySQL is not allowed by default. Considering security issues, it is not suitable to use the root user to access MySQL.

At this time we need to open the MySQL server and create a new user to access MySQL.

1. Open MySQL

The mysql configuration file is in the /etc/mysql/my.cnf file. There is a line in it that says bind-address = 127.0.0.1 , which means that only local access is allowed. Just comment this line.

2. Create a new mysql user

(1) First, enter the MySQL database locally.

(2) Create a user: GRANT ALL ON *.* to user@'IP' IDENTIFIED BY 'password'; user indicates the name of the user to be created; IP indicates which client wants to access the MySQL database; password indicates the password; and grant all permissions.

(3) FLUSH PRIVILEGES; refresh the MySQL system permission related tables, otherwise access will be denied. Restarting the database can also achieve this effect

3. Restart the database

Use the command sudo service mysql restart to restart the database

4. Use workbench to connect to the database

The host name indicates the database IP address that needs to be connected

The effect of successful connection

Click to enter the page

Note: You cannot access mysql in the Docker container environment in the Ubuntu server

Summarize

The above is the full content of this article. I hope that the content of this article can bring some help to your study or work. If you have any questions, you can leave a message to communicate. Thank you for your support of 123WORDPRESS.COM.