Making a mysql 'user'

[mOdEtWo]

Instead of having to put the root user/password inside the applications using the MySQL database (like phpMyAdmin, mtblog etc) (which I consider to be a little unsecure), I would want to make an own MySQL user.

Is this possible? How do I do this, what rights does it need, and what group? An own MySQL group?

[Dolda2000]

If you mean a user inside the MySQL system, it doesn't need a UNIX user at all. MySQL users are in no way related to UNIX users. This is much more thoroughly documented in the MySQL documentation (see http://www.mysql.com/, look up the documentation and see section 4 of it) than I can ever hope of writing here.

[mOdEtWo]

Beats me.

I just need a user I can add to the applications that allow it to access the MySQL bases.

[Dolda2000]

How much access to what databases from which computers?

[mOdEtWo]

How much access to what databases from which computers?

Ok...

I'm running a linux box which I have installed MySQL. I'm running several applications that use the MySQL database, like phpBB and MovableType. In these applications I had to type in a username/password which has access to the MySQL database, in my case 'root'. I feel that this is a little unsecure, since there's a file with the uncrypted root password in a web directory. No one can download it, but you never know.

How do I make a user that has access to the MySQL database, so I don't have to use the root user?

[Dolda2000]

Run this MySQL command:

GRANT ALL ON * TO username IDENTIFIED BY 'password' WITH GRANT OPTION;

[caffeine]

Run this MySQL command:

GRANT ALL ON * TO username IDENTIFIED BY 'password' WITH GRANT OPTION;

Or to restrict access to a specific database

GRANT ALL ON dbname.* TO username IDENTIFIED BY 'password';

[andutt]

Check out my mysql-howto on how to do this... on my site...

regards