mySQL_connect - access denied for new user
Posted: 20. April 2011 10:31
Hi all!
I have a strange problem. A have installed xampp, and i try to use the mysql database with php. I tested the things with root, everything works fine. but i wanted to create an own username and password to use. I created the new user, granted all privileges, set host to any ( % ) , even created a new database to it, and granted all database privileges and all table privileges. finally a flush privileges, so i have a root-like user. the problem is, i cant even connect to the database with this user and password. it says :
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'koocka'@'localhost' (using password: YES) in C:\xampp\htdocs\reg.php on line 6
any ideas ? what should i try?
I have a strange problem. A have installed xampp, and i try to use the mysql database with php. I tested the things with root, everything works fine. but i wanted to create an own username and password to use. I created the new user, granted all privileges, set host to any ( % ) , even created a new database to it, and granted all database privileges and all table privileges. finally a flush privileges, so i have a root-like user. the problem is, i cant even connect to the database with this user and password. it says :
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'koocka'@'localhost' (using password: YES) in C:\xampp\htdocs\reg.php on line 6
any ideas ? what should i try?