Shulou(Shulou.com)05/31 Report--

How to install MySQL8.0 in a CentOS 7.4 64-bit system? Many novices are not very clear about this. In order to help you solve this problem, the following editor will explain it in detail. People with this need can come and learn. I hope you can gain something.

Step 1: get the mysql YUM source

Click download

Step 2: download and install the mysql source

Go to the mysql folder and create your own if you don't have it.

[root@VM_0_10_centos /] # cd / usr/local/mysql/ [root @ VM_0_10_centos mysql] #

Download the source installation package

[root@VM_0_10_centos mysql] # wget https://repo.mysql.com//mysql80-community-release-el7-1.noarch.rpm--2018-08-04 10 root@VM_0_10_centos mysql 2939 root@VM_0_10_centos mysql-https://repo.mysql.com//mysql80-community-release-el7-1.noarch.rpmResolving repo.mysql.com (repo.mysql.com) 23.219.33.198Connecting to repo.mysql.com (repo.mysql.com) | 23.219.33.198 |: 443. Connected.HTTP request sent, awaiting response... 200 OKLength: 25820 (25K) [application/x-redhat-package-manager] Saving to: 'mysql80-community-release-el7-1.noarch.rpmhands 25820 [= = >] 25820 112KB/s in 0.2s 2018-08-04 10:29:40 (112KB/s) -' mysql80-community-release-el7-1.noarch.rpm' saved [25820 apprentice 25820] [root@VM_0_10_centos mysql] # lltotal 28 RWMART Apr-1 root root 25820 Apr 18 13:24 mysql80-community-release-el7-1.noarch.rpm [root @ VM_0_10_centos mysql] #

Install the mysql source

[root@VM_0_10_centos mysql] # yum-y localinstall mysql80-community-release-el7-1.noarch.rpm

Step 3: install MySQL online

[root@VM_0_10_centos mysql] # yum-y install mysql-community-server

There are a lot of downloads. Wait a few minutes.

Step 4: start the Mysql service

[root@VM_0_10_centos mysql] # systemctl start mysqld

Step 5: set boot up

[root@VM_0_10_centos mysql] # systemctl enable MySQL [root @ VM_0_10_centos mysql] # systemctl daemon-reload

Step 6: change the root local login password

After the mysql installation is complete, a temporary default password is generated for root in the / var/log/mysqld.log file. Search it with the grep command

[root@VM_0_10_centos mysql] # grep "A temporary password is generated for root@localhost" / var/log/mysqld.log 2018-08-02T02:19:55.829527Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost:! J:KUwU9y0ZR2018-08-02T04:49:34.979689Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: pw

Change the temporary password of root account

Mysql > ALTER USER 'root'@'localhost' IDENTIFIED BY' Pwd123@easyoh.net';Query OK, 0 rows affected (0.03 sec) mysql >

Pwd123@easyoh.net, please replace it with your own password.

(note mysql8.0 default password policy requires that the password must be a combination of uppercase and lowercase alphanumeric special letters, at least 8 digits.)

Step 7: create a new user, authorize, log in remotely (do not log in directly using a root account)

Create an easyoh-mp user and authorize remote login

Mysql > CREATE USER 'easyoh-mp'@'%' IDENTIFIED BY' Pwd123@easyoh.net';Query OK, 0 rows affected (0.04 sec) mysql > GRANT ALL ON *. * TO 'easyoh-mp'@'%';Query OK, 0 rows affected (0.03 sec) mysql >

Log in with an easyoh-mp account on the sqlyog client (other clients can also do as you like)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.