linux系统 mysql安装

yum -y install mariadb mariadb-server
systemctl start mariadb
systemctl enable mariadb
mysql_secure_installation

Enter current password for root (enter for none)  回车
Set root password? [Y/n]                          回车
New password:                                     设置root密码  congcong
Re-enter new password:                            重输root密码  congcong
Remove anonymous users? [Y/n]                     回车
Disallow root login remotely? [Y/n]               回车
Remove test database and access to it? [Y/n]      回车
Reload privilege tables now? [Y/n]                回车

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
lower_case_table_names=1

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

systemctl restart mariadb

mysql -u root -p
root用户密码
use mysql;
grant all privileges on *.* to root@'%' identified by 'congcong';
flush privileges;

————————————————————————————————————————————————————————————————————————————————————————————————————
// 修改密码
UPDATE mysql.user SET password=PASSWORD('新密码') WHERE User="root" AND Host="%";
// 删除用户
DELETE FROM user WHERE User="phplamp" AND Host="localhost";