![]() ![]() You can do this by adding an exception in default Ubuntu's firewall with this command: It is important to ensure that your server's firewall is not blocking the incoming on port 3306 connections. ![]() You can make the MySQL service listen to incoming connections on all interfaces on 0.0.0.0 using this command: MySQL listens to port 3306 connections by default. $ sudo systemctl enable mysql Step 5: Listening to incoming connections The following command does the task:Īfter restarting, you can also enable MySQL to start up after the system reboots automatically using the command: Step 4: Restarting MySQLįor the changes to reflect, as explained above, you need to restart MySQL. Now, change the bind-address line to 0.0.0 inplace of 127.0.0.1. Thus, it's necessary to change the MySQL configuration file line for allowing remote access. It is recommended to keep it the same way unless a remote user or an external web server connection wants to access it. MySQL is accessible from the local PC by default. $ sudo mysql_secure_installation Step 3: Giving access $ sudo apt install mysql-server Step 2: Securing MySQL serverĪfter the installation is completed, it is first needed to secure it using the following command: Step 1: Initialising installationįor installing MySQL Server, the following command is given in the terminal: With the MySQL server, you can access the database from the local machine or remote client as well, which are using the MySQL Client. MySQL server hosts several MySQL databases on Ubuntu 20.04 system.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |