MySQL LAN Access

[BrownZeus]

Hey guys,

 

Just wanted to know if anyone could point me to a how-to on making my MySQL database connectable through my local network so that other devices on my network can connect to the database.

 

Thanks in advance

 

[vorticalbox]

well you can either install a MySQL server on a  machine on your network or what I would do is just run mysql from docker

 

docker run --name mysqlLocal -e MYSQL_ROOT_PASSWORD=mpassword -d mysql:latest

 

[Cruorzy]

Docker might be way to advanced for you.

 

Just install the mysql server on the machine in the same network and you should be good.

[vorticalbox]

11 hours ago, Cruorzy said:

Docker might be way to advanced for you.

 

Just install the mysql server on the machine in the same network and you should be good.

It's a single line in a terminal and docker downloads and runs it for you.

 

Plus it's not s bad thing to learn.

[Fleetscut]

you might also need to make some firewall rules to allow machines to connect on the ports that the server uses.

[Cruorzy]

On 28-5-2018 at 7:44 AM, vorticalbox said:

It's a single line in a terminal and docker downloads and runs it for you.

 

Plus it's not s bad thing to learn.

Yes and yes but understanding docker requires basic knowledge about linux and it's distro's specially how to use docker and when not to use.

 

He asks for a simple thing which he should already know before even touching docker.

 

The whole thing is that he has to learn about it, remember we are talking about databases, not a subject where you copy/paste a line and see it working.

something that has to be handled with care.

[leonfagan71]

 

OP- if you need a hand PM me.

Is the machine running the database Linux or Windows is the first question.

 

Once we've established that, has MySQL server been installed already?

 

Regards,

Leon.

[Guest]

The simpler way might be starting without docker. With databases you need to be very careful with volumes and and directories so messing around with docker containers does not cause loosing data.

 

You mainly need to make sure mysql connects to the correct (or simply all) network interface(s) and the user you create in the database is allowed to connect from anywhere. There are Stackoverflow answers to help with that: https://stackoverflow.com/questions/12358197/mysql-networking-issue - make sure the bind-address is set and the users are allowed to connect (use '%' (any remote host) instead of 'localhost' to allow remote connections when creating users in mysql)

 

If you want to look in the manual: 

• Bind-Address: https://dev.mysql.com/doc/refman/5.7/en/server-options.html#option_mysqld_bind-address
• Create User: https://dev.mysql.com/doc/refman/5.7/en/create-user.html
  • don't forget to reload users after creating them (FLUSH PRIVILEGES;)

 

[virtualking]

You should have an admin access to access network mysql too and check whether firewall is not blocking the mysql service