As its first example of creating accounts, the manual says
After connecting to the server as `root', you can add new accounts.
The following statements use `GRANT' to set up four new accounts:
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
I would first mention regular accounts' setup before superusers'.
P.S., I note one can do
$ echo SELECT \*,CWORD,HWORD,CMP FROM dict WHERE CMP=\"T\"\;|mysql
but a second \* cannot be used: SELECT \*,CWORD,\* etc.
P.S., in Appendix H, GNU's street address has changed.
P.S., -t causes a blank to be appended to each line!
$ echo SELECT ... FROM ...|mysql db -t|grep \ $
(except the header and top and bottom border.)
(Caught with emacs' show-trailing-whitespace.)
(mysql -E does too for empty fields, by the way.)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
