Changing user from root
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?
As root run these:
The 'test'@'%' means they can connect from any host.
CREATE USER 'test'@'%' IDENTIFIED BY 'PASSWORD';
GRANT SELECT,INSERT,UPDATE,DELETE ON * . * TO 'test'@'%' IDENTIFIED BY 'PASSWORD'
MAX_USER_CONNECTIONS 0 ;
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.
Last edited by eval(BadCode); 03-01-2011 at 07:05 PM.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)