Mysql---安装测试数据库employees
具体可参考：http://dev.mysql.com/doc/employee/en/employees-installation.html
1.下载sample database
mysql employees sample database 下载链接
http://dev.mysql.com/doc/employee/en/index.html
2.创建用户
mysql> create user 'employee'@'localhost'>
Query OK, 0 rows affected (0.00 sec)
mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
3.解压安装包
The Employees database is compatible with all storage engines. You must edit the employee.sql and comment out the storage engine that you want to use:
set storage_engine = InnoDB;
-- set storage_engine = MyISAM;
-- set storage_engine = Falcon;
-- set storage_engine = PBXT;
-- set storage_engine = Maria;
4.开始导入数据
$ mysql -t < employees.sql --这里需要用户来运行即：
$ mysql -uroot -p -t < employees.sql
5.查看验证导入的数据
You can validate the Employee data using two methods, md5 and sha. Two SQL scripts are provided for this purpose, test_employees_sha.sql and test_employees_md5.sql. To run the tests, use mysql:
$ time mysql -t < test_employees_sha.sql$ time mysql -t < test_employees_md5.sql 6.授权
mysql> grant all on employees.* to employee;
Query OK, 0 rows affected (0.00 sec)
7.测试权限
# mysql -u employee -p
页:
[1]