MySQL Login - SOLVED
Moderator: General Moderators
-
cgraham149
- Forum Newbie
- Posts: 3
- Joined: Wed May 10, 2006 9:43 pm
MySQL Login - SOLVED
Does anyone know why I CAN login to MySQL from a shell but can NOT from a PHP app using the same user/pass?
Last edited by cgraham149 on Thu May 11, 2006 3:02 pm, edited 1 time in total.
- dibyendrah
- Forum Contributor
- Posts: 491
- Joined: Wed Oct 19, 2005 5:14 am
- Location: Nepal
- Contact:
What is the error ?
Something like access denied root@localhost or someuser@localhost or some other authentication issues ? or script error at line ... ?
If the error is not shown, you may use
or tweak the php.ini
After that restart the apache server to see the effect !
Cheers.
Dibyendra
Something like access denied root@localhost or someuser@localhost or some other authentication issues ? or script error at line ... ?
If the error is not shown, you may use
Code: Select all
or die(mysql_error())Code: Select all
error_reporting = E_ALL & ~E_NOTICE
display_errors = On
error_log = /var/log/php5/php5_err.logCheers.
Dibyendra
-
cgraham149
- Forum Newbie
- Posts: 3
- Joined: Wed May 10, 2006 9:43 pm
SOLVED
SOLVED:
GRANT ALL PRIVILEGES ON dbName.* TO userName@'localhost' identified by '********';
Thanks
GRANT ALL PRIVILEGES ON dbName.* TO userName@'localhost' identified by '********';
Thanks