Changing user from root

[ehime]

I am currently running everything from our WWW2 server as the root
user, but understand that this is a security issue. I would like to change
my user who runs everything to a new admin/user account but am not
sure how to set it up. I am running MySql on Ubuntu, any suggestions?

[eval(BadCode)]

As root run these:

CREATE USER 'test'@'%' IDENTIFIED BY 'PASSWORD';

GRANT SELECT,INSERT,UPDATE,DELETE ON * . * TO 'test'@'%' IDENTIFIED BY 'PASSWORD' 
WITH 
MAX_QUERIES_PER_HOUR 0 
MAX_CONNECTIONS_PER_HOUR 0 
MAX_UPDATES_PER_HOUR 0 
MAX_USER_CONNECTIONS 0 ;

The 'test'@'%' means they can connect from any host.
It could also be 'localhost', '192.168.%.%', etc.

The * . * means you are granting these privileges for every database and every table, and again you have a 'test'@'%'. The 0s mean unlimited.

You will have to read the CREATE USER manual for all of the details.
http://dev.mysql.com/doc/refman/5.1/en/create-user.html
http://dev.mysql.com/doc/refman/5.1/en/grant.html

[ehime]

Thanks home slice