Home >Database >Mysql Tutorial >允许远程用户访问mysql服务sql语句_MySQL
允许远程用户访问mysql服务sql语句_MySQL
- WBOYOriginal
- 2016-06-01 13:05:25882browse
mysql> grant all privileges on cakephp.* to cakephp@192.168.14.1 identified by 'lpfukia';
Query OK, 0 rows affected (0.01 sec)
mysql>
mysql>
mysql>
mysql> flush privileges;
$1 >> 第一条命令： 授权192.168.14.1 主机的cakephp用户访问cakephp数据库
$2 >> 第二条命令： 刷新授权表
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使用SQLyog导入csv数据不成功的解决方法_MySQLNext article：MySQL 自定义函数CREATE FUNCTION示例_MySQL