CSF stats connection fails with 'password'
Posted: 21 Oct 2013, 20:43
Due to repeated warnings from mysql.err and mysqltuner I had changed 'pass' to 'password' in /root/.my.cnf
Warning: Using unique option prefix pass instead of password is deprecated and will be removed in a future release. Please use the full name instead.
Changing to 'password' will stop those warnings.
If CSF configuration for MYSQL Stats collection is set as follows and .my.cnf has only 'password' then the connection will fail.
So you need to have 'pass' set in .my.cnf for CSF to connect in this way, however if 'pass' is present you get the warnings.
Note: I have mentioned this to cPanel since WHM>SQL Services>Change MYSQL USer Password generates 'pass' not 'password'
Thanks,
jim
Warning: Using unique option prefix pass instead of password is deprecated and will be removed in a future release. Please use the full name instead.
Changing to 'password' will stop those warnings.
If CSF configuration for MYSQL Stats collection is set as follows and .my.cnf has only 'password' then the connection will fail.
Code: Select all
ST_MYSQL = 1
ST_MYSQL_USER = root
ST_MYSQL_PASS =
ST_MYSQL_HOST = localhostNote: I have mentioned this to cPanel since WHM>SQL Services>Change MYSQL USer Password generates 'pass' not 'password'
Thanks,
jim