C:\>mysql -u root -p
mysql> create database meetme; Query OK, 1 row affected (0.01 sec)
mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | meetme | | mysql | | test | +--------------------+ 4 rows in set (0.02 sec)
mysql> use user_db; Database changed
mysql> show tables;
mysql> grant select,insert,delete,update,create,drop,file, alter,index on *.* to db_user identified by '123456'; mysql> flush privileges;
http://www.javadrive.jp/mysql/datatype/index.html
[mysql] set-variable=no-beep