MySQL database user

[Anon]

Hi all,

I use MySQL v3.23. But it never wants any user name or password from me when I start mysqlmanager.

Now the question is that if I want to create more user (like Oracle) is it possible or realy needed? Because if there is only one user, then any body who use MySQL can make harm (May be accidentaly) in other database.

What shall I do?

Ahsan Mani

[[deleted]]

MySQL can be configured to have users who don't need to enter a password.

If you want to protect your data you should create a password for the root account, and create a new user for every set of accessrights you need, just like in oracle.

Rule nr1 in securing your server: Every account has a password
Rule nr2 Every user has his own account
Rule nr3 No accounts have rights to access data they don't need to access.