MySQL 1130 exception, unable to log in remotely solution

question:
1. Enable remote login permission:
2. Refresh MySQL permissions:
3. Test:

question:

mysql: 1130 is not allowed to connect to this MariaDB server (no remote login permission, note: MariaDB here is an extended version of MySQL)

insert image description here

1. Enable remote login permission:

Copy the localhost user data and rename localhost to % (that is, all links can log in to the server). You can also change it to the corresponding IP address of the server. The steps are as shown in the figure:

insert image description here

2. Refresh MySQL permissions:

The specific sql is as follows:

mysql> use mysql;
mysql> flush privileges;

insert image description here

3. Test:

insert image description here

This is the end of this article about the detailed solution to MySQL 1130 exception and unable to log in remotely. For more related MySQL 1130 exception and unable to log in remotely solution, please search 123WORDPRESS.COM's previous articles or continue to browse the following related articles. I hope everyone will support 123WORDPRESS.COM in the future!

You may also be interested in:

[Project layout configuration] Nosql and Python Web-Flask framework combination
Solve the problem of garbled data in MySQL database migration
SQL Writing - Row Comparison
Solution to MySQL connection exception and error 10061
Solve the problem that the SpringBoot application.yaml file configuration schema cannot execute SQL
Graphic tutorial on installing MySQL database and configuring environment variables on Mac
SQL IDENTITY_INSERT case study
Hotel Management System Designed and Implemented Based on JavaSwing

<<: Analysis of product status in interactive design that cannot be ignored in design

>>: Detailed tutorial on Docker pulling Oracle 11g image configuration

MySQL briefly understands how "order by" works

MySQL 1130 exception, unable to log in remotely solution

Table of contents

question:

1. Enable remote login permission:

2. Refresh MySQL permissions:

3. Test:

MySQL briefly understands how "order by" works

Detailed explanation of MySQL transactions and MySQL logs

Solve the problem of Linux FTP anonymous upload and download starting automatically

docker logs - view the implementation of docker container logs

React hooks introductory tutorial

CSS realizes the realization of background image screen adaptation

Two simple ways to remove text watermarks from web pages

Detailed explanation of Javascript Echarts air quality map effect

Mysql updates certain fields of another table based on data from one table (sql statement)

Mybatis statistics of the execution time of each SQL statement

Recommend

Detailed process of installing nginx1.9.1 on centos8

Implementation of running SQL Server using Docker

Faint: "Use web2.0 to create standard-compliant pages"

7 skills that great graphic designers need to master

How to change the root password in MySQL 5.7

Detailed process of building nfs server using Docker's NFS-Ganesha image

Common errors and solutions for connecting Navicat to virtual machine MySQL

JavaScript to achieve custom scroll bar effect

Several ways to implement inheritance in JavaScript

Share some tips on using JavaScript operators

Detailed explanation of how to modify the style of el-select: popper-append-to-body and popper-class

Tutorial on installing jdk1.8 on ubuntu14.04

How to use ES6 class inheritance to achieve a gorgeous ball effect

How to use dynamic parameters and calculated properties in Vue

CSS to achieve horizontal lines on both sides of the middle text