MySQL Login Question

[ActivI]

Hello everyone,

I've installed MySQL 4.0.18, on my Windows XP Pro box, and I was amazed with the ability to login (as root) without user name and password...

My ini file (my.ini) has the following content:

#This File was made using the WinMySQLAdmin 1.4 Tool
#10-05-2004 17:27:03

#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.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=root
password=xxxxxx

Is there anyway, for me to prevent users from loging in without defining a username / password in their connection string?

Regards and thanks in advance
DBA

[Toly]

You will need to setup a password for the root user. Follow these steps.

[ActivI]

Exactly what I needed, thanks alot