安装mariadb

1
apt-get install -y mariadb-server

更改root密码

1
mysql_secure_installation

重启

1
systemctl restart mariadb

开机自启动

1
systemctl enable mariadb

建库

登录mysql

1
mysql -u root 
1
2
3
4
5
CREATE DATABASE nextcloud;
CREATE USER 'oc_next'@'localhost' IDENTIFIED BY "123456";
GRANT ALL PRIVILEGES ON nextcloud.* TO 'oc_next'@'localhost';
grant all privileges on nextcloud.* to 'oc_next'@'%' identified by '123456' with grant option;
FLUSH PRIVILEGES;

开放远程连接

1
vi /etc/mysql/mariadb.conf.d/50-server.cnf

修改绑定IP127.0.0.1为0.0.0.0

开放防火墙

1
ufw allow 3306