Try to write a small script using the mysql commands from php.net and see if it works to make sure that your php mysql commands is enabled.. just to make sure that its not the installation that's the problem
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have given up. From web searches it is clear that there is a problem between using libmysql.dll and php5.0.2.
I have tried various solutions suggested but at best only succeeded in inactivating mysqli.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Connection Error
Could not connect to the database with the information provided.
message means what it says !! ur database access credentials/accounts u input should be wrong..
Please see my second message
Sorry - hit the enter key in the subject field by mistake...
I'm using a windows 2K platform, Apache 2 and PHP5.
Till now I have been using mysqli to access my tables without any problem.
I have uncommented the extension=php_mysql.dll line in the php.ini file and PHPCodeGenie tries to access mysql but fails with the message -
Connection Error
Could not connect to the database with the information provided.
Does anybody have any suggestions?
Try to write a small script using the mysql commands from php.net and see if it works to make sure that your php mysql commands is enabled.. just to make sure that its not the installation that's the problem
You were right. It is an installation problem.
If I use the libmysql.dll that comes with php5 (dated 09/2004) I get the following message -
Could not connect: Client does not support authentication protocol requested by server; consider upgrading MySQL client
I have tried more recent and older versions of libmysql.dll from mysql.com and I keep getting an error message that mysql_drop_db could not be found.
I have given up. From web searches it is clear that there is a problem between using libmysql.dll and php5.0.2.
I have tried various solutions suggested but at best only succeeded in inactivating mysqli.
you can still use php 5. But you have to use 'old style' passwords. So you have to reset your passwords :
mysql> SET PASSWORD FOR
-> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');