top of page

MySQL Allow Remote Connection

The following allows for remote connection to mySQL view TCP/IP considering the firewall port 3306 is currently open and active.

mySQL> CREATE USER 'user'@'%' IDENTIFIED BY 'password';
mySQL> GRANT ALL PRIVILEGES ON *.* TO 'user'@'%' WITH GRANT OPTION;
mySQL> FLUSH PRIVILEGES;

sudo service mysqld restart

References:

https://stackoverflow.com/questions/1559955/host-xxx-xx-xxx-xxx-is-not-allowed-to-connect-to-this-mysql-server

 
 
 

Recent Posts

See All
Harbor Install & Setup

1. Go to the Harbor releases page & Download either the online or offline installer for the version you want to install. 2. Use tar to...

 
 
 

Comments


Contact Me

Tel: 678-642-8051

cspeed@jcsassoc.com

  • Google+ Long Shadow
  • LinkedIn Long Shadow
  • Facebook Social Icon
  • Twitter Long Shadow

© 2005 by Christopher Speed

Your details were sent successfully!

bottom of page