MariaDb安装报错1067

1、安装最新版mariadb

D:\ProgramFiles\mariadb-10.5.6-winx64\bin>mysqld --install
Service successfully installed.

MariaDb重装后在启动服务时报错1067

D:\ProgramFiles\mariadb-10.5.6-winx64\bin>net start mysql
MySQL 服务正在启动 ...
MySQL 服务无法启动。

系统出错。

发生系统错误 1067。

进程意外终止。

处理办法：

初始化mysql：mysql_install_db

D:\ProgramFiles\mariadb-10.5.6-winx64\bin>mysql_install_db
Default data directory is D:\ProgramFiles\mariadb-10.5.6-winx64\data
Running bootstrap
2020-11-02  9:37:40 0 [Note] D:\ProgramFiles\mariadb-10.5.6-winx64\bin\mysqld.exe (mysqld 10.5.6-MariaDB) starting as process 980 ...
Removing default user
Creating my.ini file
Creation of the database was successful

执行以上的命令后，系统会在MariaDb安装文件下的data生成对应的文件。然后再次执行启动服务：

D:\ProgramFiles\mariadb-10.5.6-winx64\bin>net start mysql
MySQL 服务正在启动 .
MySQL 服务已经启动成功。

2、安装后初始密码为空，在输密码时直接按回车进入

D:\ProgramFiles\mariadb-10.5.6-winx64\bin>mysql -u root -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 3
Server version: 10.5.6-MariaDB mariadb.org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>

设置初始密码

MariaDB [(none)]> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('自己的密码');