List:General Discussion« Previous MessageNext Message »
From:Tim Dunphy Date:July 16 2012 3:21am
Subject:mysql failed login attempts
View as plain text  
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

Thread
mysql failed login attemptsTim Dunphy16 Jul
  • Re: mysql failed login attemptsAkshay Suryavanshi16 Jul