1.undefined function mysql_connect()

*Find the extension=php_mysql.dll line in php.ini, uncomment it, and restart
the web server eg. > iisreset.

* Save my.ini with [user/pass] in [PHP] , restart web server

2. Undefined variable: HTTP_SERVER_VARS (its own file name _SERVER)
* in [PHP]php.ini
error_reporting = ~E_ALL & ~E_NOTICE
register_globals = ON

3.mysql_connect(): Client does not support authentication protocol requested by server
* Check host_name="127.0.0.1" or " localhost" or "Server_name"

* mysql> SET PASSWORD FOR
-> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');

/** OLD_PASSWORD enable you to maintain backward compatibility with < 4.1v clients. It does prevent creation of a long password hash in the user table ***/

Alternatively, use UPDATE and FLUSH PRIVILEGES:
mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd')
-> WHERE Host = 'some_host' AND User = 'some_user';
mysql> FLUSH PRIVILEGES;

4. Access denied for user 'ODBC'@'localhost' (using password: NO)

*mysql> grant all privileges on *.* to ODBC@'%' with grant option;
Query OK, 0 rows affected (0.06 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.05 sec)

5.GD Installation (php.ini)
extension dir="c:php/ext/"
uncomment ext php_gd2.dll or php_db.dll
move php_gd2.dll to [Windows/system32]

5.Shutdown mysql
mysql>mysqladmin -u root shutdown
mysql>mysqlasdmin -u root start-slave //restart

 

@copyright of Soon Lim. All right reserved