i am getting error like mysql_connect() acces denied for system@localhost(using password NO)

Answer 1

'Access denied' means you are connecting to the DB server properly, but the user/host combination you're connecting as (and from) does not have permission to access the server and/or specified database. You can check the permissions from within the mysql monitor with show grants for user@hostname (e.g. whatever your DB_USER and DB_PASS defines are).

Remember that MySQL's user system is completely seperate from the operating system's user system, so having a login account on the server does not automatically grant you an account in MySQL.

Full docs on the permissions granting system are here on dev.mysql.com.

edit:

You should NEVER connect to the server as root. Create a new database user with just enough privileges you need on whatever database(s) are required. Connecting as root is just asking for trouble, including possibly opening your server up to remote compromises.

Unless your web app requires modifying tables on-the-fly, something like this should be enough permissions for most everything to work just fine:

GRANT insert,select,update,delete on somedatabase.* TO username@localhost IDENTIFIED BY 'somepassword';

And then use DB_USER = 'username' and DB_PASS = 'somepassword' in your connection

That all being said, have you verified that DB_USER, DB_PASS, and DB_SERVER are properly set inside your class? Also note that for MySQL's purposes, combinations of user@host are considered distinct accounts. 'root@localhost' and '[email protected]' may really be the same thing, but MySQL considers them utterly seperate and distinct.

Answer 2

Have you populated the DB_SERVER, _NAME, _USER, _PASS?

Answer 3

I had the same issue in different forms. But two things to make sure - make sure you didn't close the connection before the query and make sure the link didn't go away. With the original mysql extension this sometimes happens. Testing for this can be done by "get_resource_type" - if the connection isn't of type mysql link, you need to reconnect.

Answer 4

Try using 127.0.0.1 instead of localhost. On certain MySQL drivers(particularly on OS X, IIRC), localhost actually refers to a socket connection instead of the local system.