How does Mysql authorize any ip remote connection access to a specified account

This article mainly explains "how Mysql authorizes any ip remote connection access to a specified account". The explanation in the article is simple, clear and easy to learn and understand. Please follow the editor's train of thought to study and learn "how Mysql authorizes any ip remote connection access to a specified account".

Enter mysql

Mysql-uroot-p

License root to any IP, to any database.

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

Refresh authorization (effective immediately)

Flush privileges

This article is written in OpenWrite

Thank you for your reading, the above is the content of "how Mysql authorizes any ip remote connection access to a specified account". After the study of this article, I believe you have a deeper understanding of how Mysql authorizes any ip remote connection access to a specified account, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!