Php文档 Php问答行业资讯 Php论坛 Php手册 Php博客

游戏榜单

软件榜单

关闭导航

热搜榜

热门下载

热门标签

关闭搜索

php爱好者> php文档>生产环境数据库授权改动但未刷新、造成生产环境..

生产环境数据库授权改动但未刷新、造成生产环境..

时间：2010-10-12 来源：sxxs001

mysql> USE yoohouse_alpha;

DATABASE changed

mysql> SHOW grants FOR ydb;

+----------------------------------------------------------------------------------------------------+

| Grants FOR ydb@% |

+----------------------------------------------------------------------------------------------------+

| GRANT USAGE ON *.* TO 'ydb'@'%' IDENTIFIED BY PASSWORD '*2DD3A4894A6C05E80F16754C1F59EB9E659AEA5D' |

| GRANT ALL PRIVILEGES ON `member`.* TO 'ydb'@'%' |

| GRANT ALL PRIVILEGES ON `yoohouse_estate`.* TO 'ydb'@'%' |

| GRANT ALL PRIVILEGES ON `yoohouse_alpha`.* TO 'ydb'@'%' |

+----------------------------------------------------------------------------------------------------+

4 rows IN SET (0.00 sec)

mysql> GRANT ALL PRIVILEGES ON dw.* TO ydb@'%' IDENTIFIED BY 'ydb2009!@#$';

Query OK, 0 rows affected (0.02 sec)

mysql> SHOW grants FOR ydb;

+----------------------------------------------------------------------------------------------------+

| Grants FOR ydb@% |

+----------------------------------------------------------------------------------------------------+

| GRANT USAGE ON *.* TO 'ydb'@'%' IDENTIFIED BY PASSWORD '*ABAC751648E921941D928207BF7FFAC003FB795A' |

| GRANT ALL PRIVILEGES ON `member`.* TO 'ydb'@'%' |

| GRANT ALL PRIVILEGES ON `dw`.* TO 'ydb'@'%' |

| GRANT ALL PRIVILEGES ON `yoohouse_estate`.* TO 'ydb'@'%' |

| GRANT ALL PRIVILEGES ON `yoohouse_alpha`.* TO 'ydb'@'%' |

+----------------------------------------------------------------------------------------------------+

5 rows IN SET (0.00 sec)

mysql> DELETE FROM mysql WHERE User='ydb';

ERROR 1146 (42S02): TABLE 'mysql.mysql' doesn't exist

mysql> delete from mysql.user where User='ydb';

Query OK, 1 row affected (0.00 sec)

mysql> mysql> flush privileges;

Query OK, 0 rows affected (0.04 sec)

mysql> grant all privileges on member.* to ydb@'%' identified by 'ydb2009!@#$}';

Query OK, 0 rows affected (0.00 sec)

mysql> grant all privileges on yoohouse_estate.* to ydb@'%' identified by 'ydb2009!@#$}';

Query OK, 0 rows affected (0.00 sec)

mysql> grant all privileges on yoohouse_alpha.* to ydb@'%' identified by 'ydb2009!@#$}';

Query OK, 0 rows affected (0.00 sec)

mysql> grant all privileges on dw.* to ydb@'%' identified by 'ydb2009!@#$}';

Query OK, 0 rows affected (0.01 sec)

生产环境数据库授权改动 但未刷新、造成生产 环境..

生产环境数据库授权改动但未刷新、造成生产环境..