I am running Mysql control center on a Windows XP box and trying to connect to mysql database on a Sun Solaris Box. This is the error that I am getting:
[mysql] ERROR 1130: Host '192.168.1.3' is not allowed to connect to this MySQL server
Both the workstation with the Control Center and the Solaris server box are on the same network. 192.168.1.3 is the Control Center box and I am connecting to the mysql server on 192.168.1.6.
Any guidance on correcting this would be much appreciated.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
if you want to allow a user called 'myuser' to connect from any host with the password 'mypassword' :
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
if you want to allow a user called 'myuser' to connect from your station with the password 'mypassword' :
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.1.3' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
# mysql -u root -p -h localhost
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5 to server version: 4.1.10a
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' identified by 'master' with grant option;
Query OK, 0 rows affected (0.00 sec)
mysql>
Business Accounts
Answer for Membership
by: madwaxPosted on 2004-05-19 at 01:25:44ID: 11106092
The problem is that your user is not allowed to connect from that host. By default all users are only allowed to connect from localhost, i.e. the same computer. A soultion could be to log in through localhost and change the user to be allowed to login from all domains (i.e. change the host-field in user-table in the mysql-database from localhost to %).
//madwax