MySQL——在Linux下安装和卸载MariaDB
摘要:本文主要学习了如何在Linux系统中安装和卸载MariaDB数据库。
查看有没有安装过MariaDB
使用命令查看有没有安装过:
1 [root@localhost ~]# yum list installed | grepmariadb2 mariadb-libs.x86_64 1:5.5.44-2.el7.centos @anaconda3 [root@localhost ~]#
使用的系统是CentOS版本是7.2.1511,可以看到系统只是安装了用到的libs包,并没有安装MariaDB的服务端和客户端。
安装MariaDB
安装
使用命令安装:
1 [root@localhost ~]# yum install -y mariadb mariadb-server2 已加载插件:fastestmirror3 Loading mirror speeds from cached hostfile4 *base: mirrors.huaweicloud.com5 *extras: mirrors.huaweicloud.com6 *updates: mirrors.huaweicloud.com7 正在解决依赖关系8 -->正在检查事务9 ...10 完毕!11 [root@localhost ~]#
使用命令查看安装的程序:
1 [root@localhost ~]# yum list installed | grepmariadb2 mariadb.x86_64 1:5.5.60-1.el7_5 @base3 mariadb-libs.x86_64 1:5.5.60-1.el7_5 @base4 mariadb-server.x86_64 1:5.5.60-1.el7_5 @base5 [root@localhost ~]#
启动服务
查看MariaDB的状态:
1 [root@localhost ~]# systemctl status mariadb2 ● mariadb.service -MariaDB database server3 Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)4 Active: inactive (dead)5 [root@localhost ~]#
启动MariaDB并查看MariaDB的状态:
1 [root@localhost ~]# systemctl start mariadb2 [root@localhost ~]# systemctl status mariadb3 ● mariadb.service -MariaDB database server4 Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)5 Active: active (running) since 六 2019-07-13 05:19:08CST; 36s ago6 Process: 4162 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=0/SUCCESS)7 Process: 4082 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS)8 Main PID: 4161(mysqld_safe)9 CGroup: /system.slice/mariadb.service10 ├─4161 /bin/sh /usr/bin/mysqld_safe --basedir=/usr11 └─4323 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mariadb/mariadb.log --pid-file=/var/run/mariadb/mariadb.pid --socke...12 ...13 [root@localhost ~]#
连接数据库
连接并查看版本:
1 [root@localhost ~]# mysql -uroot2 Welcome to the MariaDB monitor. Commands end with ; or \g.3 Your MariaDB connection id is 2
4 Server version: 5.5.60-MariaDB MariaDB Server5
6 Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.7
8 Type 'help;' or '\h' for help. Type '\c' to clearthe current input statement.9
10 MariaDB [(none)]> selectversion();11 +----------------+
12 | version() |
13 +----------------+
14 | 5.5.60-MariaDB |
15 +----------------+
16 1 row in set (0.00sec)17
18 MariaDB [(none)]>
退出:
1 MariaDB [(none)]>exit2 Bye3 [root@localhost ~]#
简单配置
使用命令对MariaDB进行简单配置:
1 [root@localhost ~]# mysql_secure_installation2
3 NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB4 SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!
输入当前的密码,如果没有设置就回车:
1 In order to log into MariaDB to secure it, we'll need the current
2 password for the root user. If you've just installed MariaDB, and
3 you haven't set the root password yet, the password will be blank,
4 so you should just press enter here.5
6 Enter current password for root (enter fornone):7 OK, successfully used password, moving on...
是否为root用户设置密码:
1 Setting the root password ensures that nobody can log into the MariaDB2 root user without the proper authorisation.3
4 Set root password? [Y/n] Y5 New password:6 Re-enter new password:7 Password updated successfully!
8 Reloading privilege tables..9 ... Success!
是否删除匿名用户:
1 By default, a MariaDB installation has an anonymous user, allowing anyone2 to log into MariaDB without having to have a user account created for
3 them. This is intended only for testing, and to makethe installation4 go a bit smoother. You should remove them before moving into a5 production environment.6
7 Remove anonymous users? [Y/n]8 ... Success!
是否允许root用户远程登录:
1 Normally, root should only be allowed to connect from 'localhost'. This2 ensures that someone cannot guess at the root password from the network.3
4 Disallow root login remotely? [Y/n]5 ... Success!
是否删除test数据库:
1 By default, MariaDB comes with a database named 'test'that anyone can2 access. This is also intended only fortesting, and should be removed3 before moving into a production environment.4
5 Remove test database and access to it? [Y/n]6 -Dropping test database...7 ... Success!
8 -Removing privileges on test database...9 ... Success!
是否重新加载权限表:
1 Reloading the privilege tables will ensure that all changes made so far2 will take effect immediately.3
4 Reload privilege tables now? [Y/n]5 ... Success!
设置完成:
1 Cleaning up...2
3 All done! If you've completed all of the above steps, your MariaDB
4 installation should now be secure.5
6 Thanks for using MariaDB!
7 [root@localhost ~]#
卸载MariaDB
使用命令卸载安装包:
1 [root@localhost ~]# yum remove -y mariadb-libs2 已加载插件:fastestmirror3 正在解决依赖关系4 -->正在检查事务5 ...6 完毕!7 [root@localhost ~]#
查看卸载后的安装情况:
1 [root@localhost ~]# yum list installed | grepmariadb2 [root@localhost ~]#
表明已经从系统中卸载了。