推荐点击下面图片，通过本站淘宝优惠价购买:
Linux安装MariaDB+初始化数据库
背景说明：
在数据库中，mysql的是常用的数据库之一；作为一款开源的软件被广大公司所使用。
但是，mysql在被Oracle公司收购后，难免在以后会有取消开源的问题。所以急需一款新的数据库产品替换mysql的地位，就现在而言当前大多数主流linux发行版已经采用了mysql数据库的一个开源分支产品MariaDB，当前Google和Wikipedia已经采用了MariaDB数据库，也是为了防止以后mysql数据的技术垄断作的决定
安装MariaDB：
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 | [root@www ~]# yum install mariadb mariadb-server已加载插件：fastestmirror, langpacksLoading mirror speeds from cached hostfile * epel: mirrors.aliyun.com正在解决依赖关系 ... 已安装: mariadb.x86_64 1:5.5.60-1.el7_5 mariadb-server.x86_64 1:5.5.60-1.el7_5 作为依赖被安装: mariadb-libs.x86_64 1:5.5.60-1.el7_5 perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.el7 perl-Compress-Raw-Zlib.x86_64 1:2.061-4.el7 perl-DBD-MySQL.x86_64 0:4.023-6.el7 perl-DBI.x86_64 0:1.627-4.el7 perl-IO-Compress.noarch 0:2.061-2.el7 perl-Net-Daemon.noarch 0:0.48-5.el7 perl-PlRPC.noarch 0:0.2020-14.el7 完毕！ |
启动MariaDB数据库
1 2 3 | [root@localhost ~]# systemctl start mariadb.service[root@localhost ~]# systemctl enable mariadb.serviceCreated symlink from /etc/systemd/system/multi-user.target.wants/mariadb.service to /usr/lib/systemd/system/mariadb.service. |
数据库操作：
初始化数据库
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 | [root@localhost ~]# 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 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): #输入root密码，直接回车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] y #设置root密码 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 #删除匿名用户 ... 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] y #禁止root远程登录 ... Success! 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] y #删除test数据库和对此数据库的访问权限 - 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 #立即刷新权限 ... Success! Cleaning up... All done! If you've completed all of the above steps, your MariaDBinstallation should now be secure. Thanks for using MariaDB! |
设置防火墙的策略
1 2 | [root@localhost ~]# firewall-cmd --permanent --add-service=mysqlsuccess |
重新加载防火墙
1 2 | [root@localhost ~]# firewall-cmd --reloadsuccess |
本文链接：https://hqyman.cn/post/1693.html 非本站原创文章欢迎转载，原创文章需保留本站地址！
休息一下，本站随机推荐观看栏目:
