初始化Mariadb数据库+远程连接数据库

原创

已于 2022-09-28 11:09:24 修改 · 3.5k 阅读

11 ·

CC 4.0 BY-SA版权

文章标签：

#mariadb #数据库 #database

于 2022-05-09 19:46:12 首次发布

本文详细介绍了如何初始化Mariadb数据库，包括安装、启动、初始化和登录数据库的步骤。接着，文章讲解了如何设置数据库远程连接，提到了使用Navicat Premium这款数据库管理工具，并提供了远程连接MariaDB的四个关键步骤：授权root用户远程访问、激活数据库权限、开放服务器防火墙端口3306以及验证配置效果。

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

一.初始化Mariadb数据库

1.安装Mariadb

yum install mariadb mariadb-server

2.启动Mariadb

systemctl start mariadb
systemctl restart mariadb

3.初始化数据库

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): ``#当前数据库密码空的，直接回车
OK, successfully used password, moving on...
 
Setting the root password ensures that nobody can log into the MariaDB
root user without the proper authorisation.
 
Set root password? [Y``/n``] y  ``#设置root密码 
New password:
Re-enter new password:
Password