Navicat connection MySQL error description analysis

Local connection error description using Navicat

2013-Lost connection to MySQL server at 'reading initial communication packet', system error:0 "Internal error/check (Not system error)"

Solution

cd /etc/mysql/mysql.conf.d/
sudo vim mysqld.cnf

Annotate the red box content

Restart the MySQL service and test the connection again

environment

Virtual Machine Version

MySQL version

Preliminary preparation

Check MySQL running status

sudo systemctl mysql status

If it is not running, start the MySQL service using the sudo systemctl start mysql command

Change root password

After installing MySQL, the root password is empty by default. Change the root user password

mysqladmin -u root password "yourNewPassword";

Enter the MySQL interactive environment

sudo mysql -u root -p
# then enter your password 

View All Libraries

show databases; 

Switch Library

use databaseName; 

New User Related

create

create user 'userName'@'%' identified by 'yourPassword';
# 'userName'@'%' @ The '%' after is the host configuration 

Check

You can see that no permissions are assigned

Assign permissions

grant all privileges on *.* to 'userName'@'%' identified by 'yourPassword';

Assign all permissions on all tables in all libraries to this user

flush privileges; 

View this user again

The above is the detailed solution to the error when Navicat connects to MySQL. For more information about the error when Navicat connects to MySQL, please pay attention to other related articles on 123WORDPRESS.COM!