【环境】
cat /etc/redhat-release
CentOS Linux release 7.5.1804 (Core)
【安装】
yum install -y mariadb-server
【启动】
systemctl start mariadb.service
【状态查看】
systemctl status mariadb.service
【开机自启动】
systemctl enable mariadb.service
##################
【创建用户】
CREATE USER 'username'@'host' IDENTIFIED BY 'password';
【授权】
GRANT all privileges ON databasename.tablename TO 'username'@'host';
flush privileges;
grant all privileges on *.* to 'redhat'@'1.1.1.1' identified by 'redhat' with grant option;
flush privileges;
【修改密码】
SET PASSWORD FOR 'username'@'host' = PASSWORD('newpassword');
【撤销用户权限】
REVOKE privilege ON databasename.tablename FROM 'username'@'host';
【删除用户】
DROP USER 'username'@'host';
【查看默认端口】
命令行 通过mysql 直接登入刚安装的数据库
MariaDB [(none)]> show global variables like 'port';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| port | 3306 |
+---------------+-------+
【配置文件】
[root@localhost my.cnf.d]# pwd
/etc/my.cnf.d
[root@localhost my.cnf.d]# ls
client.cnf mysql-clients.cnf server.cnf
[root@localhost my.cnf.d]#
【修改数据库字符集】
alter database 数据库名 character set utf8
需要重启数据库生效
【修改表字符集】
ALTER TABLE table_name CONVERT TO CHARACTER SET utf8;