Simpple MySQL Prob

[Anon]

I feel like an idiot asking this, but here goes--

I have IIS 5 win2k (backup testing machine) and am putting mysql on it. it's installed and all, but I don't know how to add user accounts then block out everything else. The way it is now you don't even need a password to get into mysql.

[Anon]

Hi!

running the pathmysql\bin\mysql.exe -u root
login as root (password is null)!
and use theses command:

use mysql
\g ( \g command running the sql command)

(this command access all ip address to all database)

insert into host values ("%.%.%.%","%","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y")
\g

(create a user)

insert into user values ("%","realusername",password("realpassword"),"Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y")
\g
exit the mysql client!
reload the database server!
and USE!
mysql.exe -u root -p
(-p option is password)
Read the MySQL user manual (6.13 section)!