run mysqld under root

[eduac]

Does anyone here know how i can run the mysqld under root account.

[Sxooter]

Services that don't need to run as root (i.e. using ports above 1023) should NEVER be run as root.

If someone hacks a database running as the mysql user, they have your database. You still own the box. If they hack a database running as root, they own your whole box, and can cover their tracks and you'll never notice.

[eduac]

i see...but i cant load the mysql into the user mode.

[Sxooter]

You probably need to change the permissions on it's data directory so the user account you're trying to start it under has access to it.

[eduac]

you can show me the steps for it? im virgin into the linux world...😃

[Sxooter]

Sure. First, become root:

su -
(enter password when prompted...)
chown mysqluser /dir/wheremysqldatais
chmod 700 /dir/wheremysqldatais

or somthing like that.

[eduac]

i type mysqld to start the mysql server into the user mode and appers (bash command). 🙁

[Sxooter]

Uhhh, I'm not quite sure what you're saying there. could you try again? I get the feeling english isn't your first language, so don't worry about trying a couple times to get it right.

Hope to hear from your soon.