MySQL

1. 建立 user:

   mysql -uroot -p
   select * from mysql.user;     (顯示使用者清單)
   use mysql;
   INSERT INTO user(host,user,password) VALUES('%','admincbnnTVn',password('TmHMTHhfUm9N'));
   GRANT ALL ON *.* TO 'admincbnnTVn'@localhost IDENTIFIED BY 'TmHMTHhfUm9N' WITH GRANT OPTION;
   FLUSH PRIVILEGES;
   \q
   mysql -u admincbnnTVn -p
   

2. 建立 table

   CREATE TABLE Profile (name char(50), date datetime, type char(10), remark char(50));
   INSERT INTO profile (name, date, type, remark) values ('Puffball', '1999-03-30', 'f', '');