Error message with DW database

Report · Jul 21, 2006

I am having a problem connecting to a database from Dreamweaver 8. I have been successful using another program like phpmyadmin and able to see the data base. I have created a recordset and can see the tables in the database. I did the test in the recordset box and it works. When I add a database item from the reecordset and try to view it in the browser in get the following.

Warning: Access denied for user: 'Robert@127.0.0.1' (Using password: YES) in c:\phpdev5\www\recordstorephpstart\Connections\cnrecordstorephp.php on line 9

Fatal error: Access denied for user: 'Robert@127.0.0.1' (Using password: YES) in c:\phpdev5\www\recordstorephpstart\Connections\cnrecordstorephp.php on line 9

I don’t know what to do at this point. Can anyone point me in the right direction.

Report · Jul 22, 2006

robert4442 wrote:
> Warning: Access denied for user: 'Robert@127.0.0.1' (Using password: YES) in
> c:\phpdev5\www\recordstorephpstart\Connections\cnrecordstorephp.php on line 9

First question: did you use the correct password?

Second question: which versions of PHP and MySQL are you using?

The MySQL extension in PHP doesn't support login with MySQL 4.1.1 or
higher. You either need to enable MySQLI as well, or use the
OLD_PASSWORD protocol:

http://dev.mysql.com/doc/refman/5.0/en/old-client.html

--
David Powers
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "Foundation PHP 5 for Flash" (friends of ED)
http://foundationphp.com/