List:General Discussion« Previous MessageNext Message »
From:Manuel Arostegui Date:May 5 2014 9:13am
Subject:Re: mysql Access denied error
View as plain text  
2014-05-05 10:57 GMT+02:00 Reindl Harald <h.reindl@stripped>:

>
>
> Am 05.05.2014 10:19, schrieb Manuel Arostegui:
> > 2014-05-05 10:00 GMT+02:00 Reindl Harald <h.reindl@stripped<mailto:
> h.reindl@stripped>>:
> >
> >     Am 05.05.2014 08:34, schrieb Manuel Arostegui:
> >     > "%" doesn't match localhost so if you don't specify it you will be
> >     > attempting to connect via Unix Socket.
> >     > If you don't want to specify -hlocalhost all the time, just do the
> grant
> >     > with "@localhost" instead of "@%"
> >
> >     nonsense
> >
> >     % matches *any host*
> >
> > Do the test yourself
>
> i don't need to test such basics since i am working
> as mysql administrator the last 11 years and curently
> responsible for some hundret databases heavily using
> host specific permissions
>

Good for you.
I might be working somewhere bigger than that.

Here is what I am talking about:


mysql>  grant all on hadooptest.* to 'hadoopuser'@'%' identified by
'123456'; flush privileges;
Query OK, 0 rows affected (0.01 sec)

Query OK, 0 rows affected (0.00 sec)

mysql>


# mysql -uhadoopuser -p123456
ERROR 1045 (28000): Access denied for user 'hadoopuser'@'localhost' (using
password: YES)

# mysql -uhadoopuser -p123456 -hlocalhost
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 392245
<snip>


---


mysql> drop user 'hadoopuser'@'%'; flush privileges;
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

mysql>  grant all on hadooptest.* to 'hadoopuser'@'localhost' identified by
'123456'; flush privileges;
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

# mysql -uhadoopuser -p123456
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 392191
<snip>


I have been reading your impoliteness in this list for years. You are well
known in this (and other) lists for being like that. So I am not going to
start a fight over the list and this will be my last message in this thread.
Hopefully I have helped the original poster with my point.

Good luck with your hundreds of databases.

Manuel.

Thread
mysql Access denied errorEdwardKing5 May 2014
  • Re: mysql Access denied errorManuel Arostegui5 May 2014
    • Re: mysql Access denied errorReindl Harald5 May 2014
      • Re: mysql Access denied errorManuel Arostegui5 May 2014
        • Re: mysql Access denied errorReindl Harald5 May 2014
          • Re: mysql Access denied errorJigal van Hemert5 May 2014
            • Re: mysql Access denied errorReindl Harald5 May 2014
          • Re: mysql Access denied errorManuel Arostegui5 May 2014
  • Re: mysql Access denied errorPeter Brawley5 May 2014
  • Re: mysql Access denied errorDivesh Kamra9 May 2014
Re: mysql Access denied errorJohan De Meersman5 May 2014
  • Re: mysql Access denied errorReindl Harald5 May 2014