connection refused for root user

[webscripter]

Hi everyone,

I have installed mysql and thought I knew what I was doing from the last install. I switched OS from win98 to winXP.

All seems ok. Green light is showing. connect fine from command prompt with just mysql command.

But when I try to connect from a perl script the user and password is denied.

Access denied for user: 'yrkylady@localhost' (Using password: YES)

I know the password is correct because I'm getting it from the Admin panel

#This File was made using the WinMySQLAdmin 1.4 Tool
#3/2/2004 6:21:11 PM

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

[mysqld]
basedir=C:/mysql
#bind-address=127.0.0.1
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=yrkylady
password=sdasldkf

Any ideas on what I should do. How do I create passwords for each database?

Thanks



Thanks
Pat
ideas@microwebber.com

http://microwebber.com

 

[rab54]

Have a look here for docs on user account management etc

http://www.mysql.com/documentation/...MySQL_Database_Administration.html#User_names

hope this helps

Rab