List:General Discussion« Previous MessageNext Message »
From:Rik Wasmus Date:March 16 2012 10:37am
Subject:Re: Can't connect as non-root user to database
View as plain text  
> Hi Rik,
> 
> > Have you tried the _full_ user-identification (which is with host)?
> > 
> > GRANT ALL ON somedb.* TO 'someone'@'%';
> 
> Yes I had (and just tried to verify) but it didn't help.

Oops, didn't use reply-to-list instead of reply-to-author, my apologies...

> Could it be Fedora's mysql packages are special somehow?
> Re-installing mysql after deletig its data-directory didn't help
> unfourtunatly. I also don't use fancy configuration, all I did was to copy
> my-medium.cnf to /etc/my.cnf and enabled innodb.

Hm, is the mysql-client library the same as the mysql-server?
And does mysql --host=127.0.0.1 --user=someone -p somedb work (or it's actual 
IP-address, forcing the TCP/IP connect instead of possible sockets) ?
-- 
Rik Wasmus
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