My Visual Database 5.2 Free Tool You

Connect failed: Access denied for user rootlocalhost (using password: YES) I downloaded the latest version of both Mysql server and Workbench which is 8.0 Please let me know what wrong I am doing here.

My Visual Database 5.2 Free Tool You

MySQL Workbench is a free tool you can use to connect to your server databases from your personal computer.

The file we are installing in this tutorial is the mysql-workbench-gpl-5.2.47-win32.msi file.

Once you have downloaded MySQL Workbench, you can install it onto your computer.

After you have the program installed, follow the steps below to set up a remote connection.

Add IP to your Remote MySQL In order for you to be able to connect to your databases remotely you will need to add your local computer IP address to the Remote MySQL in cPanel.

You can get your IP address by going to the following link: Whats My IP address Steps to connect to your database remotely Open MySQL Workbench.

Click New Connection towards the bottom left of MySQL Workbench.

In the Set up a New Connection Dialogue box, Type your Database connection credentials.

The credentials will be like the following: Connection Name: You can name this whatever you like.

Hostname: You can use your domain our your cPanel IP address.

Port: 3306 Username: Your cPanel username or the user you created for the database.

Password: cPanel password or the password for the database user that was created.

Type your password and click the Save Password in Vault check box.Click Ok.

MySQL Workbench should say Connection parameters are correct.

Click Ok. Click Ok again to accept the connection settings.

Now under the SQL Development section you will see your connection listed in the Open Connection to Start Querying box.

When I try to follow the steps above It says your connection attempt failed for user xxxx from your host to server at yyyyyyy: cannot connect to MySQL server on yyyyyyy(10060) Reply Alyssa Kordek says: April 14, 2020 at 3:52 pm Hello Adel, Thank you for your reply.

Based on the information provided, it seems likely that the IP address used to connect is incorrect.

If the issue persists I recommend contacting Technical Support for direct assistance.

Reply Adel Dadaa says: April 15, 2020 at 4:22 pm Thanks Alyssa, yes there was wrong as you said.

Now works fine. Thank you Gerald says: February 28, 2020 at 2:25 am Very helpful thank you Reply Ronnie says: February 28, 2020 at 9:28 am Glad it helped Reply varun khandelwal says: July 19, 2019 at 7:38 pm Hi.

I have login to windows administrator and connect to remote SQL server but if i login to non-administrator account then not able to connect to remote sql server.

Reply Unknown says: March 1, 2019 at 5:19 am HI I have a question is that for the server only if YES then what step am i going to set for the other pc that is connected with the same hotspot with the server Reply InMotionFan says: March 2, 2019 at 9:36 pm Yes these instructions can be used to connect your computer to the server via the MySQL service.

If you are trying to connect a PC to PC on the same network, you will need to use the local IP address ( found on your internal network ) as the hostname.

Reply Inmotion Fan says: January 16, 2019 at 12:49 am Hi Thanks for the detailed explanation.