Connect to MySQL Database on Local Network

Question

I actually thought I could do this until I tried. I installed MySQL server on one PC in the Local network IP Address (192.168.1.4) and now I am trying to access it from another PC in the same network (192.168.1.5) but I am unable:

C:\Users\DOMICO>mysql -u domico -h 192.168.1.4 -p
Enter password: **********
ERROR 1045 (28000): Access denied for user 'domico'@'DOMICO-PC' (using password:
 YES)

Surprisingly DOMICO-PC is the PC I am trying to connect from. Why is it not connecting to the given host but trying to connect to Local machine?

Possible duplicate of connecting to mysql server on another PC in LAN — ImtiazeA
– ImtiazeA, Commented Jan 20, 2019 at 5:09

Vinoth Ramamoorthy · Accepted Answer · 2015-05-12 14:32:48Z

9

You need to give permissions to connect from remotehost

mysql>GRANT ALL PRIVILEGES ON database.* TO 'username'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;

answered May 12, 2015 at 14:32

Vinoth Ramamoorthy

1871 silver badge9 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

A. Khaled Over a year ago

I am getting that error, ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.1.16' (111)

Tom · Accepted Answer · 2015-05-12 12:03:33Z

1

You need to have proper permissions to connect. In the computer that has the DB installed, give your user the proper permissions:

mysql>GRANT ALL PRIVILEGES ON *.* TO 'domico'@'DOMICO-PC';
mysql>FLUSH PRIVILEGES;

You can read more here: https://www.digitalocean.com/community/tutorials/how-to-create-a-new-user-and-grant-permissions-in-mysql

And here: https://dev.mysql.com/doc/refman/5.1/en/privileges-provided.html

answered May 12, 2015 at 12:03

Tom

1,1438 silver badges17 bronze badges

Comments

Ashley Jordan · Accepted Answer · 2015-05-12 11:59:19Z

0

This is connecting to the intended host as you require it to. t is just stating who is connecting. and where from.

USER@DOMAIN

user : your user running the mysql command domain : name of the system you are connecting from.

Log into mysql via the server using -u root, ensure the user 'domico' is created and has sufficient access.

answered May 12, 2015 at 11:59

Ashley Jordan

293 bronze badges

3 Comments

Stanley Mungai Over a year ago

When creating the user I granted all on domico.* to the user 'domico' what other access do they require?

Ashley Jordan Over a year ago

show me the grants you have set up for 'domico' in the DB. are you positive you are entering in the correct password as well?

Tom Over a year ago

The point is, you probably gave ALL privileges on the @localhost (which means you can only access the database from the local computer). You need to specify the proper host (computer) - @'DOMICO-PC', when giving privileges, as I wrote in the answer above.

Basit · Accepted Answer · 2017-07-05 07:49:01Z

0

creata a new user by mysql server and give it privileges you can do it by command and by using any server e.g by using workbench

answered Jul 5, 2017 at 7:49

Basit

8901 gold badge12 silver badges34 bronze badges

1 Comment

Stanley Mungai Over a year ago

Is this neccessary on a two year old question that already has an accepted answer?

Vitalie Bancu · Accepted Answer · 2018-06-21 10:36:50Z

0

For all users and all host.

mysql -u root -p

GRANT ALL PRIVILEGES
ON *.*
TO '%'@'%'
IDENTIFIED BY 'password'
WITH GRANT OPTION;

FLUSH PRIVILEGES;

QUIT;

answered Jun 21, 2018 at 10:36

Vitalie Bancu

1812 silver badges11 bronze badges

Collectives™ on Stack Overflow

Connect to MySQL Database on Local Network

5 Answers 5

1 Comment

Comments

3 Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

Comments

3 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related