Back to all posts
Grant MySQL Access to a Specific IP
Tools
# Check
SELECT host, user FROM mysql.user WHERE host = '192.168.1.5';
# Grant login
CREATE USER 'username'@'192.168.1.5' IDENTIFIED BY 'password';
# Grant database privileges
GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'192.168.1.5';
# Flush
FLUSH PRIVILEGES;