[Solved] Remote Mysql Error: Can't Access

[maicol07]

Hi,

I've activated remote mysql from CPanel, setting IP adress as % . However, on SQLYog (a MySQL client for Windows) when I execute a query I got this error:

Query:
USE `maicol_gamer`

Error occured at:2017-12-09 19:09:04
Line no.:16
Error Code: 1044 - Access denied for user 'maicol07_user'@'%' to database 'maicol_gamer'

Do you know how to solve this?

Thanks!

[Bailey]

Are all your credentials correct?

[maicol07]

Yes

[Bailey]

Perhaps the databases and usernames are case sensitive, have you checked them?

[maicol07]

Yes. It's all lower-case

[Bailey]

Okay, may I please have the snippet of code that connects to your database?

[maicol07]

I'm trying to connect from a MySQL Windows Desktop Client...

[Bailey]

Okay, have you got the host set to [server].heliohost.org?

[maicol07]

Yes

[Bailey]

Have you added the user to the database with all permissions? This can be done in cPanel through MySQL databases.

[maicol07]

Yes

[Bailey]

Then it should work, can you send me a screenshot of the program you are using, on the screen where you enter your details?

[wolstech]

Did you add your PC's public IP to remote mysql? And as Bailey said, the user needs to be assigned to the database as well.

[maicol07]

Did you add your PC's public IP to remote mysql? And as Bailey said, the user needs to be assigned to the database as well.

 

I have added % in the IP

 

Then it should work, can you send me a screenshot of the program you are using, on the screen where you enter your details?

 

Edited December 9, 2017 by maicol07

[Bailey]

That looks right to me, give me a moment to check things over.

 

Okay it must be somethings to do with your user.

 

Have you done this: (image)? And then clicked add?