数据库操作学习

Mariadb

• 云主机一台：
• 操作系统：CentOS Linux release 7.6.1810 (Core)
• IP：云主机外网地址：206.13.27.31

2: eth0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP group default qlen 1000
    link/ether fa:16:3e:f8:f5:af brd ff:ff:ff:ff:ff:ff
    inet 172.16.16.4/20 brd 172.16.31.255 scope global noprefixroute eth0
       valid_lft forever preferred_lft forever

安装，初始化

[root@bcc11 ~]# yum -y install mariadb mariadb-server
[root@bcc11 ~]# systemctl enable mariadb
[root@bcc11 ~]# systemctl start mariadb
[root@bcc11 ~]# mysql_secure_installation  # 做一些常规化安全设置，选择是否允许远程登陆啥的

操作说明

[root@bcc11 ~]# mysql -u root -p