Installed Percona mySQL on CPanel but getting an error

Posted by user1227914 on Server Fault See other posts from Server Fault or by user1227914
Published on 2012-07-08T19:37:38Z Indexed on 2012/07/08 21:17 UTC
Read the original article Hit count: 256

Filed under:
|
|

I installed Percona mySQL on my fresh CPanel server (no databases yet) according to: http://www.ecommy.com/linux/install-...el-environment

Everything seemed to be OK and the server also starts fine, except some commands return this error:

root@server [/var/lib/mysql]# mysql -A -sN information_schema -e
"select * from user_statistics;"
mysql: unknown variable 'innodb_file_per_table=1'

root@server [/var/lib/mysql]# mysql -A
mysql: unknown variable 'innodb_file_per_table=1'

In my /etc/my.cnf I have:

[mysql]
innodb_file_per_table=1
userstat_running=1

I am planning on using InnoDB for the databases.

Anyone know what the problem is? Or even better, how to fix it?

I have installed Percona 5.5 with yum on CentOS.

© Server Fault or respective owner

Related posts about mysql

Related posts about cpanel