On Tue, Nov 28, 2000 at 01:41:49AM -1000, Kevin Saenz said:
--> Help I have forgotten how to add users to mysql.
$ mysql -uroot -p mysql
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 521 to server version: 3.22.32-log
Type 'help' for help.
mysql> INSERT INTO user (host, user, password) values ('localhost', 'username',
password('password'));
Query OK, 1 row affected (0.30 sec)
mysql> QUIT
---
You'll probably want to specify some privs in there too (desc user), but I prefer to
leave them at the default (all 'N'), and specify privs on a per-user,per-database
basis.. - but for a private server you can probably just set them globally for the
user..
Regards,
Damien Gardner Jnr - Dip.EE StudIEAust
[EMAIL PROTECTED] - http://www.rendrag.net/
Ph: 0417 055 052 - Fax: 02 6299 9713
-- I'm trying to imagine you with a personality.
--
SLUG - Sydney Linux User Group Mailing List - http://slug.org.au/
More Info: http://slug.org.au/lists/listinfo/slug
