..., etc.

This is an old revision of the document!

---

[ben@vince wiki]$ mysql -u root -p 
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5 to server version: 4.1.20
 
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
 
mysql> create database wikidb;
Query OK, 1 row affected (0.00 sec)
 
mysql> GRANT ALL PRIVILEGES ON wikidb TO 'wikiuser'@'localhost' IDENTIFIED BY '-----' WITH GRANT OPTION;
ERROR 1046 (3D000): No database selected
mysql> GRANT ALL PRIVILEGES ON wikidb.* TO 'wikiuser'@'localhost' IDENTIFIED BY '-----' WITH GRANT OPTION;
Query OK, 0 rows affected (0.02 sec)