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]
