![]() To resolve this, make sure that the firewall is either down, or the rules are correct to allow you to connect to the remote MySQL server.Ĭheck the status of the firewall by using the following command:Īs shown above, the firewall is active.The main console utilities for working with MySQL are located in the directory where MySQL Server is installed. In a situation like this, the error Network error: Connection timed out may appear: ![]() user Īnother common problem that can occur when trying to connect to a remote MySQL server is when Uncomplicated Firewall (UFW) is active, and traffic on port 22 is not allowed. SELECT user, authentication_string, plugin, host FROM mysql. ![]() Now, check the authentication methods of MySQL user accounts and type the following code: To change this, open the MySQL prompt from a terminal: If the ERROR 1698 (28000): Access denied for user appears when trying to connect to the remote MySQL server when using the root user, the authentication method from auth_socket to mysql_native_password needs to be changed. Now, type and run the mysql -u root -p command for a root user or for a user who has permission to connect to a remote MySQL server: To check the connection, execute some commands, for example, ls -l: When logged in, the terminal should look like this: Press Enter and type a password for that user: In the login as, type the username that will be used to connect to the remote machine. The PuTTY Security Alert warning dialog appears the first time you connect. In the Host Name (or IP address) box, under the Session tab, enter the IP address of the remote machine and click the Open button: Now, go to the local Windows machine and launch PuTTY. Go to Linux Ubuntu 18.04 and in the Terminal, type ifconfig or the IP address command and see information under inet: To connect to a remote MySQL server, you’ll need its IP address. Click the Install button:Īfter the successful installation, click the Finish button to close the PuTTY installer: If you plan to use PuTTY frequently, add a PuTTY shortcut to the Desktop. In the Product Features step, select the way you want the features installed. Click the Next button to continue:ĭuring the Destination Folder step, choose where the PuTTY client will be installed: For the purpose of this article, we’ll use the 64-bit PuTTY client to connect to the remote MySQL server.ĭouble click on the putty-64bit-installer.msi installer. There are many SSH clients for Windows OS. If the SSH server is not running, type and execute the sudo systemctl start ssh command. To verify that the installation was successful and the SSH service is running, type and run the sudo systemctl status ssh command: Then press Y and Enter to continue with the installation: Press the Enter key and type user password when prompted. To install Secure Shell (SSH) on Linux Ubuntu 18.4, from the Terminal type the sudo apt install openssh-server command. To see the status of MySQL, type and run the service mysql status command:Įxecute the sudo service mysql start command: To see which version is installed on the machine, type and run the mysql –version command:įor detailed information on how to install and configure MySQL, please visit the How To Install MySQL on Ubuntu 18.04 page.Īfter setting up MySQL, make sure it is active and running. Next, in the Terminal, type the sudo apt-get install mysql-server command to start installing MySQL: On Linux Ubuntu 18.4, open the Terminal, type the sudo apt-get update command and press the Enter key:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |