Consolidating MySQL Servers

Lab Environment: CentOS7

[email protected]~ localhost] #yum-y install Mariadb-server[[Email protected]~localhost] #mysql_secure_installation #数据库安全加固note:running All PARTS of this SCRIPT are 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 would be a blank,so you should just press ENTER here. Enter current password to root (enter for none):#默认密码为空, so just press ENTER! Password is null and unsafe, you need to set firstOK, 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] Y#是否设置root的登录密码: Y needs to be setNew Password:re-enter New Password:password updated successfully!#密码已设置成功Reloading privilege tables. ... success!  By default, a MariaDB installation had an anonymous user, allowing Anyoneto log into MariaDB without had to had a user  Account created Forthem.  This was intended only for testing, and the Installationgo a bit smoother. You should remove them before moving into aproduction environment. Remove anonymous users? [y/n] Y#是否移除anonymous用户... success! Normally, Root should only is allowed to connect from' localhost '. Thisensures that someone cannot guess at the root of password from the network. Disallow Root login remotely? [y/n] Y #是否不允许root的远程登录... success! By default, MariaDB comes with a database named' Test 'That anyone canaccess. This was also intended only for testing, and should was removedbefore moving into a production environment. Remove test database and access to it? [y/n] n #是否移除test数据库, and forbidden to access ... skipping. Reloading the privilege tables would ensure that all changes made so farwill take effect immediately. Reload privilege tables now? [y/n] Y #是否重载权限表 ... Success! Cleaning up ...  All done! If You‘ve completed all of the above steps, your mariadbinstallation should now is secure. Thanks forUsing mariadb!

Consolidating MySQL Servers