Jump to content

new mysqli syntax


dianagaby2002

Recommended Posts

I used the new mysqli syntax because with the mysql version I had errors on local BD and other BD.

However, when I useĀ mysqli, I have NO errors in local BD, but got errors in the other BD:

Warning: mysqli_connect(): The server requested authentication method unknown to the client [mysql_old_password], Warning: mysqli_query() expects parameter 1 to be mysqli, boolean given, Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given.

Yup, I have these errors when connected to the OTHER BD, though I use mysqli.

If it has some importance, the local BD has no password(and user is ROOT), the other BD HAS password.

Link to post
Share on other sites

Upgrade the password for the user. Do a

SELECT PASSWORD('123456')
and make sure you get a long string starting with an asterisk. Assuming you do,

SET PASSWORD FOR 'user'@'host' = PASSWORD('password')
Link to post
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.