Home >Database >Mysql Tutorial >远程连接MySQL速度慢的解决办法_MySQL
远程连接MySQL速度慢的解决办法_MySQL
- WBOYOriginal
- 2016-06-01 13:11:321118browse
在优化MYSQL配置时，加入 skip-name-resolve
window服务器MYSQL配置文件 my.ini linux MYSQL配置文件my.cnf
skip-name-resolve是禁用dns解析，避免网络DNS解析服务引发访问MYSQL的错误，一般应当启用。
启用后，在mysql的授权表中就不能使用主机名了，只能使用IP。
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：删除卸载Linux自带的MySQL_MySQLNext article：JDBC-MYSQL源码学习1_MySQL