centos 7 mariadb

服务无法启动.删除 mariadb,mariadb-server. 删除 /var/lib/MysqL 和 /etc/my.cnf 重新安装
开机启动
systemctl enable mariadb
服务启动
systemctl start mariadb
(status restart stop)
初始化:
MysqL_secure_installation
之后按照提示操作
开放端口:

firewall-cmd --zone=public --add-port=3306/tcp --peRMANent
    firewall-cmd --reload

链接:

MysqL -h host -u user -P port -p

创建用户:

insert into MysqL.user(Host,User,password) values("localhost","test",password("1234"));

授权:

grant SELEct,delete,update,create,drop on *.* to test@"%" identified by "1234";
    grant SELEct,update on testDB.* to test@localhost identified by '1234';
    GRANT ALL PRIVILEGES ON *.* TO 'admin'@'%' IDENTIFIED BY 'somepass' WITH GRANT OPTION;

刷新系统权限表:

　flush privileges;

utf8:
vi /etc/my.cnf

[MysqLd]
character-set-server = utf8 collation-server = utf8_general_ci skip-character-set-client-handshake

其他: show databases; use xxx; show tables;