mysql-我删除了用户表！我该如何恢复呢? [英] mysql - I deleted the user table! how can I recover it?

问题描述

我确定我是在意外中删除了"mysql"表，然后使此错误表mysql.user不存在"

I sure i deleted the table 'mysql' in an accident , then have maked this error "Table mysql.user dosen't exist"

我该如何修复它，或创建一个新表'mysql'

How can i fix it , or create a new table 'mysql'

推荐答案

注意，您不仅删除了表-还删除了整个mysql权限数据库. 您需要找到脚本"mysql_install_db".这将重新创建mysql权限数据库.

Note you did not just delete the table - you deleted the entire mysql permission database. You need to locate the script 'mysql_install_db'. This will recreate the mysql permissions database.

请注意，通过删除并重新创建权限数据库，其他应用程序可能会因为其用户/用户不再存在而停止工作.

Be aware that by deleting and recreating the permission database - other applications may stop working because their users/etc no longer exist.

这篇关于mysql-我删除了用户表！我该如何恢复呢?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！