IT is working as of yesterday. The problem was that I was granting select, insert, update privileges to the webuser and the change would not appear in the user table of the mysql database.
Learn a new one yesterday. I try changing the privileges using the GRANT on an existing user and they do not change. I think this might be an error. I try this on several machines and the solution is to performa a query on the privileges on the user table of the mysql database. Nestor :-) On Fri, 20 Sep 2002 09:48:09 -0700 "Clayburn W. Juniel, III" <[EMAIL PROTECTED]> wrote: On Friday, September 20, 2002, at 08:09 AM, Richard Fox wrote: > Hi, > > I am on the machine 192.168.0 230, and I am trying to connect to the > server > on 192.168.0.10. > >> mysql -h 192.168.0.10 -u username -p > > I get back > >> ERROR 2003: Can't connect to MySQL server on '192.168.0.10' (111) > > OK, so I tried to connect to the local server > >> mysql -h 192.168.0.230 -u username -p > > And I get back > >> ERROR 1130: Host '192.168.0.232' is not allowed to connect to this >> MySQL >> "mysql -h 192.168.0.230 -u username -p" is correct. But when you created the grant for this user, you needed to list the host as 192.168.0.230 or I think "%" might have worked. -- Clayburn W. Juniel, III -- Effective Software Solutions Phone: (602) 326-7707 Mobile: (602)326-7707 Email: [EMAIL PROTECTED] http://EffectiveSoftwareSolutions.com -- --------------------------------------------------------------------- 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
