Re: [SLUG] need help with mysql

[Damien Gardner Jnr <rendrag@xxxxxxxxxxx>]

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
rendrag@xxxxxxxxxxx  -  http://www.rendrag.net/
Ph: 0417 055 052     -  Fax: 02 6299 9713
-- I'm trying to imagine you with a personality.