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:
Failed to Connect to MySQL at ip3306 with user
Access denied for user 'user'@'ip' (using password: YES)
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.
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'
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'?