重拾MySQL之Mariadb

如题

安装

1
2
3
4
5
yum -y install mariadb-server # 安装
systemctl start mariadb #启动服务
systemctl enable mariadb #设置开机启动
systemctl restart mariadb #重新启动
systemctl stop mariadb.service #停止MariaDB

配置

1
mysql_secure_installation

根用户为：root/unclexiao

登陆

1
mysql -u root -p

操作

  • 查看所有数据库

    1
    show databases;

  • 创建表

    1
    2
    3
    4
    5
    6
    7
    CREATE TABLE students(  
        student_id INT NOT NULL AUTO_INCREMENT,  
        student_name VARCHAR(100) NOT NULL,  
        student_address VARCHAR(40) NOT NULL,  
        admission_date DATE,  
        PRIMARY KEY ( student_id )
    );

  • 插入数据

    1
    2
    3
    INSERT INTO students  
    (student_id, student_name, student_address, admission_date)  
    VALUES(1,'Maxsu','Haikou','2017-01-07 00:00:00');

  • 查询数据

    1
    SELECT * FROM students;

  • 可视化界面

image

此次使用免费版的Sequal Pro