Mysql New user remote login _ MySQL

Mysql creates a user to remotely log on to bitsCN.com

Mysql New user remote login

By default, users created in MYSQL cannot log on remotely.

You can log on to mysql using the root account and run the following command.

Grant all privileges on *. * TO 'username '@' % 'identified by 'login password' with grant option;

Example:

SQL code

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

% Indicates that the root user is allowed to access mysql through any IP address, but it may be a problem to access mysql locally through localhost or 127.0.0.1. You can continue to add local access permissions.

SQL code

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

BitsCN.com