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: Installed Linux Ubuntu 18.04 on a remote machineįirst, you must install MySQL on the remote Linux machine. ![]() Installed Windows 10 OS on a local machine This article will explain how to set up a connection from a Windows host OS using a PuTTY client to a remote MySQL server on Linux Ubuntu 18.04.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |