This link has been bookmarked by 2 people . It was first bookmarked on 16 Jun 2008, by harry palmer.
Adding New Users to MySQL
by Jeff Hunter, Sr. Database Administrator
You can add new users to MySQL in two different ways: by using the GRANT statement or my manipulating the MySQL grant tables directly. The preferred method is to use the GRANT statement because they are more concise and less error-prone.
The following examples show how to use the mysql client to set up new users. These examples assume that privileges are set up according to the defaults provided in the previous MySQL DBA Tip, "Setting Up the Initial MySQL Privileges". This means that to make changes, you must be on the same machine where mysqld is running, you must connect as teh MySQL root user, and the root user must have the insert privilege for the mysql database and the reload administrative privilege. Also, if you have changed the root user password, you must specify it for the following mysql commands:
You can add new users by issuing GRANT statements:
% mysql -u root mysql mysql> GRANT ALL PRIVILEGES ON *.* TO oracle@localhost -> IDENTIFIED BY 'manager' WITH GRANT OPTION; mysql> GRANT ALL PRIVILEGES ON *.* TO oracle@"%" -> IDENTIFIED BY 'manager' WITH GRANT OPTION; mysql> GRANT RELOAD, PROCESS ON *.* TO admin@localhost; mysql> GRANT USAGE ON *.* TO dummy@localhost;
The GRANT statements (above) create and set up three new users:
Would you like to comment?
Join Diigo for a free account, or sign in if you are already a member.