Breaking News: Grepper is joining You.com. Read the official announcement!

sql error 1130 host not privileged

Sam Burford answered on March 12, 2023 Popularity 2/10 Helpfulness 1/10

answer sql error 1130 host not privileged

sql error 1130 host not privileged

Comment

# Find solution here: https://stackoverflow.com/questions/19101243/error-1130-hy000-host-is-not-allowed-to-connect-to-this-mysql-server

SELECT host FROM mysql.user WHERE User = 'root';

CREATE USER 'root'@'ip_address' IDENTIFIED BY 'some_pass';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'ip_address';

CREATE USER 'root'@'%' IDENTIFIED BY 'some_pass';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';

FLUSH PRIVILEGES;

Popularity 2/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: host sql

Link to this answer
Share Copy Link