hi all I have installed mysql and I created an users call lrmt and password is lrmt. So from command line(mysql -u lrmt -p lrmt) i can enter to mysql with out any problem and also with mysql -u root -p socket.
I used this command to give permission to user GRANT ALL ON database.* TO [EMAIL PROTECTED] IDENTIFIED BY 'mysqlpassword' GRANT ALL ON database.* TO mysqlusername\@'%' IDENTIFIED BY 'mysqlpassword' But through script I cannot access the database it shows an error message "DBI connect ('lab:iidcm063.iidc.lucent.com','lrmt',...) failed: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) at test.cgi line 20". This script is running from apache. The apache log file displays the same message when I run the script through Internet browser. And also I got this error message when I run this script from command line.. Please help me to solve the problem. to access database through script what permission I have to set in mysql databases and table (user, db, host, table) .. if possible just send me the query that I can execute on mysql database to solve this problem. Regards joby james -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]