The directadmin `root` mysql password is called da_admin and you may find its password at
# ls -l /usr/local/directadmin/conf/mysql.conf -r-------- 1 diradmin diradmin 30 Nov 5 2013 /usr/local/directadmin/conf/mysql.conf # cat /usr/local/directadmin/conf/mysql.conf
Log in to the mysql server
# mysql -u da_admin -p Enter password:
Find out current open files limit
mysql> show variables like 'open%'; +------------------+-------+ | Variable_name | Value | +------------------+-------+ | open_files_limit | 1024 | +------------------+-------+ 1 row in set (0.00 sec) mysql> exit; Bye
Set limit to 10240
# echo "open_files_limit = 10240" >> /etc/my.cnf
Restart the mysql daemon
# /etc/init.d/mysqld restart
Check new open_files_limit
# mysql -u da_admin -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 Server version: 5.5.9 MySQL Community Server (GPL) Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show variables like 'open%'; +------------------+-------+ | Variable_name | Value | +------------------+-------+ | open_files_limit | 10240 | +------------------+-------+ 1 row in set (0.00 sec) mysql> exit Bye #
directadmin mysql open_files_limit