mysql远程连接:Too many connections,mysql unauthenticated user
10月 29th, 2008 Posted in 空间制作
几台机器做轮循的时候,独立了一台机器做数据库,当其他机器远程连接的db数据库的时候,总是出现Too many connections,重启几次,进入了msyql进程,发现很多unauthenticated user,百度了下解释说有一个线程在处理客户端的连接,但是该客户端还没通过用户验证,导致原因可能是Mysql在做DNS反向解析。
解决方法,在mysqld_safe 后面加 –skip-name-resolve,启动,ok
10月 30th, 2008 at 3:31 am
Natural Herbalz Online Natural Herbal Health Care Products Store providing all natural herbal products reviews on men’s and women’s health, skin and beauty products, sexual and general health, weight loss and diet for better health and better life style. http://www.naturalherbalz.com