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

1

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

2

sudo需要输入用户密码

3

等待安装，提示

完毕！

4

运行命令

systemctl enable mariadb  开启服务开机启动

systemctl start mariadb  启动服务

5

运行命令

systemctl status mariadb

显示 active(running)

确认服务器已正常运行

6

运行命令

mysql_secure_installation

初始化数据库

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):

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

8

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]

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

9

输入两次密码

New password:

Re-enter new password:

Password updated successfully!Reloading privilege tables..

... Success!By default, a MariaDB installation has an anonymous user, allowing anyone

to log into MariaDB without having to have a user account created forthem.  This is intended only for testing, and to make the installation

go a bit smoother.  You should remove them before moving into a

production environment.

Remove anonymous users? [Y/n]

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

10

...Success!Normally, root should only be allowed to connect from 'localhost'.  This

ensures that someone cannot guess at the root password from the network.

Disallow root login remotely? [Y/n]

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

11

By default, MariaDB comes with a database named 'test' that anyone can

access.  This is also intended only for testing, and should be removed

before moving into a production environment.

Remove test database and access to it? [Y/n]

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

12

- Dropping test database...

... Success!

- Removing privileges on test database...

... Success!Reloading the privilege tables will ensure that all changes made so far

will take effect immediately.

Reload privilege tables now? [Y/n]

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

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

14

按提示输入密码

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

MariaDB[(none)]>

Enjoy it ！！！

END