maicol07 Posted December 9, 2017 Share Posted December 9, 2017 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! Link to comment Share on other sites More sharing options...
Bailey Posted December 9, 2017 Share Posted December 9, 2017 Are all your credentials correct? Link to comment Share on other sites More sharing options...
maicol07 Posted December 9, 2017 Author Share Posted December 9, 2017 Yes Link to comment Share on other sites More sharing options...
Bailey Posted December 9, 2017 Share Posted December 9, 2017 Perhaps the databases and usernames are case sensitive, have you checked them? Link to comment Share on other sites More sharing options...
maicol07 Posted December 9, 2017 Author Share Posted December 9, 2017 Yes. It's all lower-case Link to comment Share on other sites More sharing options...
Bailey Posted December 9, 2017 Share Posted December 9, 2017 Okay, may I please have the snippet of code that connects to your database? Link to comment Share on other sites More sharing options...
maicol07 Posted December 9, 2017 Author Share Posted December 9, 2017 I'm trying to connect from a MySQL Windows Desktop Client... Link to comment Share on other sites More sharing options...
Bailey Posted December 9, 2017 Share Posted December 9, 2017 Okay, have you got the host set to [server].heliohost.org? Link to comment Share on other sites More sharing options...
maicol07 Posted December 9, 2017 Author Share Posted December 9, 2017 Yes Link to comment Share on other sites More sharing options...
Bailey Posted December 9, 2017 Share Posted December 9, 2017 Have you added the user to the database with all permissions? This can be done in cPanel through MySQL databases. Link to comment Share on other sites More sharing options...
maicol07 Posted December 9, 2017 Author Share Posted December 9, 2017 Yes Link to comment Share on other sites More sharing options...
Bailey Posted December 9, 2017 Share Posted December 9, 2017 Then it should work, can you send me a screenshot of the program you are using, on the screen where you enter your details? Link to comment Share on other sites More sharing options...
wolstech Posted December 9, 2017 Share Posted December 9, 2017 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. Link to comment Share on other sites More sharing options...
maicol07 Posted December 9, 2017 Author Share Posted December 9, 2017 (edited) 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 Link to comment Share on other sites More sharing options...
Bailey Posted December 9, 2017 Share Posted December 9, 2017 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? Link to comment Share on other sites More sharing options...
Recommended Posts