Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > 远程连接MySQL速度慢的解决办法_MySQL

远程连接MySQL速度慢的解决办法_MySQL

WBOY
Release： 2016-06-01 13:11:32
Original
1119 people have browsed it

在优化MYSQL配置时，加入 skip-name-resolve

window服务器MYSQL配置文件 my.ini   linux MYSQL配置文件my.cnf

skip-name-resolve是禁用dns解析，避免网络DNS解析服务引发访问MYSQL的错误，一般应当启用。
启用后，在mysql的授权表中就不能使用主机名了，只能使用IP。



source：php.cn
Previous article：删除卸载Linux自带的MySQL_MySQL Next article：JDBC-MYSQL源码学习1_MySQL
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
Latest Articles by Author
Latest Issues
function_exists() cannot determine the custom function Function test () {return true;} if (function_exists ('test')) {echo "test is function...
From 2024-04-29 11:01:01
0
3
2158
How to display the mobile version of Google Chrome Hello teacher, how can I change Google Chrome into a mobile version?
From 2024-04-23 00:22:19
0
11
2309
The child window operates the parent window, but the output does not respond. The first two sentences are executable, but the last sentence cannot be implemented.
From 2024-04-19 15:37:47
0
1
1946
There is no output in the parent window document.onclick = function(){ window.opener.document.write('I am the output of the child ...
From 2024-04-18 23:52:34
0
1
1820
Where is the courseware about CSS mind mapping? Courseware
From 2024-04-16 10:10:18
0
0
1874
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template