Accessing the Database from Other Machines on the LAN
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?
Subject
Written By
Posted
Accessing the Database from Other Machines on the LAN
August 07, 2017 09:00PM
Sorry, you can't reply to this topic. It has been closed.
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.