ubuntu 18 安装 mariadb 10.1以上版本

最新推荐文章于 2025-02-23 19:30:00 发布

趣魂

最新推荐文章于 2025-02-23 19:30:00 发布

阅读量7.8k

点赞数

分类专栏：运维文章标签： ubuntu mariadb

本文链接：https://blog.youkuaiyun.com/zdyah/article/details/82354346

版权

该教程详细介绍了如何在Ubuntu 18上安装MariaDB 10.1及以上版本，包括设置root密码、移除匿名用户、禁止root远程登录、创建远程登录用户、配置监听地址以及处理访问异常问题，确保数据库的安全性和远程访问能力。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

文章目录

安装
启动&重启关闭
配置
远程访问
异常处理

安装

下载安装
sudo apt install mariadb-server
链接、测试
sudo mysql -u root -p
安装数据库实例
sudo mysql_secure_installation

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!
In order to log into MariaDB to secure it, we’ll need the current
password for the root user. If you’ve just installed MariaDB, and
you haven’t set the root password yet, the password will be blank,
so you should just press enter here.
Enter current password for root (enter for none): 设置root的密码
OK, successfully used password, moving on…
Setting the root password ensures that nobody can log into the MariaDB
root user without the proper authorisation.
You already have a root password set, so you can safely answer ‘n’.
Change the root pass