Re: Cannot select the database

2006-03-21 Thread mysql
cks who is authorised to connect to the server. http://dev.mysql.com/doc/refman/4.1/en/connection-access.html * HTH Keith In theory, theory and practice are the same; in practice they are not. On Tue, 21 Mar 2006, Charles Gambrell wrote: > To: "[EMAIL PROTECTED]" <[EMAIL PRO

Re: Cannot select the database

2006-03-21 Thread mysql
Take a look at these links Charles. http://dev.mysql.com/doc/refman/4.1/en/privilege-system.html http://dev.mysql.com/doc/refman/4.1/en/user-account-management.html You don't need to fully understand the mysql privilege access system to set up users, but it would help in the long term. Regard

Re: Cannot select the database

2006-03-21 Thread Nestor
Charles, 2 thing I woul do: 1) Grant permissions to the user that is trying to access mysql on that db. 2) I was having problems accessing mysql using php, although I was able to access mysql from the command line. The fix was using the old_password() function on mysql.