Home > Database > Mysql Tutorial > MySQL开启root远程访问权限的方法_MySQL

MySQL开启root远程访问权限的方法_MySQL

WBOY
Release: 2016-06-01 13:43:10
Original
1268 people have browsed it

bitsCN.com
MySQL开启root远程访问权限 允许任何IP使用 root 账户,口令8个1远程访问 方法1Sql代码  mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '11111111' WITH GRANT OPTION;    方法2 Sql代码  mysql> use mysql;  mysql> update user set host = '%' where user = 'root';     作者 lj6684 bitsCN.com

Related labels:
source:php.cn
Statement of this Website
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template