Help connecting MySql Workbench
Hi I am having trouble connecting to my server.
When I try to connect to the server I get the following error.
--------------------------
MySQL Workbench Error
--------------------------
Cannot Connect to Database Server
Your connection attempt failed for user 'root' from your host to server at IP ADDRESS:3306:
Access denied for user 'root'@'<number>.range86-1
Please:
1 Check that mysql is running on server <IP ADDRESS>
2 Check that mysql is running on port 3306 (note: 3306 is the default, but this can be changed)
3 Check the root has rights to connect to <IP ADDRESS> from your address (mysql rights define what clients can connect to the server and from which machines)
4 Make sure you are both providing a password if needed and using the correct password for <IP ADDRESS> connecting from the host address you're connecting from
--------------------------
OK
--------------------------
Now the windows firewall service is not running on the server, so it can't be that. The IP user, pass are all correct to.
Any Ideas?
Matt.
When I try to connect to the server I get the following error.
--------------------------
MySQL Workbench Error
--------------------------
Cannot Connect to Database Server
Your connection attempt failed for user 'root' from your host to server at IP ADDRESS:3306:
Access denied for user 'root'@'<number>.range86-1
Please:
1 Check that mysql is running on server <IP ADDRESS>
2 Check that mysql is running on port 3306 (note: 3306 is the default, but this can be changed)
3 Check the root has rights to connect to <IP ADDRESS> from your address (mysql rights define what clients can connect to the server and from which machines)
4 Make sure you are both providing a password if needed and using the correct password for <IP ADDRESS> connecting from the host address you're connecting from
--------------------------
OK
--------------------------
Now the windows firewall service is not running on the server, so it can't be that. The IP user, pass are all correct to.
Any Ideas?
Matt.
You need to access your server that running mysql and run mysql grant from that to allow your ip to access mysql server.
GRANT ALL ON *.* TO 'root'@'<IP ADDRESS>';
Read more about this here http://dev.mysql.com/doc/refman/5.1/en/grant.html
GRANT ALL ON *.* TO 'root'@'<IP ADDRESS>';
Read more about this here http://dev.mysql.com/doc/refman/5.1/en/grant.html
ASKER
hi guys,
dsmile, we are not on a static IP address though? I am able to grant access universally?
is this safe?
thanks for the advice guys.
dsmile, we are not on a static IP address though? I am able to grant access universally?
is this safe?
thanks for the advice guys.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
1. network problem, try pinging the ip address seperately
2. confirm that the mysql server is running
3. further there point 3 of the solutions provided might be a cause; often it happens we try to connect from a new machine whose ip address is not in the clients list on the server ...