Invalid (old ?) Tableordatabasename: the reply user prompts that mysql cannot be accessed. Here are some solutions on the Internet.
Invalid (old ?) Table or database name \ 'recovery user \ 'prompt, resulting in mysql access failure. Here are some solutions available on the Internet.
Error
Event Type: Error
Event Source: MySQL
Event Type: None
Event ID: 100
Date: 2012-10-12
Event: 20:42:04
User: N/
Computer: ADMINISTRATOR74
Description:
Invalid (old ?) Table or database name 'recovery user'
For more information, see Help and Support Center at http://www.mysql.com.
Solution
I stopped mysql, renamed/var/lib/mysql/database-name to/var/lib/mysql/database_name, and then ran this SQL to update the permissions:
I stopped MySQL, renamed the/var/lib/MySQL/var li mysql DATABASE_NAME database name, and then run the SQL update permission:
| The code is as follows: |
|
UPDATE mysql. db SET Db = 'database _ name' WHERE Db = 'database-name '; Flush privileges; |