Re: [PHP-DB] Newbie Question - mysql_select_db fails with access denied.

2004-09-24 Thread Christian Schlaefcke
When I switch back to user root with empty password and use mysql_connect("localhost", "root") it works. I just found out when I set the permission for "myuser" to "localhost" instead of "any" it works also for "myuser". Now I have to check out why I canÂt use passwords. Maybe the PHP Version IÂm

Re: [PHP-DB] Newbie Question - mysql_select_db fails with access denied.

2004-09-24 Thread Pablo M. Rivas
You're right: if you use mysql_connect("localhost", "root",""); you''ll get "acces denied for user [EMAIL PROTECTED] if you use mysql_connect("localhost"); you'll get "Access denied for user @localhost" I'll google for a while... but.. to solve YOUR problem, just use: mysql_connect("localhost","us

RE: [PHP-DB] Newbie Question - mysql_select_db fails with access denied.

2004-09-24 Thread Christian Schlaefcke
I have chosen an empty password. I know that this is a security problem. IÂm using it for testing at the moment only. I use it because there also seems to be an issue with php connecting to mysql servers with verions > 4.1. When trying to connect with password I get this: Connect failed : Client

RE: [PHP-DB] Newbie Question - mysql_select_db fails with access denied.

2004-09-24 Thread Peter Lovatt
Hi try $db = mysql_connect("localhost", "myuser","mypassword") - without it you are not submitting a password Peter > -Original Message- > From: Christian Schlaefcke [mailto:[EMAIL PROTECTED] > Sent: 24 September 2004 13:31 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Newbie Question

Re: [PHP-DB] Newbie Question - mysql_select_db fails with access denied.

2004-09-24 Thread John
This might be a stupid idea, but did you remember to issue the Flush Privelages; command to the mysql database after granting your user all the rights? --John Christian Schlaefcke <[EMAIL PROTECTED]> wrote: Hi Folks, I want to do something like the following: $db = mysql_connect("localhost",