今日BUG：Mysql服务启动不了（[ERROR] Fatal error: Can‘t open and lock privilege tables: Table ‘mysql.user‘ doe）

查看了mysql的错误日志：

文件地址：C:\ProgramData\MySQL\MySQL Server 5.5\data\DESKTOP-8OU81R5.err

220211 15:49:40 InnoDB: 5.5.40 started; log sequence number 4070807
220211 15:49:40 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
220211 15:49:40 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
220211 15:49:40 [Note] Server socket created on IP: '0.0.0.0'.
220211 15:49:40 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist

然后查阅了一下该错误的原因：

mysql数据库默认位置和自定义安装位置不同导致

我的自定义安装位置

D:\Program Files\MySQL\MySQL Server 5.5 

之前的my.ini配置为：

D:\Program Files\MySQL\MySQL Server 5.5\my.ini

#Path to installation directory. All paths are usually resolved relative to this.

#mysql的安装目录
basedir="D:/Program Files/MySQL/MySQL Server 5.5/"

#Path to the database root
datadir="C:/Program Files/MySQL/MySQL Server 5.5/data/"

 昨天还没问题，今天用着就有问题了

然后更改my.nin配置：

将data文件夹和base文件夹（mysql的安装目录）配置在一个盘（都在D盘）

#Path to installation directory. All paths are usually resolved relative to this.
basedir="D:/Program Files/MySQL/MySQL Server 5.5/"

#Path to the database root
datadir="D:/Program Files/MySQL/MySQL Server 5.5/data/"

同时把之前在c盘下的data文件中所有数据文件都挪到了D盘的data文件夹中

更改之后mysql服务就能正常启动了 

总结：（我认为）

basedir和datadir的地址配置到同一个盘里即可