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

CentOS 7.x deployment of master and slave DNS servers

MySQL 1130 exception, unable to log in remotely solution

Table of contents

question:

1. Enable remote login permission:

2. Refresh MySQL permissions:

3. Test:

CentOS 7.x deployment of master and slave DNS servers

Native js implementation of slider interval component

How to use docker to deploy Django technology stack project

Why can't I see the access interface for Docker Tomcat?

Vue project implements left swipe delete function (complete code)

Tomcat garbled characters in the console in IDEA and how to set IDEA encoding to UTF-8

How to set remote access permissions in MySQL 8.0

Docker connection mongodb implementation process and code examples

A brief discussion on the manifestation and value selection method of innodb_autoinc_lock_mode

Solve the problem that the IP address obtained using nginx is 127.0.0.1

Recommend

Remove the a label and button and add the background image dotted line/shadow perfect solution

How to implement Hover drop-down menu with CSS

Sample code for implementing horizontal infinite scrolling with pure CSS3

Zen HTML Elements Friends who use zen coding can collect it

18 killer JavaScript one-liners

mysql add, delete, modify and query basic statements

Alibaba Cloud Server Ubuntu Configuration Tutorial

Responsive Web Design Learning (2) — Can videos be made responsive?

Solution to elementui's el-popover style modification not taking effect

Implement QR code scanning function through Vue

Detailed explanation of creating a data table in MySQL and establishing primary and foreign key relationships

Detailed Tutorial on Installing VirtualBox 6.0 on CentOS 8 / RHEL 8

Vue implements the requirement of dragging and dropping dynamically generated components

Vue implements verification code countdown button

Detailed installation and use of docker-compose