1130 MySQL Origin: Data OSI layer 7 · Application Last updated 14 Oct 2026

MySQL ERROR 1130 (HY000): Host 'x' is not allowed to connect to this MySQL server

No MySQL account exists for the host you’re connecting from.

Exact message you may see is not allowed to connect to this MySQL server
Seen on: MySQL

Meaning

Accounts are user@host. A user created as 'app'@'localhost' can’t log in from another machine or container. Remote access needs a matching host ('app'@'%' or a specific IP).

Common causes

  • User only defined for localhost
  • Connecting from a container/another server
  • bind-address limits plus missing remote user

⚡ Quick fix

  1. Create the user for the client host or a subnet
  2. Grant privileges
  3. Check bind-address in my.cnf for remote access

Detailed fix by platform

MySQL

  1. sql
    CREATE USER 'app'@'10.0.0.%' IDENTIFIED BY 'StrongPass!';
    GRANT ALL ON appdb.* TO 'app'@'10.0.0.%';

How to diagnose

  1. Host — Which host is reported?
  2. Accounts — SELECT user, host FROM mysql.user

🔧 Still not fixed?

Many errors look alike. If the steps above didn’t solve it, one of these is probably what you’re facing:

Where this error sits

Origin: Data. Errors that are often confused with or caused by this one (click to open):

1044 — MySQL ERROR 1044 (42000): Access denied for user to database (MySQL)10441045 — MySQL ERROR 1045 (28000): Access denied for user (MySQL)10451142 — MySQL ERROR 1142 (42000): SELECT command denied to user 'x'@'host' for table 'y' (MySQL)11421227 — MySQL ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER privilege(s) for this operation (MySQL)12271698 — MySQL ERROR 1698 (28000): Access denied for user 'root'@'localhost' (MySQL)16982003 — MySQL ERROR 2003 (HY000): Can't connect to MySQL server on 'host:3306' (111) (MySQL)200328P01 — PostgreSQL: FATAL: password authentication failed for user (PostgreSQL)28P0142501 — PostgreSQL: ERROR: permission denied for table / schema public (PostgreSQL)425011130

Explore the map of this error Full error map →

🧠 Still stuck? Analyze your error

Paste the full message, response headers or stack trace — we'll detect the platform and point to the most likely cause.

💬 What worked for others

No tips yet — did something else fix this for you?

Share what worked for you

Tips are checked by an editor before they appear. Links are removed.