![]() ![]() To filter this traffic you can use a firewall as iptables. Also, (I’m not going to explain how to do it) it is highly recommended that you only allow remote access to MySQL from the other MySQL servers. If you’re going to use these servers in production, it’s interesting that you secure them. To exit the MySQL client console run the “exit” command: mysql> exitĮxecute this test on both servers. To check that you can execute a command, show the databases that MySQL creates by default, with the command “show databases ” mysql> show databases Type '\c' to clear the current input statement. Other names may be trademarks of their respective owners. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Server version: 5.7.28 MySQL Community Server (GPL)Ĭopyright (c) 2000, 2017, Oracle and/or its affiliates. To do this, try to connect using the root user: $ mysql -u root -p Try in both servers that the server works well locally. Update the package information with the new repo: $ sudo apt updateĪnd install the MySQL server: $ sudo apt install mysql-serverĮnter the root password for the MySQL server: Testing the MySQL server Install the package: $ sudo dpkg -i mysql-apt-config_0.8.7-1_all.debĪdd the MySQL 5.7 repo because the default repo is the MySQL 8.0. Maybe when you download it, the version will be a bigger one.ĭownload the version using wget or curl: $ wget Go to the download page and get the filename of the executable (now is mysql-apt-config_0.8.13-1_all.deb). Execute the same process in both servers. You have to install MySQL 5.7 server on both servers. To update the packages you have to execute in each machine: $ sudo apt update
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |