This can be solved if you connect through command line to mysql and give
grant all privileges on *.* to [EMAIL PROTECTED] identified by 'paswdyouwant';
This will give the basic privileges to all databases for the useryouwant from 10.0.0.220 to all the databases you have on your mysql server.
Paul Larue wrote:
Hi all, I got MySQL 3.23.55-nt running on XP and MySQL Client 3.23.36 running on Linux Red Hat 7. I'm trying to have the client connect to the server but I get the same error all the time:
[EMAIL PROTECTED] /root]# mysql -h 10.0.0.41 -u guest ERROR 1130: Host '10.0.0.220' is not allowed to connect to this MySQL server
Could it be that the server and the client are not running the same version and OS? Actually this situation is only a simulation of the future setup which will be a win2k box holding the MySQL Server and the Linux box still holding the client. Apache will run on the linux box as well as PHP so that I can connect to mysql.
I'd be glad to hear from people having a similar setup and who would be willing to give me tips on problems I could encounter as well as some hints.
Thanks in advance
Paul
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-- http://www.freemail.gr - δωρεάν υπηρεσία ηλεκτρονικού ταχυδρομείου.
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
