dianagaby2002 Posted September 29, 2015 Share Posted September 29, 2015 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. Quote Link to comment https://forums.phpfreaks.com/topic/298358-new-mysqli-syntax/ Share on other sites More sharing options...
requinix Posted September 29, 2015 Share Posted September 29, 2015 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') Quote Link to comment https://forums.phpfreaks.com/topic/298358-new-mysqli-syntax/#findComment-1521842 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.