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 = utf8collation-server = utf8_general_ciskip-character-set-client-handshake

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