cancel
Showing results for 
Search instead for 
Did you mean: 

Cannot connect to MySQL Database using MySQL Workbench

I just created my first MySQL DB and setup its user with all privileges. My problem now is that i cannot connect to it in MySQL Workbench using the credential that i created.

 

Here is my error: 

 

[Window Title]
MySQL Workbench

[Main Instruction]
Failed to Connect to MySQL at  ip3306 with user

[Content]
Access denied for user 'user'@'ip' (using password: YES)

[OK]

 

I also cannot found the Enable Direct Access which i saw in some forums because i'm now using the new cPanel.

 

The only options now in the new cPanel are:  

 

MyPHP ADmin , Rmote mySQL , MySQL DB Wizard , My SQL Databases

 

Please help, i need to move on to my web site design.

 

Thanks!

 

2 REPLIES 2
Helper VI Helper VI
Helper VI

Re: Cannot connect to MySQL Database using MySQL Workbench

We typically use phpMyadmin to manage our databases(preferred method). Launch phpMyadmin and you should be able to manage your data base from there.

 

If for some reason you really need workbench, (I understand because I use PHPStorm with built in db checking and parsing) you have to allow your self to connect from a remote location. You'll have to do this through phpMyadmin or through your terminal. The query would look something like this:

GRANT ALL PRIVILEGES ON *.* TO 'yourUserNmae'@'%' IDENTIFIED BY 'yourPassWord'

 

~Jan Mykhail Hasselbring Web Administrator @ fullstackwebsolution.com

Re: Cannot connect to MySQL Database using MySQL Workbench

After running the sql just described i get the error message " Access denied for user 'cpses_ytKNi46QJd'@'localhost' (using password: YES)"

 

What is the password for 'cpses_ytKNi46QJd'?