CentOS7 安装 MySql

安装MySQL

先检查系统是否装有mysql

rpm -qa | grep mysql

删除

yum remove mysql

下载

	# 版本
 wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
 wget https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm

安装

yum install mysql-community-release-el7-5.noarch.rpm

安装服务

yum install mysql-server

授权

chown root /var/lib/mysql/

重新启动服务

service mysqld restart	

查看默认密码

cat /var/log/mysqld.log | grep 'temporary password'
or
grep 'temporary password' /var/log/mysqld.log

如果 ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using passwor:yes)

vim /etc/my.cnf
在[mysqld]后面任意一行添加“skip-grant-tables”用来跳过密码验证的过程

进入MySQL

mysql -u root -p

修改密码

alter user ‘root’@‘localhost’ identified by ‘admin’;
set global validate_password_policy=0;
set global validate_password_length=1;
alter user ‘root’@‘localhost’ identified by ‘admin’;

mysql > use mysql;
mysql > update user set password=password('admin') where user='root';
mysql > exit;

5.7 以上

 update mysql.user set authentication_string=password('admin') where user='root';  

远程登陆

GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "admin";

显示编码

show variables like "%char%";

设置编码

set names utf8;

使其生效

FLUSH PRIVILEGES