MySQL Authentication Error
Posted 15 January 2003 - 02:47 AM
The user is a root user with all privileges and both the list and edit screens have the same security restrictions. Using CodeCharge Studio, Apache 2.0.43, PHP 4.2.3, MySQL 3.23.54, with MySQL and Apache running as services on Windows 2000 where applicable. I get the same error when running from a Unix test server running similar versions.
Most appreciative if anyone could give any advice.
Warning: Access denied for user: \'patrick@localhost\' (Using password: YES) in /home/patrick/public_html/test/xyz.php on line x
Warning: MySQL Connection Failed: Access denied for user: \'patrick@localhost\' (Using password: YES) in /home/whitit/public_html/test/xyz.php on line x
Database error: pconnect(localhost, patrick, $Password) failed.
MySQL Error: ()
Posted 15 January 2003 - 02:51 AM
grant all on database_name.* to patrick@localhost identified by \'your_password_here\';
you might also try quoting the arguments in pconnect.
Posted 15 January 2003 - 04:05 AM
Any further thoughts? Any help is appreciated. Once again, thanks for your reply.
Posted 15 January 2003 - 04:41 AM
you can try appending...
or die ( mysql_errno() . \' \' . mysql_error() );
...to your mysql statements to see if it returns any more specifics on the problem.
have you tried using mysql_connect() instead? something could be awry in your php.ini pconnect settings...
Posted 15 January 2003 - 09:10 AM
Posted 15 January 2003 - 06:57 PM
- use mysql;
- select * from db where User=\'patrick\';
Posted 18 January 2003 - 05:30 AM
Posted 18 January 2003 - 06:10 AM
Posted 18 January 2003 - 11:15 AM
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users