MySQL, Adding Users - Revision history

165.228.0.35 at 03:30, 16 August 2005

2005-08-16T03:30:55Z

165.228.0.35 at 03:28, 16 August 2005

2005-08-16T03:28:48Z

Jimbo: /* External Links */

2005-08-16T03:13:46Z

External Links

Jimbo: /* External Links */

2005-08-16T03:13:30Z

External Links

Jimbo at 03:10, 16 August 2005

2005-08-16T03:10:00Z

Jimbo at 03:09, 16 August 2005

2005-08-16T03:09:35Z

New page

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==

[http://dev.mysql.com/doc/mysql/en/adding-users.html link Mysql-adding-users]
[http://sunsite.mff.cuni.cz/MIRRORS/ftp.mysql.com/doc/en/Adding_users.html link Mysql-adding-users2]

[[Category:Common Tasks]]

@@ Line 5: / Line 5: @@
   > 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==

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

@@ Line 10: / Line 10: @@
 http://dev.mysql.com/doc/mysql/en/adding-users.html
 http://sunsite.mff.cuni.cz/MIRRORS/ftp.mysql.com/doc/en/Adding_users.html
 [[Category:Common Tasks]]