linux中mysql安装指导

--------------mysql安装前准备工作----------------------
A. 查看mysql安装情况：
rpm -qa|grep -i mysql

B. 查找之前mysql的目录、并且删除之前mysql的文件和库
whereis mysql

C. 卸载后/etc/my.cnf不会删除，需要进行手工删除,执行下面命令
#rm -rf /etc/my.cnf

D. .再次检查机器是否还有mysql相关文件，执行下面命令
#rpm -qa|grep -i mysql

------------安装mysql步骤：---------------
1.
wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm

yum -y install mysql57-community-release-el7-10.noarch.rpm

yum install mysql-community-server

service mysqld start

grep ‘temporary password’ /var/log/mysqld.log
oy/lb+6*e=eR

mysql_secure_installation

mysql -V

mysql -uroot -p

vim /etc/my.cnf
service mysqld restart
skip-grant-tables
update mysql.user set authentication_string=password(‘123456’) where user=‘root’;
vim /etc/my.cnf
#skip-grant-tables
service mysqld restart

10. 修改成简单的密码
    首先，修改validate_password_policy参数的值

    mysql> set global validate_password_policy=0;
    Query OK, 0 rows affected (0.00 sec)
    1
    2
    validate_password_length(密码长度)参数默认为8，我们修改为1

    mysql> set global validate_password_length=1;
    Query OK, 0 rows affected (0.00 sec)
    1
    2
    4，完成之后再次执行修改密码语句即可成功

    mysql> alter user ‘root’@‘localhost’ identified by ‘123456’;
    Query OK, 0 rows affected (0.00 sec)