MySQL安装

yum -y install mariadb-server mariadb 

$ systemctl start mariadb # 启动

$ systemctl enable mariadb # 开机启动

$ mysql_secure_installation # 安全配置

 

登录：

$ mysql -u root -p1qaz3edc

show databases；

exit

 

create user abyss@'192.168...' identified by '1qaz';

grant all privileges on abyss_d.abyss_t to abyss@'192.168....';

SET PASSWORD FOR 'abyss'@'192.168....' = PASSWORD("1234")

drop user 'username'@'host'

 

create user 'abyss'@'localhost' identified by '1qaz';

grant all privileges on abyss_d.* to 'abyss'@'localhost';