List:General Discussion« Previous MessageNext Message »
From:Akshay Suryavanshi Date:July 16 2012 3:26am
Subject:Re: mysql failed login attempts
View as plain text  
Hi Tim,

The information you provided is not enough, do you have the error which you
encountered. The configs you mentioned are not related to connection.
Please provide the full error list may be trace from the application logs,
the way you are trying to connect, plus the configs associated with connect.

Thanks
Akshay Suryavanshi

On Mon, Jul 16, 2012 at 8:51 AM, Tim Dunphy <bluethundr@stripped> wrote:

> 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