08.CentOS MariaDB 相关

一.安装MariaDB

yum install -y mariadb*
systemctl start mariadb
firewall-cmd --add-service=mysql --permanent #防火墙放行

二.更改数据库密码

1.当root用户没有密码时

mysqladmin -u root password 123456 #密码设置为123456

2.修改root密码

mysqladmin -u root -p old-password abc123  #abc123为新密码回车后输入老密码,注意：old-password是参数，不是旧密码

三、创建数据库、数据表

[root@dns ~]# mysql -u root -p
MariaDB [(none)]> create database aaa;
MariaDB [aaa]> create table tb ( 
    -> id int primary key,
    -> name varchar (30) not null,
    -> age int ,
    -> sex char(2),
    -> birth date);

四、插入数据

MariaDB [aaa]>desc tb; #显示表结构
+-------+-------------+------+-----+---------+-------+
| Field | Type        | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| id    | int(11)     | NO   | PRI | NULL    |       |
| name  | varchar(30) | NO   |     | NULL    |       |
| age   | int(11)     | YES  |     | NULL    |       |
| sex   | char(2)     | YES  |     | NULL    |       |
| birth | date        | YES  |     | NULL    |       |
+-------+-------------+------+-----+---------+-------+
5 rows in set (0.01 sec)

MariaDB [aaa]> insert into tb 
    -> (id,name,age,sex,birth) 
    -> values 
    -> (1,'zhang',20,'M',20190101);
Query OK, 1 row affected (0.00 sec)

导入导出

#aa.txt内容用vim先编辑好，对照着表的格式，将/root/aa.txt的内容导入到表aa中
load data local infile '/root/aa.txt' into table aa;
#先将/root/mysql的权限设置成777，若不设置会报错，也可不加路径，会导出到/var/lib/mysql/目录下的表名目录
select * into outfile '/root/mysql/bb.txt' from aa;