1.安装
yum -y install mariadb mariadb-server
2.启动
systemctl start mariadb
systemctl enable mariadb
4.设置
mysql_secure_installation
一直回车
5、字符集
vi /etc/my.cnf
在[mysqld]标签下添加
init_connect='SET collation_connection = utf8_unicode_ci'
init_connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_unicode_ci
skip-character-set-client-handshake
文件/etc/my.cnf.d/client.cnf
vi /etc/my.cnf.d/client.cnf
在[client]中添加
default-character-set=utf8
vi /etc/my.cnf.d/mysql-clients.cnf
在[mysql]中添加
default-character-set=utf8
全部配置完成,重启mariadb
systemctl restart mariadb
查看
mysql -u root -p
输入密码
show variables like "%character%";show variables like "%collation%";
6.创建用户并赋权
mysql -u root -p
输入密码
use mysql;
mysql>grant all privileges on *.* to username@'%' identified by 'password';
注意后面的分号,
7.修改端口
vi /etc/my.cnf
在[mysqld]标签下添加
port=3308
重启
systemctl restart mariadb
检查
mysql -u -root -p
输入密码
查看现有端口
show global variables like 'port';