List:General Discussion« Previous MessageNext Message »
From:Claudio Nanni Date:March 16 2012 7:10pm
Subject:Re: Can't connect as non-root user to database
View as plain text  
Hi Clemens,

my pleasure!

I forgot, you had to use also -P3306, so using both -h and -P which deny
the lookup for users at localhost,
forcing TCP-IP. and so IPs.

this is also good when the socket file is not in the standard location, you
will have the same problem logging in locally,
using -h and -P forces TCP-IP

Cheers!

Claudio



2012/3/16 Clemens Eisserer <linuxhippy@stripped>

> Hi Claudio,
>
> > you probably have the anonymous user account taking over:
> ''@'localhost'
> > login as root and:
> > mysql> drop user ''@'localhost';
> Thanks a lot, that solved the problem (and saved my day :) !).
>
>
> > when you specify the host with -h you are actually forcing MySQL to use
> > TCP/IP so it will authenticate you using your ip address (127.0.0.1)
> Actually even with -h127.0.0.1 specified, I got "access denied for
> ...@localhost".
>
> Thanks again, Clemens
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql
>
>


-- 
Claudio

Thread
Can't connect as non-root user to databaseClemens Eisserer16 Mar
  • Re: Can't connect as non-root user to databaseClaudio Nanni16 Mar
Re: Can't connect as non-root user to databaseClemens Eisserer16 Mar
  • Re: Can't connect as non-root user to databaseRik Wasmus16 Mar
    • Re: Can't connect as non-root user to databaseClemens Eisserer16 Mar
      • Re: Can't connect as non-root user to databaseClaudio Nanni16 Mar
        • Re: Can't connect as non-root user to databaseClaudio Nanni16 Mar
        • Re: Can't connect as non-root user to databaseClemens Eisserer16 Mar
          • Re: Can't connect as non-root user to databaseClaudio Nanni16 Mar
      • Re: Can't connect as non-root user to databaseRik Wasmus16 Mar
      • Re: Can't connect as non-root user to databaseshawn green16 Mar
        • how to sync mysql.user table between to two mysql instancesCharles Brown16 Mar
          • Re: how to sync mysql.user table between to two mysql instancesBaron Schwartz16 Mar
            • RE: how to sync mysql.user table between to two mysql instancesDavid Lerer16 Mar
              • RE: how to sync mysql.user table between to two mysql instancesCharles Brown16 Mar
                • RE: how to sync mysql.user table between to two mysql instancesDavid Lerer16 Mar
            • Re: how to sync mysql.user table between to two mysql instancesJohan De Meersman16 Mar
              • RE: how to sync mysql.user table between to two mysql instancesCharles Brown17 Mar
        • Re: Can't connect as non-root user to databaseClemens Eisserer16 Mar
          • Re: Can't connect as non-root user to databaseshawn green16 Mar