My problem is fixed. I only grant'ed user@localhost. What I needed, and have done, is grant'ed [EMAIL PROTECTED] Once I did that everything worked.
Zyxian On Tue, 16 Apr 2002 09:38:19 -0700, Zyxian wrote: Hello. When trying to connect to a database through php using a user that has been granted all rights to the database I get the "Can't connect to database" error. If I use the Admin's name and password I have no trouble connecting through the php page. From a shell prompt I can connect to mysql using that user and make any changes to the database. I am running MySQL 4.0.1-alpha and PHP Version 4.2.0rc1. Any help will be much appreciated as I have been at trying to figure this out for several days now. Zyxian --------------------------------------------------------------------- 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
