Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: 重装后root缺失mysql库
|
username: cf_data
[Test Environment for TiDB]
After uninstalling the previous version 7.4.0 and reinstalling 7.5.0, it started successfully. When connecting with the root user, I found that the MySQL database is indeed missing. Can anyone provide an answer?
Directly use the command mysql to log in and check, it might be that the tool is not displaying it.
Is there nothing when you go into the command line and run show databases?
Is it an issue with the tool’s filtering display?
You can log in using the MySQL client and confirm by running show databases.
It might be a tool issue. Generally, if you go into the command line and use “show database” and it appears, then there shouldn’t be a problem.
What tool are you using? First of all, the MySQL database won’t be missing; otherwise, the data wouldn’t be able to run normally. It could be a permissions issue, but it’s more likely a tool display issue. For example, in my 7.5 test environment, when I connect using Navicat, it shows up, but when I use MySQL Workbench, the MySQL database doesn’t show up.
It should be an issue with your database client display. MySQL is a system database that contains some user privilege tables and metadata. Without this database, you cannot access the cluster.
Check the tool’s settings to see if it has been filtered out.
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: