Home >Database >Mysql Tutorial >给Mysql添加远程访问权限的方法_MySQL
给Mysql添加远程访问权限的方法_MySQL
- WBOYOriginal
- 2016-06-01 13:04:48995browse
user:myuser pwd:mypassword 从任何主机连接到mysql服务器
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
user:myuser pwd:mypassword 从192.168.1.3连接到mysql服务器
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.1.3' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
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
Previous article：Mysql中的Datetime和Timestamp比较_MySQLNext article：mysql中You can’t specify target table for update in FROM clau_MySQL