[mysql] 3/4 上課內容

C:\Documents and Settings\Administrator>cd c:\appserv\mysql\bin




C:\AppServ\mysql\bin>mysql -u root -p

Enter password:                                                 ((請直接按enter



mysql> grant all privileges on my_database.* To 'user'@'localhost'identified by

'123' with grant option;                             ((在my_database 新增 帳號user 密碼





mysql> flush privileges;



mysql> grant all privileges on mysql.* To 'user';



mysql> flush privileges;



mysql> exit



C:\AppServ\mysql\bin>mysql -u user -p

Enter password: ***                 ((輸入123



mysql> show databases;



mysql> create database my_database;



mysql> use my_database;



mysql> \. c:\orders.sql                 ((請先下載到 c: 檔案



mysql> show tables;



mysql>