MARIADB Common Commands

1.Linux under Installation and initialization

#安装 Yum Install Mariadb-server

#设置编码 vim/etc/my.cnf

[Mysqld]
Character-set-server=utf8

#启动 systemctl Start mariadb

#自启动 Systemctl Enable MARIADB

#停止 Systemctl Stop mariadb

#初始化 mysql_secure_installation

2. Connect, view users, create users, authorize

#连接 mysql-u root-p-H IP Address

#查看用户 select User,host from Mysql.user;

#创建用户 INSERT INTO Mysql.user (User,host,password) VALUES (' MySQL ', '% ', password (' password '));

#修改密码 Update Mysql.user Set Password=password (' New password ') where user= ' username ';

#授权 sgrant insert,update,select,delete on database. * To user @ '% ';

#撤销权限 revoke Delete on database. * from user;

#更新权限 flush Privileges;

3. Common operation

Show variables like '%character% ';

Show Databases;/show schemas;

Use database;

Show tables;

Show full columns from table name;　　　

MARIADB Common Commands