PHP MYSQL Connection problem

[Deep]

hi,

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: \'[email protected]\' (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 ?

regards

Deep

 

P.S. PHP version is 4.3.1

[shivabharat]

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)

 

To create database u have to go to the mysql prompt and do it and I dont think its possible to do it from mysqladmin. There is a tool called \"SQLYOG\" which would be really handy because its GUI based.

 

Now comming to the error part

 

I guess its more of a code issue than config issue

 

Now the first thing I would recommend is flush or reset the password u set for the user Deep.

 

If u have mysql manual that would help u in great deal in resetting the password.

 

 

Now u dont have edit anything in the php.ini MYSQL takes up all default value. Try to remove the user \"deep\" u have entered in the php.ini.

 

Have a look @ this setting

[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 =

 

; 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 =

 

; Default user for mysql_connect() (doesn\'t apply in safe mode).

mysql.default_user =

 

; 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 cfg_get_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 =

 

 

All u other config looks fine

 

try to create another user and see if things work!!!

 

Just put on if u still have any issues!!!

[Deep]

oh thanks...i did all that and it worked actually there was something to do with the permissions also so i changed the permissions and now works fine...

 

thanks for the help

Deep