Download and install MySQL and use Navicat for remote access

Time:2019-11-10

My website: www.mengyingjie.com

Download and install MySQL

(1) open MySQL port number on the server: 3306

Download and install MySQL and use Navicat for remote access

(2) connect to the server with xshell (download, install and use xshell on Windows)

(3) download and install MySQL

Step 1: install the WGet command to download files from the Internet

yum -y install wget

Step 2: download the repo source of MySQL

wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm

Step 3: install mysql-community-release-el7-5.noarch.rpm package

rpm -ivh mysql-community-release-el7-5.noarch.rpm

Step 4: View

ls -1 /etc/yum.repos.d/mysql-community*
/etc/yum.repos.d/mysql-community.repo
/etc/yum.repos.d/mysql-community-source.repo

Two Yum repo sources of MySQL will be obtained:/etc/yum.repos.d/mysql-community.repo,/etc/yum.repos.d/mysql-community-source.repo

Step 5: install MySQL

yum install mysql-server

(4) start MySQL service

service mysql start

(5) connect mysql

Download and install MySQL and use Navicat for remote access

(6) create user

GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;

Username: is the user name
%: indicates that all Internet IPS can be connected
Password: it’s your own password
–Refresh permission table

flush privileges;

(7) remember to open the firewall of the server

Start firewall

systemctl start firewalld.service

(8) connect with Navicat on local computer

The first method
Download and install MySQL and use Navicat for remote access

Download and install MySQL and use Navicat for remote access

The second method
Download and install MySQL and use Navicat for remote access

I have encountered such problems, but I still haven’t solved them after reading the article,
Comment or add QQ: 781378815

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 […]