SLUG Mailing List Archives
Re: [SLUG] need help with mysql
- To: slug@xxxxxxxxxxx
- Subject: Re: [SLUG] need help with mysql
- From: Damien Gardner Jnr <rendrag@xxxxxxxxxxx>
- Date: Mon Nov 27 16:16:02 2000
- User-agent: Mutt/1.2.5i
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
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)
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..
Damien Gardner Jnr - Dip.EE StudIEAust
rendrag@xxxxxxxxxxx - http://www.rendrag.net/
Ph: 0417 055 052 - Fax: 02 6299 9713
-- I'm trying to imagine you with a personality.