I m running my own server on WinXp SP1 with IIS and i have sucessfully installed PHP and MYSQL.
but the problem is with connection between PHP and MYSQL...I m trying to install a discussion forum (Invision Board) on my machine and there it asks for host name,db pass and all...i enetered all...and it shows foll error after submitting the data for next step :
Warning: mysql_connect() [function.mysql-connect]: Access denied for user: \'Deep@127.0.0.1\' (Using password: YES) in C:Inetpubwwwrootforumsm_install.php on line 395
and foll invision error :
The following errors must be rectified before continuing! Please go back and try again! Could not create a mySQL connection, please check the SQL values entered.
other info :
MYSQL Part in php.ini
[MySQL] ; Allow or prevent persistent links. mysql.allow_persistent = On ; Maximum number of persistent links. -1 means no limit. mysql.max_persistent = -1 ; Maximum number of links (persistent + non-persistent). -1 means no limit. mysql.max_links = -1 ; Default port number for mysql_connect(). If unset, mysql_connect() will use ; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the ; compile-time value defined MYSQL_PORT (in that order). Win32 will only look ; at MYSQL_PORT. mysql.default_port = 3306 ; Default socket name for local MySQL connects. If empty, uses the built-in ; MySQL defaults. mysql.default_socket = ; Default host for mysql_connect() (doesn\'t apply in safe mode). mysql.default_host = localhost ; Default user for mysql_connect() (doesn\'t apply in safe mode). mysql.default_user = Deep ; Default password for mysql_connect() (doesn\'t apply in safe mode). ; Note that this is generally a *bad* idea to store passwords in this file. ; *Any* user with PHP access can run \'echo get_cfg_var("mysql.default_password") ; and reveal this password! And of course, any users with read access to this ; file will be able to reveal the password as well. mysql.default_password = ; Maximum time (in secondes) for connect timeout. -1 means no limimt mysql.connect_timeout = -1 ; Trace mode. When trace_mode is active (=On), warnings for table/index scans and ; SQL-Erros will be displayed. mysql.trace_mode = Off
I havent put anything for \"mysql.default_socket =\" (how to find the Deafult socket any idea ?) can it be the reason for that error ???
EDIT : REMOVED THE IMAGES
( in DataBase thing it doesnt show Create Database when u right click (is it only with me or its like that only) so i created using Command Prompt.)
can anyone help me with this ? why i m getting that error ? any idea ?
P.S. PHP version is 4.3.1