【已解决】mysql导入数据，权限不足

zhangshengdong

[root@mysql-n1 ~]# /usr/local/mysql55/bin/mysql -uzsd_oper -pzsd_oper -S /data/mysqldata/3306/mysql.sock zsd<t_wiki_zsd.sql
ERROR 1044 (42000) at line 34: Access denied for user 'zsd_oper'@'localhost' to database 'zsd'
[root@mysql-n1 ~]# /usr/local/mysql55/bin/mysql -S /data/mysqldata/3306/mysql.sock
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 39
Server version: 5.5.25-log zsd edition

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 grants for zsd_oper@'localhost';
+-----------------------------------------------------------------------------------------------------------------+
| Grants for zsd_oper@localhost                                                                                   |
+-----------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'zsd_oper'@'localhost' IDENTIFIED BY PASSWORD '*29DB2514EC50AA394BE19A16E6E610FE0870F2DD' |
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON `zsd`.* TO 'zsd_oper'@'localhost'                         |
+-----------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)

mysql>

dump的时候报我权限不足，我进去查看zsd_oper发现有对应数据库的权限，这是为什么？

zhangshengdong

说错了，是导入数据的时候，权限不足

zhangshengdong

问题解决了还少了两种权限：

zhangshengdong

mysql> grant LOCK TABLES on zsd.* to zsd_oper@'localhost';
Query OK, 0 rows affected (0.00 sec)

mysql> grant alter on zsd.* to zsd_oper@'localhost';
Query OK, 0 rows affected (0.00 sec)

由于dump出来的文件里面有锁表和alter操作。