Catalog

install

land

Change Password

Remote login

---

There are many installations on the Internet mysql Methods , But it's too much and too complicated , So record my installation process , Convenient for later use

install

Check to see if there is mysql Residual ：rpm -qa | grep mysql        If there is residue, you need to uninstall .

  install wget:  yum -y install wget

download MySQL Warehouse ：

 wget https://repo.mysql.com//mysql80-community-release-el7-3.noarch.rpm

install ：

yum -y install mysql80-community-release-el7-3.noarch.rpm

install mysql：yum -y install mysql-community-server --nogpgcheck

start-up mysql：systemctl start mysqld.service

land

View the default password ：cat /var/log/mysqld.log | grep password

 root@localhost: And then there's the code , Be careful No, Space

land ：mysql -uroot -p

Change Password

After successful login , Need to change password （ Upper and lower case alphanumeric characters ）

ALTER USER 'root'@'localhost' IDENTIFIED BY 'Root_123';

If you want a simple password , It needs to be set , However, you must change the complex password above before you can perform the following operations

Set the minimum length to 4 position ：set global validate_password.length=4;

Set the complexity to a minimum ( Just match the length )： set global validate_password.policy=0;

If you want to set the same password and account , It also needs to be ：set global validate_password.check_user_name=OFF; 

Then you can change the simple password ：ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

Remote login

If you want to log in to the database remotely , You need to execute the following three commands ：

create user 'root'@'%' identified with mysql_native_password by '123456'; 

123456 The password of remote login can be changed to be complex , It can be different from the local login above .

grant all privileges on *.* to 'root'@'%' with grant option;

 flush privileges;

If you want to change the password of the remote login account ：

alter user 'root'@'%' identified with mysql_native_password by '123.com'; 

use navicat Remote connection database

Choose new mysql Connect

  Fill in the information

Server's ip You need to use the command to view

If it's a virtual machine ： Direct command ：ip a

  If it is an ECS, enter a command to view the public network ip:    curl inet-ip.info