Forums

PHP

This topic is locked

PHP_MYSQL 5 & DW8 problem

Posted 29 Jan 2006 12:03:08
1
has voted
29 Jan 2006 12:03:08 Stefano Provenzano posted:
Hi all,

My machine have installed:
-Dreamweaver Mx 8
-PHP 5.1.2
-MySql 5.1
-Apache 2.0.54 (Win32)

I try to use MYSQL connection from Dreamweaver but it don't work: "Mysql Error#: 1045 access denied for user root@localhost (using password:YES)"

I set correctly the parameters in the dreamweaver dialog, but it don't work!

This problem for me is very important ... any idea???

Thank's in advance.

Stefano


PS:Sorry for my poor english

Replies

Replied 30 Jan 2006 15:15:15
30 Jan 2006 15:15:15 Roddy Dairion replied:
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Hi all,

My machine have installed:
-Dreamweaver Mx 8
-PHP 5.1.2
-MySql 5.1
-Apache 2.0.54 (Win32)

I try to use MYSQL connection from Dreamweaver but it don't work: "Mysql Error#: 1045 access denied for user root@localhost (using password:YES)"

I set correctly the parameters in the dreamweaver dialog, but it don't work!

This problem for me is very important ... any idea???

Thank's in advance.

Stefano


PS:Sorry for my poor english

<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
U'r using root to access your database add a new user and it should work. Dont forget to st all the privileges to 'Y'
Replied 30 Jan 2006 16:29:25
30 Jan 2006 16:29:25 Stefano Provenzano replied:
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
U'r using root to access your database add a new user and it should work. Dont forget to st all the privileges to 'Y'
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Now work... Thank you very much!!!!! <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

I am newbie of mysql... why the db access don't work with the root account?

Bye

Stefano
Replied 30 Jan 2006 16:47:33
30 Jan 2006 16:47:33 Roddy Dairion replied:
becoz root doesn't have a password thus leaving your db free to access. So by default your mysqld system stops any users to access it from outside except from the localhost itself.

Reply to this topic