tmzafar Posted April 26, 2020 Posted April 26, 2020 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...
wolstech Posted April 26, 2020 Posted April 26, 2020 Did you assign the user to the database in cPanel? You grant the rights as part of assigning the user to the database. You do it at the bottom of the MySQL Databases page.
tmzafar Posted April 26, 2020 Author Posted April 26, 2020 yes i assigned them to do the database and given them rights too
Luigi123 Posted April 26, 2020 Posted April 26, 2020 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.
tmzafar Posted April 26, 2020 Author Posted April 26, 2020 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
Luigi123 Posted April 26, 2020 Posted April 26, 2020 One more to add from Wolstech's post, when you grant the rights as part of assigning the user to the database, did you checkmark "ALL PRIVILEGE"? That could be the reason why.
tmzafar Posted April 26, 2020 Author Posted April 26, 2020 yes i checkmarked that for that specific user. Should i remove that?
Luigi123 Posted April 26, 2020 Posted April 26, 2020 yes i checkmarked that for that specific user. Should i remove that? Nope, don't remove it.
tmzafar Posted April 26, 2020 Author Posted April 26, 2020 So what could else be the reason? Is there something else i can do to?
wolstech Posted April 26, 2020 Posted April 26, 2020 No other ideas here. Lets see if Krydos has any...
Krydos Posted April 27, 2020 Posted April 27, 2020 What is the database user, and the database you're trying to connect to?
tmzafar Posted April 27, 2020 Author Posted April 27, 2020 What is the database user, and the database you're trying to connect to?the user is tmzafar_admin and the database is database_kd-ueberdachung
Krydos Posted April 28, 2020 Posted April 28, 2020 The grants, and the remote access all look correct. Have you tried dumping the database, dropping the database, and loading the data back in?
tmzafar Posted April 29, 2020 Author Posted April 29, 2020 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
Recommended Posts