Hi,
I have a basic question, help me please.
I have two opensuse machine. The first is a mysql server and the second is a client machine (make some computations and store results in the first one).
I’m looking for a simple tutorial to setup a LAN connection or a simple dedicated link between these machines. Also note that I need a high speed connection with minimal overhead.
Thank you and kind regards.
MySQL already works over networking. Just specify the domain name or IP address of the server when opening a connection from the client. Also the database must have permissions granted to the client.
For example, in PHP, where you specify:
$db = new mysqli('localhost','dbuser','dbpassword','db');
just specify the hostname or IP address of the server instead of localhost.
For the permissions, you must have executed something like this:
GRANT ALL on db.* to 'dbuser'@client TO 'dbuser' IDENTIFIED BY 'dbpassword';
where client is the client’s hostname or IP address. See the MySQL documentation at dev.mysql.com.
Hi,
Thanks. But before it, I have to setup a dedicate connection between them. How can I setup such connection?
Kind regards.
They are on the same LAN right? So no problems there, no “dedicated connection” needed.
Excuse me, it seems that I can’t describe well. These two machines are separate from each other! I’m going to setup a connection (by LAN) between them.
So set up your connection and then come back when you can describe the topology.