have_innodb DISABLED

Submitted by kdr2000 on Mon, 01/24/2011 - 09:28

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

Submitted by JamieCameron on Tue, 01/25/2011 - 18:06

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

Submitted by firestar on Fri, 03/11/2011 - 04:59

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.

Submitted by JamieCameron on Fri, 03/11/2011 - 12:22

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

Submitted by firestar on Fri, 03/11/2011 - 17:05

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

Submitted by JamieCameron on Sat, 03/12/2011 - 11:25

Yes, that is the my.cnf file..

What change are you trying to make exactly?

Submitted by firestar on Mon, 03/14/2011 - 09:14

Thanks.

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

Thanks.

Submitted by Issues on Mon, 03/28/2011 - 13:20

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