C:\Users\grpideas>mysql -u root -p
Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.0.51b-community-nt-log MySQL Community Edition (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> create database sip06;
Query OK, 1 row affected (0.05 sec)
mysql> insert into mysql.user(host,user,password) values ('localhost','sip',pass
word('sip'));
Query OK, 1 row affected, 3 warnings (0.20 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.09 sec)
mysql> grant all on sip06.* to sip@'localhost' identified by 'sip';
Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.0.51b-community-nt-log MySQL Community Edition (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> create database sip06;
Query OK, 1 row affected (0.05 sec)
mysql> insert into mysql.user(host,user,password) values ('localhost','sip',pass
word('sip'));
Query OK, 1 row affected, 3 warnings (0.20 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.09 sec)
mysql> grant all on sip06.* to sip@'localhost' identified by 'sip';
Query OK, 0 rows affected (0.05 sec)
C:\Users\grpideas>mysql -usip -psip sip06
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 5.0.51b-community-nt-log MySQL Community Edition (GPL)