前置条件：

XAMPP安装​

配置phpMyAdmin​

打开phpmyadmin界面，选择SQL，进行如下操作：

一、创建数据库wikidb

create DATABASE wikidb;

MediaWiki在Windows安装部署——使用phpMyadmin创建Mediawiki所用数据库_sql创建用户语句

二、在wikidb创建用户wikiuser并设置密码：

CREATE USER 'risk'@'localhost' IDENTIFIED BY '123456'

CREATE USER 'risk'@'127.0.0.1' IDENTIFIED BY '123456'

CREATE USER 'risk'@'::1' IDENTIFIED BY '123456'

三、给创建用户赋权

GRANT all PRIVILEGES on wikidb.* to 'risk'@'localhost' WITH GRANT OPTION

GRANT all PRIVILEGES on wikidb.* to 'risk'@'127.0.0.1' WITH GRANT OPTION

GRANT all PRIVILEGES on wikidb.* to 'risk'@'::1' WITH GRANT OPTION