Cannot connect to MySQL on another PC

Asked 2 years ago, Updated 2 years ago, 40 views

I want to access MySQL on my server PC at home from another PC at home, but I can't.
MySQL version is 8.0.

From another PC in the same IP address as the server PC

 mysql-u admin-p
ERROR 1045 (28000): Access denied for user 'admin' @ 'localhost' (using password: YES)

I can't connect as

 mysql-h 'IP address'-u admin-p 
ERROR 2003 (HY000): Can't connect to MySQL server on 'IP address' (10061)

and the IP address of your home cannot be connected.

The following requirements are met:

  • The bind-address is not configured.
  • The firewall is open 3306.
  • MySQL port is set to 3306.
  • admin is configured to be accessible from all IP addresses.

What should I do?

mysql

2022-09-30 18:29

1 Answers

The mysql account is managed, including the hostname.
Therefore, the account name is account name @ connection hostname
You must access it on the .

https://www.dbonline.jp/mysql/connect/index3.html


because the source hostname information must be correct to access it. Why don't you try the following steps?

http://ext.omo3.com/linux/mysql_host.html


2022-09-30 18:29

If you have any answers or tips


© 2024 OneMinuteCode. All rights reserved.