Jump to content

[Solved] Access denied for user when connectiong remotely to MySQL database


tmzafar

Recommended Posts

Hi, i have the following Problem: I followed the instructions from https://wiki.helionet.org/MySQL_Databases#Connecting_Remotely and have added an IP Address (Host) in the remote MySQL Section and can connect with the database just fine.

 

But when i try to create a table, i get the follwoing error:

 

Error Code: 1044. Access denied for user 'user'@'*IP-Address*' to database 'database'
 
I have also tried to grant priviliges to the user, but same error and i have also tried it over phpMyAdmin Section, and there i get another error that user@localhost doesn't have access to the database. I haven't tried it with a wildcard...

 

Link to comment
Share on other sites

Could you try to add this % into the MySQL Remote and see if that works instead of the IP address?

 

Just removed the IP address that you added and replace with the % so it can allowed remote to all of the IP address to give access.

Link to comment
Share on other sites

I removed the IP Address and inserted a '%', but i'm still unable to make any queries, except for a select statement. I am able to log in and make select statements, for everything else i'm gettin command or acces denied

Link to comment
Share on other sites

The grants, and the remote access all look correct. Have you tried dumping the database, dropping the database, and loading the data back in?

i have exported the tables which i created locally in an sql script and imported them through phpMyadmin, but i am unable to make a create table or insert into queries. It works on phpMyAdmin

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
×
×
  • Create New...