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?
CREATE USER 'test'@'%' IDENTIFIED BY 'PASSWORD';
GRANT SELECT,INSERT,UPDATE,DELETE ON * . * TO 'test'@'%' IDENTIFIED BY 'PASSWORD'
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.