Connecting to a remote MySQL server from a station in a local area netwok
Connecting to a remote MySQL server from a station in a local area netwok
(OP)
Hello everyone,
MySQL is installed as part of XAMPP on two stations in my home network (So, in fact I have 2 MySQL servers).
All databases, tables and data were created on server1 but now I want o add data to the database on
server1 from server2.
I try to connect to server1 from server2 by inserting the following command from windows7 textual interface
(cmd) of server2:
c:\xampp\mysql\bin mysql -h 10.0.0.26 -u me -pmepass;
and I get the following error message:
ERROR 1045 (28000): Access denied for user 'me'@'server2'.
Can anyone help me with connecting to the remote MySQL data server?
Thanks.
MySQL is installed as part of XAMPP on two stations in my home network (So, in fact I have 2 MySQL servers).
All databases, tables and data were created on server1 but now I want o add data to the database on
server1 from server2.
I try to connect to server1 from server2 by inserting the following command from windows7 textual interface
(cmd) of server2:
c:\xampp\mysql\bin mysql -h 10.0.0.26 -u me -pmepass;
and I get the following error message:
ERROR 1045 (28000): Access denied for user 'me'@'server2'.
Can anyone help me with connecting to the remote MySQL data server?
Thanks.
RE: Connecting to a remote MySQL server from a station in a local area netwok
Chris.
Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Webmaster Forum
RE: Connecting to a remote MySQL server from a station in a local area netwok
Should I give myself access from the remote? How?
RE: Connecting to a remote MySQL server from a station in a local area netwok
Chris.
Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Webmaster Forum
RE: Connecting to a remote MySQL server from a station in a local area netwok
If you have not done so, you need to add server2 as a valid location from which your user can connect to server1 in MYSQL's user and permission configuration.
I you haven't done so either, I suggest downloading MYSQL Workbench. It helps a lot in administering MYSQL databases visually. And it will make adding the correct permissions easier.
https://www.mysql.com/products/workbench/
If you want to do this through the command line:
Connected to mysql on server1, and issue a GRANT statement.
GRANT [privileges_to_grant] ON [databasename].* TO 'someuser'@'somehost';
Where [somehost] is server2's name or IP address.
http://dev.mysql.com/doc/refman/5.7/en/grant.html
----------------------------------
Phil AKA Vacunita
----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.
Web & Tech
RE: Connecting to a remote MySQL server from a station in a local area netwok
I'll try to do as you advised me to do !