Geek Answers Handbook

Connecting to a MySQL database on a local network

I really thought I could do this until I tried. I installed the MySQL server on one PC in the local network IP address (192.168.1.4), and now I'm trying to access it from another computer on the same network (192.168.1.5), but I can not:

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, the DOMICO-PC is the computer from which I am trying to connect. Why is it not connecting to this host, but trying to connect to the local machine?

+4
source share
4 answers

You need to provide permissions to connect with remotehost

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

+5

. t , . .

USER @DOMAIN

: , mysql domain: , .

mysql -u root, , "domico" .

0

. , ​​, :

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

: 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

0
source

creata is a new mysql server user and grant him privileges that you can do on command and using any server, for example, using Workbench

0
source

More articles:


All Articles