mysql 用户除了root一般不建议本地登录

1. 创建数据库:
mysql> create database zjzc  DEFAULT CHARACTER SET utf8;
Query OK, 1 row affected (0.14 sec)


2.导入数据
v-lhb-db03:/root/20150512/zjzc# mysql -uroot -p1234567 zjzc<zjzc_20150512.sql 
Warning: Using a password on the command line interface can be insecure.


3.创建用户

 GRANT USAGE ON *.* TO 'zjzc_app'@'%' IDENTIFIED BY '1234567';

mysql>  GRANT ALL PRIVILEGES ON zjzc.*  TO 'zjzc_app'@'%';
Query OK, 0 rows affected (0.02 sec)


mysql> select Host,user from mysql.user;
+------------+----------+
| Host       | user     |
+------------+----------+
| %          | test     |
| %          | zjzc_app |
| 127.0.0.1  | root     |
| ::1        | root     |
| localhost  |          |
| localhost  | root     |
| v-lhb-db03 |          |
| v-lhb-db03 | root     |
+------------+----------+
8 rows in set (0.00 sec)

mysql> show grants for 'zjzc_app'@'%&#