Hi Generally root is only allowed access from local host for security.
Either use a GRANT statement to give access from the host you are using or create another user with the appropriate permissions. Not sure about the IP missmatch. HTH Peter ----------------------------------------------- Excellence in internet and open source software ----------------------------------------------- Sunmaia www.sunmaia.net tel. 0121-242-1473 ----------------------------------------------- -----Original Message----- From: John Hanley [mailto:[EMAIL PROTECTED]] Sent: 08 September 2002 20:13 To: [EMAIL PROTECTED] Subject: MySQL Manager Connection Config Problem Hello. I'm running MySQL 3.23.29a-gamma on RH Linux 7.0. I would like to administer my database from a Win98se client on the same network and installed EMS's MySQL Manager 1.8. This appears to be an excellent tool and can't wait to get started. Unfortunately I'm having a problem getting the connection configuration setup correctly. Note that accessing the database from the Linux side works perfectly. The local NIC on my Linux server is assigned 192.168.0.1 and my Win98 workstation is 192.168.0.12. In the Configuration Info dialog, I enter "192.168.0.1" for Host, Port "3306", User Name "Root", Password "[mypass]" and Database "mysql". I know that MySQL Manager sees my MySQL server because it reports that "Host '192.168.0.12' is not allowed to connect to this MySQL server." The weird thing about this message is that I'm trying to connect to 192.168.0.1 and not 192.168.0.12. It seems this is a permissions issue. Any suggestions would be appreciated. --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
