MySQL 系統指令

MySQL.exe
登入
mysql -h hostname -u username -p
設定密碼
set password for root@localhost=password('password');
產生一般用帳號
grant create, create temporary tables, delete, execute,index, insert, lock tables, select,show databases, update
on *.*
to %username% identified by '%password%'
顯示資料庫
show databases
切換資料庫
use databasename
顯示資料表
show tables