Portal Home > Knowledgebase > Articles Database > problem with MYSQL
problem with MYSQL
| Posted by assassin85, 12-30-2007, 02:01 PM |
| hi,
i have a problem with MYSQL i upgraded php to 4.4.7
i got problem with all my sites have database running
mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Client does not support authentication protocol requested by server; consider upgrading MySQL client
/home/site/public_html/forum/includes/class_core.php on line 273
THE MYSQL version mysql Ver 14.7 Distrib 4.1.22, for pc-linux-gnu (i686) using readline 4.3
i running php 4.4.7 and apache 1.3.39 with WHM 11.11.0 cPanel 11.16.0-S18450
so i was hope anyone Help Me With that problem
thanks,
|
| Posted by Eyal, 12-30-2007, 02:39 PM |
| You should run mysql in old password mode .
In WHM under 'Tweak Settings' check this one :
|
| Posted by assassin85, 12-30-2007, 02:45 PM |
| well i solved the problem with recompile apache and check the following setting
Mbstring
Mcyrpt
Mysql of the system
and i looked in ur solution and i found
Use old style (4.0) passwords with MySQL® 4.1+ (required if you have problems with PHP apps authenticating)
not check and i checked it and i save the setting now
should i recompile apache again and un check this settings
Mbstring
Mcyrpt
Mysql of the system
waiting for ur reply,
thanks,
|
| Posted by david510, 12-30-2007, 08:47 PM |
| If the database uses the old style password hash you need to check that option. To determine that, follow the steps.
Enter into mysql prompt from ssh. Type the following commands.
If you see the something like this, it uses old style password.
If you see something like below it uses new style
|
Add to Favourites 
Print this Article
Also Read
Shared Hosting
Shared Hosting
