进入 mariadb 命令行:sudo mysql -u root -p
创建缺失的数据库:CREATE DATABASE mysql;
切换到 mysql 数据库:USE mysql;
执行以下命令创建缺失的表格:
CREATE TABLE db (
Host varchar(60) NOT NULL DEFAULT '',
Db varchar(64) NOT NULL DEFAULT '',
User varchar(16) NOT NULL DEFAULT '',
Select_priv enum('N','Y') NOT NULL DEFAULT 'N',
Insert_priv enum('N','Y') NOT NULL DEFAULT 'N',
Update_priv enum('N','Y') NOT NULL DEFAULT 'N',
Delete_priv enum('N','Y') NOT NULL DEFAULT 'N',
Create_priv enum('N','Y') NOT NULL DEFAULT 'N',
Drop_priv enum('N','Y') NOT NULL DEFAULT 'N',
Grant_priv enum('N','Y') NOT NULL DEFAULT 'N',
References_priv enum('N','Y') NOT NULL DEFAULT 'N',
Index_priv enum('N','Y') NOT NULL DEFAULT 'N',
Alter_priv enum('N','Y') NOT NULL DEFAULT 'N',
Create_tmp_table_priv enum('N','Y') NOT NULL DEFAULT 'N',
Lock_tables_priv enum('N','Y') NOT NULL DEFAULT 'N',
Create_view_priv enum('N','Y') NOT NULL DEFAULT 'N',
Show_view_priv enum('N','Y') NOT NULL DEFAULT 'N',
Create_routine_priv enum('N','Y') NOT NULL DEFAULT 'N',
Alter_routine_priv enum('N','Y') NOT NULL DEFAULT 'N',
Execute_priv enum('N','Y') NOT NULL DEFAULT 'N',
Event_priv enum('N','Y') NOT NULL DEFAULT 'N',
Trigger_priv enum('N','Y') NOT NULL DEFAULT 'N',
PRIMARY KEY (Host,Db,User)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE user (
Host varchar(60) NOT NULL DEFAULT '',
User varchar(16) NOT NULL DEFAULT '',
Password varchar(41) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
Select_priv enum('N','Y') NOT NULL DEFAULT 'N',
Insert_priv enum('N','Y') NOT NULL DEFAULT 'N',
Update_priv enum('N','Y') NOT NULL DEFAULT 'N',
Delete_priv enum('N','Y') NOT NULL DEFAULT 'N',
Create_priv enum('N','Y') NOT NULL DEFAULT 'N',
Drop_priv enum('N','Y') NOT NULL DEFAULT 'N',
Reload_priv enum('N','Y') NOT NULL DEFAULT 'N',
Shutdown_priv enum('N','Y') NOT NULL DEFAULT 'N',
Process_priv enum('N','Y') NOT NULL DEFAULT 'N',
File_priv enum('N','Y') NOT NULL DEFAULT 'N',
Grant_priv enum('N','Y') NOT NULL DEFAULT 'N',
References_priv enum('N','Y') NOT NULL DEFAULT 'N',
Index_priv enum('N','Y') NOT NULL DEFAULT 'N',
Alter_priv enum