MySQL 命令行管理

以下命令为简单数据库管理命令，数据库的具体表管理、数据操作，可以使用其它工具（如MySQL Front）完成。

# mysql command interface
mysql -u root
mysql -u root -p

# manager database
mysql> show databases;
mysql> create database arn_iomc3;
mysql> drop database test;

# manage user
mysql> use mysql;
mysql> select user,host,password from user;

mysql> insert into user(host,user,password)
mysql> values('%', 'iomc3rw', password('iomc3rw'));
mysql> flush privileges;

mysql> grant all arn_iomc3.* to iomc3rw@'%' identified by 'iomc3rw';
mysql> flush privileges;

mysql> exit