Results 1 to 4 of 4
Thread: problem with MYSQL
-
12-30-2007, 02:01 PM #1Junior Guru Wannabe
- Join Date
- May 2007
- Posts
- 87
problem with MYSQL
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,
-
12-30-2007, 02:39 PM #2Newbie
- Join Date
- Jul 2002
- Posts
- 25
You should run mysql in old password mode .
In WHM under 'Tweak Settings' check this one :
Use old style (4.0) passwords with MySQL® 4.1+ (required if you have problems with PHP apps authenticating)Http.co.il - Web Hosting Solutions
-
12-30-2007, 02:45 PM #3Junior Guru Wannabe
- Join Date
- May 2007
- Posts
- 87
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,
-
12-30-2007, 08:47 PM #4Web Hosting Master
- Join Date
- Oct 2004
- Location
- Kerala, India
- Posts
- 4,771
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.
Code:use mysql select Password from user where User='database_username';
Code:+------------------+ | Password | +------------------+ | 158d196829124dc3 |
Code:+-------------------------------------------+ | Password | +-------------------------------------------+ | *3580E9208A941CDE651A4ECEE1EC5B49BDF08832 | +-------------------------------------------+
David | www.cliffsupport.com
Affordable Server Management Solutions sales AT cliffsupport DOT com
CliffWebManager | Access WHM from iPhone and Android