Need someone to help me with MySQL Remote Connections

[Elliatt]

Hello,

I need someone to help me fix my MySQL to allow remote connections.

I am not offering much pay but I hope someone can still do this.

Thanks

 

[Ricky89]

Send me a PM!

 

[Tripps]

Hello,

I need someone to help me fix my MySQL to allow remote connections.

I am not offering much pay but I hope someone can still do this.

Thanks

Shoot me a pm and I can do this for free.

 

[Zigenzag]

If this hasn't been done and you have access to the server with SSH then you can connect to the MySQL console through the below command:

mysql --host=localhost --user=mysqlrootuser --password=mysqlrootpass databasename

Then to give permissions for external connections through MySQL when your in the MySQL console run this command:

GRANT ALL PRIVILEGES ON *.* TO 'mysqluser'@'%' IDENTIFIED BY 'mysqlpassword' WITH GRANT OPTION;
FLUSH PRIVILEGES;

(If you were wanting to lock down the permissions on the MySQL so they dont have full control let me know).

Then exit out of the console. I believe you can just type exit?

Then if you go to the file /etc/my.cnf you need to edit a line (if this hasn't already been done).

If you have a line that reads...

• bind-address = 127.0.0.1

You need to place a hash infront of it like below:

• #bind-address = 127.0.0.1

Then restart your MySQL server and it should all work!

If it still doesn't it will probably be a firewall issue so check that port 3306 is open (Psst the packets are TCP)

If anyone sees any issues feel free to correct this. Im just trying to write this off the top of me head