Home  >  Article  >  Database  >  如何设置MySQL远程连接_MySQL

如何设置MySQL远程连接_MySQL

WBOY
WBOYOriginal
2016-06-01 13:51:58978browse

登录到MySQL服务器端,在mysql库下执行grant all on *.* to 'remote'@'172.16.21.39' identified by 'password';即可

如果要设置为任何客户端都可以以root连接的话,可以这么写:
grant all on *.* to 'root'@'%' identifiied by 'root的密码'

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn