在mysql里面建立新的user,pw,db

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';

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)