have_innodb DISABLED

why have_innodb DISABLED and it is not editable field webmin----sql config----sql variable what is the path to my.cnf file

Status: 
Closed (fixed)

Comments

I'm not quite sure what you are asking here .... but you can manually edit any MySQL setting by changing /etc/my.cnf , and then restarting MySQL.

There are so many options in my.cnf that Webmin cannot possibly edit all of them..

Hi.

I am trying to edit something via the MySql module and then manually via putty. However, can't get to my.cnf. This was raised elsewhere, has this been fixed? I think I get to my.cfg.

Do you mean you can't find my.cnf ? It is usually in the /etc directory.

Hi again.

Yes. I tried looking for my.cnf in /etc - however I get to the /etc directory I type in vi my.cnf and I get something like the following:

[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql Default to using old password format for compatibility with mysql 3.x clients (those using the mysqlclient10 compatibility package). old_passwords=1 [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid

Yes, that is the my.cnf file..

What change are you trying to make exactly?

Thanks.

I think I figured this out. I had to change max_connections. Just typed in max_connections = 1000 under the [mysqld] area.

Thanks.

Automatically closed -- issue fixed for 2 weeks with no activity.