在Ubuntu上配置MariaDB的步骤如下：
sudo apt update
sudo apt upgrade -y
sudo apt install mariadb-server mariadb-client
sudo systemctl start mariadb
sudo systemctl enable mariadb
sudo systemctl status mariadb
mysql -u root -p
输入设置的root密码。
sudo mysql_secure_installation
按照提示设置root密码和其他安全设置。
sudo vim /etc/mysql/mariadb.conf.d/50-server.cnf
# bind-address = 127.0.0.1
sudo systemctl restart mariadb
CREATE DATABASE mydatabase;
CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'mypassword';
GRANT ALL PRIVILEGES ON mydatabase.* TO 'myuser'@'localhost';
FLUSH PRIVILEGES;
在MariaDB提示符下，运行以下查询以确认安装成功：
SELECT version();
