Posts

Showing posts with the label remote connection

Can't connect to Remote MySQL Server (10061) to Ubuntu

STEP 1: To allow remote access to MySQL, you have to comment out bind-address (you did) and skip-networking in the configuration file. Next, you have to make sure the user is allowed remote access. Check your user with this: SELECT User , Host FROM mysql . user ; If your user here has '127.0.0.1' or 'localhost' listed as host, you don't have remote access. Change this with: UPDATE mysql . user SET HOST = '%' WHERE User = '__here_your_username' ; Flush privileges: FLUSH PRIVILEGES ; The '%' is a wildcard for 'all hosts'. STEP 2: To Allow remote access to MySQL installed on a Ubuntu, you will have to access the file at this location: / etc / mysql / mysql . conf . d / mysqld . cnf There, you comment out the following line: bind-address = 127.0.0.1 basically to change: bind-address = 127.0.0.1 to: #bind-address = 127.0.0.1 Now you either restart the computer or just the mySQL service using the follwing...