1045 - Access denied for user "root@192.168.1.9" using password: YES
-
Hi, I am getting a different error: 1045 - Access denied for user "root@192.168.1.9" using password: YES I am sure about the password because I am able to login to it on the server itself which has the IP 192.168.1.1 but I am unable to login from my PC which has the IP 192.168.1.9 Kindly help..
-
Hi, I am getting a different error: 1045 - Access denied for user "root@192.168.1.9" using password: YES I am sure about the password because I am able to login to it on the server itself which has the IP 192.168.1.1 but I am unable to login from my PC which has the IP 192.168.1.9 Kindly help..
You need to allow access to the server from all locations. It looks like you have set access to the server from localhost only.
When I was a coder, we worked on algorithms. Today, we memorize APIs for countless libraries — those libraries have the algorithms - Eric Allman
-
Hi, I am getting a different error: 1045 - Access denied for user "root@192.168.1.9" using password: YES I am sure about the password because I am able to login to it on the server itself which has the IP 192.168.1.1 but I am unable to login from my PC which has the IP 192.168.1.9 Kindly help..
You need to add additional access rights by executing the following command in Mysql console line:
GRANT ALL on .* TO 'root'@'192.168.1.%'
This will allow all computers in the 192.168.1.x subnet to login to your MySQL server.
-
You need to add additional access rights by executing the following command in Mysql console line:
GRANT ALL on .* TO 'root'@'192.168.1.%'
This will allow all computers in the 192.168.1.x subnet to login to your MySQL server.
can I replace the
<dbname>
with EVERYTHING so full access will be granted to all databases for everyone in that IP range?
-
can I replace the
<dbname>
with EVERYTHING so full access will be granted to all databases for everyone in that IP range?
Sure just replace it with a '*' and you will grant access to all the schema's in the database.
-
Sure just replace it with a '*' and you will grant access to all the schema's in the database.
I did but still getting the same when using Navicat as well Visual Studio? How can I troubleshoot?
Access denied for user 'root'@'192.168.1.9' (using password: YES)
-
I did but still getting the same when using Navicat as well Visual Studio? How can I troubleshoot?
Access denied for user 'root'@'192.168.1.9' (using password: YES)
any idea what can I do to fix this? FYI: MySQL is running on debian..
-
I did but still getting the same when using Navicat as well Visual Studio? How can I troubleshoot?
Access denied for user 'root'@'192.168.1.9' (using password: YES)
Is this a VPS or dedicated server, if so have you verified that MySQL is even listening to external IP addresses. Most hosting providers will limit access to MySQL from outside the server itself. If you have a VPS or dedicated server look in the '/etc/mysql/my.cnf' And make sure the rule below is not applied or change it to your network IP address for that server.
bind-address = 127.0.0.1
-
Is this a VPS or dedicated server, if so have you verified that MySQL is even listening to external IP addresses. Most hosting providers will limit access to MySQL from outside the server itself. If you have a VPS or dedicated server look in the '/etc/mysql/my.cnf' And make sure the rule below is not applied or change it to your network IP address for that server.
bind-address = 127.0.0.1
Problem solved by just changing the password of the root to another password although the old password was correct but I don't know why I was getting that error.. anyhow, thanks everyone..