# mysql -u root -prootroot
Welcome to the MySQL monitor.
Commands end with ; or \g.
Your MySQL connection id is 10
to server version: 4.0.23-standard
Type help; or \h for help. Type
\c to clear the buffer.
mysql> create database cactidb;
Query OK, 1 row affected (0.00 sec)
mysql> grant all on cactidb.* to root;
Query OK, 0 rows affected (0.01 sec)
mysql> grant all on cactidb.* to
root@localhost;
Query OK, 0 rows affected (0.01 sec)
mysql> grant all on cactidb.* to
cactiuser;
Query OK, 0 rows affected (0.00 sec)
mysql> grant all on cactidb.* to
cactiuser@localhost;
Query OK, 0 rows affected (0.01 sec)
mysql> set password for
cactiuser@localhost=password(cactipw);
Query OK, 0 rows affected (0.00 sec)
mysql> exit
|