Mysql remote client cannot be connected

Welcome to the Linux community forum and interact with 2 million technical staff. By default, the installed mysql cannot be accessed remotely, mainly due to the following two reasons: 1. the mysqld service does not monitor IP addresses that can be remotely accessed. Solution: Modify the mysqld startup parameters (or my. cnf), comment out the bind-address1 of the [mysqld] Section

Welcome to the Linux community forum and interact with 2 million technical staff> access to the default installed mysql cannot be remotely accessed, mainly due to the following two reasons: 1. the mysqld service does not monitor IP addresses that can be remotely accessed. Solution: Modify the mysqld startup parameters (or my. cnf), comment out bind-address = 1 in the [mysqld] Section

Welcome to the Linux community forum and interact with 2 million technicians>

By default, the installed mysql cannot be accessed remotely for the following two reasons:

1. The mysqld service does not monitor IP addresses that can be remotely accessed. solution:

Modify the start parameter (or my. cnf) of mysqld, comment out bind-address = 127.0.0.1 in [mysqld], or modify it to an accessible IP address. Services mysql restart;

2. The account used for client connection has no permissions. View mysql. the user table shows all accounts and the HOST configurations available for access, and checks whether the account used has the access permission on the current client (IP, if not, use the following statement:

SQL code

Grant all privileges on *. * TO 'root' @ '%' identified by '000000' with grant option;