How to login to mySQL with a mySQL user account?

[motivex1]

Hi all! Does anyone know how i can log into my "mySQL" database with a mySQL user which i have created.


Many thanks!

 

[essellar]

MySQL can only be accessed locally on the server; remote access is blocked. You can access it via PHP code running on your hosting account as your user, or via web-based tools supplied in cPanel (phpMyAdmin) as your cPanel user.

 

[motivex1]

Hi essellar, i may have worded my thread wrong, i want to log into my phpMyAdmin database under a mySQL user which i have created with SUPER privellages.

Thanks

 

[essellar]

You'd need to put phpMyAdmin on your hosting account; going through cPanel logs you in automatically as your cPanel user. (Your cPanel user should have full permissions, about as close to root as you can get without actually being root.)

 

[motivex1]

So when i access my phpMYadmin database through cpanel i cannot create events as it says i need to be using an account with SUPER permissions...