pavement

MySQL, Adding Users

From FreeBSDwiki
(Difference between revisions)
Jump to: navigation, search
m (External Links)
 
(2 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
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'''):
 
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'''
+
  oyabun# '''mysql -u root mysql -p'''
 
  password:
 
  password:
 
  > GRANT ALL PRIVILEGES ON *.* TO user@localhost IDENTIFIED BY 'pass' WITH GRANT OPTION;
 
  > 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 <nowiki>[[databasename]]</nowiki>.*''' or something similar.
+
Note: 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 <nowiki>[[databasename]]</nowiki>.*''' or something similar.
  
 
==External Links==
 
==External Links==
  
 
http://dev.mysql.com/doc/mysql/en/adding-users.html
 
http://dev.mysql.com/doc/mysql/en/adding-users.html
 +
 
http://sunsite.mff.cuni.cz/MIRRORS/ftp.mysql.com/doc/en/Adding_users.html
 
http://sunsite.mff.cuni.cz/MIRRORS/ftp.mysql.com/doc/en/Adding_users.html
  
 
[[Category:Common Tasks]]
 
[[Category:Common Tasks]]

Latest revision as of 23:30, 15 August 2005

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 -u root mysql -p
password:
> GRANT ALL PRIVILEGES ON *.* TO user@localhost IDENTIFIED BY 'pass' WITH GRANT OPTION;

Note: 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.

[edit] External Links

http://dev.mysql.com/doc/mysql/en/adding-users.html

http://sunsite.mff.cuni.cz/MIRRORS/ftp.mysql.com/doc/en/Adding_users.html

Personal tools