pavement

MySQL, Adding Users

From FreeBSDwiki
Revision as of 23:09, 15 August 2005 by Jimbo (Talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

To add new users to mysql use the following commands (if you haven't set a password for the mysql root user, leave off the -p):

oyabun# mysql --user=root mysql -p
password:
> GRANT ALL PRIVILEGES ON *.* TO user@localhost IDENTIFIED BY 'pass' WITH GRANT OPTION;

Nore: that command grants full privileges on ALL databases to "user@localhost", effectively creating a new mysql root user, which is usually not what you want. More frequently, you will want to GRANT ALL PRIVILEGES ON databasename.* or something similar.

External Links

link Mysql-adding-users link Mysql-adding-users2

Personal tools