cannot connect to database server mysql workbench

If you are unable to connect go to step 9. You can get all the ports with the command 'sudo ufw status'). If you are able to connect, reset the firewall with the command 'sudo ufw reset' (Make sure you take a copy or screenshot of all the connections in the firewall.On your server, disable the firewall and check if you are able to connect.Step 6: If you are still not able to connect In the Password, enter your server password.In the Username, enter your server user name.In the Server Port, leave as it is '3306' unless you have changed the port of MySql in your server.In the Hostname, enter your server IP address.In the Connection Method field, select 'Standard TCP/IP'.I created a user in MySQL to avoid logging in using the root using the command 'CREATE USER IDENTIFIED BY 'password' Now, enable connections to the MySql port 3306 (default) from a particular IP address using the command 'sudo ufw allow from to any port 3306' or you can allow all connections to the port from any IP address is your IP address keeps changing using the command 'sudo ufw allow mysql' Check the status using 'sudo ufw status'. Start the UFW if it is not yet enabled using the command 'sudo ufw enable'. I used UFW (Uncomplicated FireWall) to change the settings. To allow outside connections, you should change the settings of the firewall. Step 3:Changing the Firewall Settings of Ubuntu First find the Process ID of MySQL using 'ps ax | grep mysql' then kill the process using 'sudo kill ' If you are unable to restart, kill MySQL Process. To do that, you can restart using the command 'sudo service mysql restart'. I used ctrl+x to close and entered 'Y' to save the file. Using arrow keys, I scrolled down to the row with 'bind-address' and I changed it from '127.0.0.1' to '0.0.0.0'. On the Ubuntu machine (where my MySQL Community Server is installed) using Putty, I changed the mysqld.cnf file with the command 'sudo nano /etc/mysql//mysqld.cnf'. Step 1:Changing the bind address in MyMySQL But, here are the things that I did to connect via TCP/IP which was also useful for me to connect to MySQL via my code: To get connected to MySQL Workbench installed on Windows 10, I found the above post written by Shihab and edited by Dharman useful to get connected instantly. If there is no skip-networking line, you must comment out the line: bind-address = 127.0.0.1 In the my.cnf file, the skip-networking line has to be removed or commented out.

This isn't always the case, especially on web hosting platforms. To see all the grants you currently have on localhost so that you can duplicate them for the remote host: SHOW GRANTS FOR the MySQL server needs to be setup to accept remote connections in the first place.

In PhpMyAdmin, you will need to grant access to your database from the remote host: (See also Pekka's answer for how to allow connections from any host) GRANT ALL PRIVILEGES on dbname.* TO IDENTIFIED BY 'yourpassword' Your machine on which Workbench is installed must access MySQL with different credentials than your The server requires you to grant access to your username from any host you intend to connect from. On PHPMyadmin, the database is running on the same server as the web server, and therefore refers to itself as localhost, with IP 127.0.0.1. You can have a different password from your home machine than the one you use on the server itself, and you can have entirely different sets of permissions granted to the same username from different origin hosts. MySQL treats logins as specific to the host they originate from.

Cannot connect to database server mysql workbench