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 #Install mysql ubuntu install$ 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 |