Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Mysql server running on Mac OS X the my.cnf file had max_connections = 10000000

client got the error 'max connections reached' restarted server, now it won't start the mysql services

bellow is an error when running mysqld_safe

i set the max_connections = 100, but the server will still not start the SQL services

EWELS:bin administrator$ sudo mysqld_safe
110419 14:04:15 [ERROR] /usr/libexec/mysqld: unknown option '--512'
Starting mysqld daemon with databases from /var/mysql
STOPPING server from pid file /var/mysql/JEWELS.LOCAL.pid
110419 14:04:15  mysqld ended

any help is appreciated thanks

share|improve this question

1 Answer 1

up vote 0 down vote accepted

problem fixed - jumped the gun with question again

max_connections was 1000000

whenever i changed this it didnt work

int he end i renamed the my.cnf file to my.cnf.back

ran sudo mysqld_safe and it created a new config file and restored all defaults - services started as expected.

thanks anyway

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.