MySQL Forums
Forum List  »  Newbie

Accessing the Database from Other Machines on the LAN
Posted by: Christopher Garwood
Date: August 07, 2017 09:00PM

Hello All,
Being totally new to all this, I hope you will be patient with my ignorance and not ignore my request for help.

I have 2 locations that use a PoS with MySQL as the backend. In both cases they are moving from a single machine to a networked environment. One location is using MySQL 5.5 and the other is 5.7

From what I have read, I need to do the following from the command line -
CREATE USER root@% IDENTIFIED BY 1234abcd (same password as the current root)
GRANT ALL PRIVILEGES ON *.* TO root@% IDENTIFIED BY 1234abcd
bind-address = * (or 0.0.0.0 which allows all the IP addresses on the network)
flush privileges

Is this correct?

Options: ReplyQuote




Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.