Home  >  Article  >  Database  >  Mysql修改密码时报错Can’t Create Thread: Errno 11解决_MySQL

Mysql修改密码时报错Can’t Create Thread: Errno 11解决_MySQL

WBOY
WBOYOriginal
2016-06-01 13:32:151352browse

bitsCN.com

Mysql修改密码时报错Can’t Create Thread: Errno 11解决

 

今天安装完mysql后,想修改一下密码,运行一下

myqladmin -u root password 'password' 
显示报错,

 

报错信息如下,

 

Can't create a new thread (errno 11); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug'

 

还以为是内存不足的问题,free -m 看了一下没问题。Google一下,说是ulimit 限制了max processes,

 

进入到/proc/`pidof mysqld`/limits 看了一下 max processes 设置才10

 

马上ulimit -u 4096 

 

重启mysql service  搞定。

 

bitsCN.com
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