Hello everybody

I`ve just installed MySQL 4.0 under Windows XP SP2 as a service (mysqld-max --install). I have this question. How many users are created by default? I mean, that I could connect to the database with any user. Statements like this connect successfully:

mysql -u test1 : connects
mysql -u test2 : connects

However, I would like to have only two users, root and user1.

These users should have full privileges on a database e.t.c. database1

I tried executing these statements :

CREATE DATABASE bio_tech;
USE bio_tech;
GRANT ALL PRIVILEGES ON *.* TO 'root' IDENTIFIED BY 'somepass';
GRANT ALL PRIVILEGES ON *.* TO 'divined' IDENTIFIED BY 'anotherpass';

yet I can still connect to MySQL using any user. Furthermore, I can still connect using user root & divined with no password!

What`s the catch here?

George Papadopoulos

I finally managed to change the root password using the statement :

SET PASSWORD FOR 'root' = PASSWORD('password');

I failed abysmally to change user`s divined password in the same manner though? Does changing a user`s password differ from changing root`s?