mysql php connection issue

[mcskins]

I am new to php and mysql. I am running debian etch php5 and mysql5.
I created some test php scripts to talk to mysql. Everything worked initially, but after about the 5th connection the php mysql connects did not work anymore.

Here is the error message I get now:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'www-data'@'localhost' (using password: YES) in /var/www/apache2-default/select.php on line 6
Unable to select database

I rebooted my box and it still does not work.

Thanks for your help!
Bill

[celon_php_master]

that becoz u don't have aceess permisions .create a user or use user as root with blank password

[Xnuiem]

to expound, create a user in the database, in the user table in the mysql database.

You can just use a query, or use a tool like phpmyadmin. Just make sure the password field uses the password function.

MySQL AB :: MySQL 5.0 Reference Manual :: 5.8.2 Adding New User Accounts to MySQL

[celon_php_master]

use this tool mysqlcc-0.9.2-linux-glibc22.tar.gz

i have work with this at office

194.65.100.43/pub/mysql/Downloads/MySQLCC/ - FTP Browser


create a user and start connect to mysql

[celon_php_master]

create a user like this type in the mysql prompt

grant all privileges on *.* to nameofthe_ user@"localhost" identified by 'userpassword'