Virtual Machine Centos 6.8 Installs MYSQL5.7, Local Navicat Connection

Time:2019-6-25

Virtual Machine and entos

Virtual machines use Centos6.8 in VMware environment, but choose Centos7 for themselves

Virtual Machine Centos 6.8 Installs MYSQL5.7, Local Navicat Connection

I downloaded the DVD version.

Then there’s the usual installation, which is relatively simple.

Yum configuration

Step 1: Back up your original image file so that it can be restored after an error occurs.

mv /etc/yum.repos.d/CentOS-Base.repo /etc/yum.repos.d/CentOS-Base.repo.backup

Step 2: Download the new CentOS-Base.repo to / etc/yum.repos.d/

CentOS 6
wget -O /etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/rep…

Step 3: Run Yum makecache to generate caches

yum makecache

Virtual Machine Centos 6.8 Installs MYSQL5.7, Local Navicat Connection

Install MYSQL

1. Download and install rpm

wget https://dev.mysql.com/get/mys…
rpm -Uvh mysql57-community-release-el6-9.noarch.rpm

2. Install MySQL

yum install mysql-community-server

3. Open MySQL service

service mysqld start

4. Modify login password

Grep’temporary password’/var/log/mysqld.log (get the default password)

shell> mysql -uroot -p
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'yourpassword';
mysql> FLUSH PRIVILEGES;
mysql> exit;

5. Development Port

Vi/etc/sysconfig/iptables (Add 3306)
service iptables restart

6. Developing Remote Connections

use mysql;
update user set host = ‘%’ where user = ‘root’;
FLUSH PRIVILEGES;
exit;

7. Local Navicat Connection

Virtual Machine Centos 6.8 Installs MYSQL5.7, Local Navicat Connection


If this article is helpful to you, please pay attention to my technical public number. Thank you.

Virtual Machine Centos 6.8 Installs MYSQL5.7, Local Navicat Connection

Recommended Today

Api: tiktok: user video list

Tiktok tiktok, tiktok, tiktok, Api, Api, jitter, voice, bullet screen comments, jitter, jitter, and jitter. Tiktok tiktok tiktok data, jitter data acquisition, live broadcast of shaking sound Titodata: professional short video data acquisition and processing platform. For more information, please contact:TiToData Massive data collection Collect 500 million pieces of data for customers every day Tiktok […]