mysql employees sample database

1.下载sample database

mysql employees sample database 下载链接

http://dev.mysql.com/doc/employee/en/index.html

2.创建用户

mysql> create user 'employee'@'localhost' identified by 'employee';
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

核实

mysql> select host,user from user;
+-------------------+----------+
| host              | user     |
+-------------------+----------+
| 127.0.0.1         | root     |
| localhost         |          |
| localhost         | employee |
| localhost         | root     |
| node1.localdomain |          |
| node1.localdomain | root     |
+-------------------+----------+
6 rows in set (0.00 sec)

 3.解压安装包

[root@node1 ~]# tar -jxvf employees_db-full-1.0.6.tar.bz2

4.开始导入数据

[root@node1 ~]# cd employees_db
[root@node1 employees_db]# ls
Changelog                   employees_partitioned.sql  load_dept_emp.dump      load_salaries.dump  README
employees_partitioned2.sql  employees.sql              load_dept_manager.dump  load_titles.dump    test_employees_md5.sql
employees_partitioned3.sql  load_departments.dump      load_employees.dump     objects.sql         test_employees_sha.sql
[root@node1 employees_db]# vi README
[root@node1 employees_db]# mysql -t <employees.sql
+-----------------------------+
| INFO                        |
+-----------------------------+
| CREATING DATABASE STRUCTURE |
+-----------------------------+
+------------------------+
| INFO                   |
+------------------------+
| storage engine: InnoDB |
+------------------------+
+---------------------+
| INFO                |
+---------------------+
| LOADING departments |
+---------------------+
+-------------------+
| INFO              |
+-------------------+
| LOADING employees |
+-------------------+
+------------------+
| INFO             |
+------------------+
| LOADING dept_emp |
+------------------+
+----------------------+
| INFO                 |
+----------------------+
| LOADING dept_manager |
+----------------------+
+----------------+
| INFO           |
+----------------+
| LOADING titles |
+----------------+
+------------------+
| INFO             |
+------------------+
| LOADING salaries |
+------------------+
[root@node1 employees_db]#

5.查看导入的数据

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| employees          |
| mysql              |
| test               |
+--------------------+
4 rows in set (0.00 sec)

mysql> use employees;
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
mysql> show tables;
+---------------------+
| Tables_in_employees |
+---------------------+
| departments         |
| dept_emp            |
| dept_manager        |
| employees           |
| salaries            |
| titles              |
+---------------------+
6 rows in set (0.00 sec)

mysql>

6.授权

mysql> grant all on employees.* to employee;
Query OK, 0 rows affected (0.00 sec)

7.测试权限

[root@node1 employees_db]# mysql -u employee -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 5.1.61 Source distribution

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| employees          |
| test               |
+--------------------+
3 rows in set (0.00 sec)

mysql> use employees;
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
mysql> show tables;
+---------------------+
| Tables_in_employees |
+---------------------+
| departments         |
| dept_emp            |
| dept_manager        |
| employees           |
| salaries            |
| titles              |
+---------------------+
6 rows in set (0.00 sec)

mysql>