hello,
currently my php app is failing logins to it's mysql database. My config
file is set like this:
[mysqld_safe]
general-log=1
general-log-file=/var/log/mysqld-general.log
log-output=/var/log/mysqld-general.log
log=/var/log/mysqld.log
log-error=/var/log/mysqld-error.log
pid-file=/var/run/mysqld/mysqld.pid
Yet if I tail the /var/log/mysqld-general.log I cannot see the login
attempts.
This is how my environment variables are set:
mysql> show variables like 'log%';
+---------------------------------+---------------------------+
| Variable_name | Value |
+---------------------------------+---------------------------+
| log | ON |
| log_bin | OFF |
| log_bin_trust_function_creators | OFF |
| log_error | /var/log/mysqld-error.log |
| log_output | FILE |
| log_queries_not_using_indexes | OFF |
| log_slave_updates | OFF |
| log_slow_queries | OFF |
| log_warnings | 1 |
+---------------------------------+---------------------------+
Can someone please tell me what I am doing wrong and how I can see failed
login attempts?
Tim
--
GPG me!!
gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B
