Centos 7 如何安装mysql数据库服务器

2026-01-14 17:59:33

1、打开终端 运行命令 sudo yum install -y mariadb-server

Centos 7 如何安装mysql数据库服务器

2、sudo需要输入用户密码

Centos 7 如何安装mysql数据库服务器

3、等待安装,提示

 完毕!

Centos 7 如何安装mysql数据库服务器

4、运行命令

systemctl enable mariadb  开启服务开机启动

systemctl start mariadb  启动服务

Centos 7 如何安装mysql数据库服务器

5、运行命令

systemctl status mariadb

显示 active(running)

确认服务器已正常运行

Centos 7 如何安装mysql数据库服务器

6、运行命令

mysql_secure_installation

初始化数据库

Centos 7 如何安装mysql数据库服务器

7、提示输入root密码

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 currentpassword for the root user.  If you've just installed MariaDB, andyou 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):

新安装密码为空,直接回车

Centos 7 如何安装mysql数据库服务器

8、OK, successfully used password, moving on...Setting the root password ensures that nobody can log into the MariaDBroot user without the proper authorisation. Set root password? [Y/n]

提示是否设置 root 密码  输入 Y

Centos 7 如何安装mysql数据库服务器

9、输入两次密码

New password: Re-enter new password: Password updated successfully!Reloading privilege tables.. ... Success!By default, a MariaDB installation has an anonymous user, allowing anyoneto log into MariaDB without having to have a user account created forthem.  This is intended only for testing, and to make the installationgo a bit smoother.  You should remove them before moving into aproduction environment.Remove anonymous users? [Y/n]

提示是否删除系统创建的匿名用户  输入 Y

Centos 7 如何安装mysql数据库服务器

10、...Success!Normally, root should only be allowed to connect from 'localhost'.  Thisensures that someone cannot guess at the root password from the network.Disallow root login remotely? [Y/n]

提示是否禁止root用户远程登陆  输入 Y

Centos 7 如何安装mysql数据库服务器

11、By default, MariaDB comes with a database named 'test' that anyone canaccess.  This is also intended only for testing, and should be removedbefore moving into a production environment.Remove test database and access to it? [Y/n]

提示是否删除test数据库  输入 Y

Centos 7 如何安装mysql数据库服务器

12、- Dropping test database... ... Success! - Removing privileges on test database... ... Success!Reloading the privilege tables will ensure that all changes made so farwill take effect immediately.Reload privilege tables now? [Y/n]

提示是否立即重新加载权限配置 输入 Y

Centos 7 如何安装mysql数据库服务器

13、... Success!All done!  If you've completed all of the above steps, your MariaDBinstallation should now be secure.Thanks for using MariaDB!

输入命令 mysql -uroot -p

Centos 7 如何安装mysql数据库服务器

14、按提示输入密码

登陆数据库成功显示提示符

MariaDB[(none)]>   

Enjoy it !!!

Centos 7 如何安装mysql数据库服务器

声明:本网站引用、摘录或转载内容仅供网站访问者交流或参考,不代表本站立场,如存在版权或非法内容,请联系站长删除,联系邮箱:site.kefu@qq.com。
猜你喜欢