mysql installation

[keyboard]

I have a big problem with the Mysql server running as a service.
I work with IIS (perhaps this is not the right forum??), php, Mysql and installed mysql-4.0.16-win.
IIS works fine. The rootdirectory is d:\wwwroot (localhost)
With an anonymous login and using Mysql Control Center a made a database with 2 tables with are stored in the directory c:\mysql\data.
I tried to make a connection in Dreamweaver 2004 but DW generated an internal server error.
I cannot login the mysql server although I installed a user (see the my.ini).

When I log in at the command prompt (c:\mysql\bin\mysql.exe -uroot -pazerty) I get the message: Error 1045 Access denied for User <Using password: YES>
When I log in anonymous I get the Welcome message.

This is the my.ini:
#This File was made using the WinMySQLAdmin 1.4 Tool
#19/12/2004 19:33:41

#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions

[mysqld]
basedir=C:/mysql
#bind-address=192.168.0.143
datadir=C:/mysql/data
#language=C:/mysql/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
[WinMySQLadmin]
Server=C:/mysql/bin/mysqld-nt.exe
user=root
password=azerty

Can anyone help me? <_<

[gvwiberg]

Hi there!

I guess you have solved this by now, but here is my answer anyway:

The syntax is:
mysql -u user_name -ppassword

and not as you type

mysql -uuser_name -ppassword


Your line:
c:\mysql\bin\mysql.exe -uroot -pazerty

should therefor be:
c:\mysql\bin\mysql.exe -u root -pazerty


Here is another link that might help:
http://dev.mysql.com/doc/mysql/en/password...d-too-long.html

/G
@varupiraten.se