Unanswered: Fresh MySQL 4.0 installation with problem
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;
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!