[ale] Mysql connection fail

[Chuck Payne]

Jim,

Ok, I have to ask since you are using CentOS/Fedora, is SELinux running, is
there a run to protect mysql.

You are trying to log on like this...

mysql -u user -ppassword

I had an issue where I update MariaDB and I didn't run update database, so
when I logged into my db, I ccouldn't see mysql database and other
databases, but info and test. I had to stop mysql,  and start in safe mode,
then run mysql_update. Once I did that and started mysql normal, I was able
to see the databases.

So, try stopping then start in safe mode to see if you can log in that way.


On Tue, Sep 12, 2017 at 9:16 AM, Beddingfield, Allen <allen at ua.edu> wrote:

> What does your mysql.user table look like?  I've found that "grant all
> privileges on dbname.* to 'user'@'localhost' identified by 'password'" is
> not equal to "grant all privileges on dbname.* to 'user'@'127.0.0.1'
> identified by 'password".
>
> If all else fails, create a new 'user'@'%'
>
> --
> Allen Beddingfield
> Systems Engineer
> Office of Information Technology
> The University of Alabama
> Office 205-348-2251
> allen at ua.edu
>
> On 9/12/17, 8:08 AM, "ale-bounces at ale.org on behalf of Jim Kinney" <
> ale-bounces at ale.org on behalf of jim.kinney at gmail.com> wrote:
>
>
>
>
>     It's all on one host. Can't cli as wordpress access from the only host
> mysql has ever known.
>
>     One other account can get in but it seems to be just a dumb user
> account with ability to adjust permission.
>
>     Google was not helpful. Related fails discussed /etc/hosts entries
> (methodically test all combos of localhost,
>     127.0.0.1 <http://127.0.0.1>, the host IP, host fqdm, short name) but
> that seems to have no impact.
>
>     On September 12, 2017 8:50:57 AM EDT, Leam Hall <leamhall at gmail.com>
> wrote:
>
>     On 09/12/2017 08:32 AM, Jim Kinney wrote:
>
>      This was bugging me (until internet went out late yesterday).
>
>      I can't connect to a mysql database from cli. The wordpress user can
>      from wordpress. But even as the wordpress user with proper
> credentials,
>      no cli access. Errors out with a user @localhost credential failed/not
>      allowed.
>
>      That kind of horks a mysqldump.
>
>      Tried ip, hostname, access by root (that also fails - WTF!) all with
>      same error. Yet wordpress just chugs along.
>
>      Ideas?
>
>
>
>
>     I'm not an expert, but the database permissions might specify a remote
>     host but not a local one. Also, selinux or iptables restricting
>     127.0.0.1 <http://127.0.0.1> might impact things.
>
>     Can you cli as wordpress from the wordpress host?
>     ________________________________________
>
>     Ale mailing list
>     Ale at ale.org
>     http://mail.ale.org/mailman/listinfo/ale
>     See JOBS, ANNOUNCE and SCHOOLS lists at
>     http://mail.ale.org/mailman/listinfo
>
>
>
>
>     --
>     Sent from my Android device with K-9 Mail. All tyopes are thumb
> related and reflect authenticity.
>
>
>
>
>
> _______________________________________________
> Ale mailing list
> Ale at ale.org
> http://mail.ale.org/mailman/listinfo/ale
> See JOBS, ANNOUNCE and SCHOOLS lists at
> http://mail.ale.org/mailman/listinfo
>



-- 
Terror PUP a.k.a
Chuck "PUP" Payne
-----------------------------------------
Discover it! Enjoy it! Share it! openSUSE Linux.
-----------------------------------------
openSUSE -- Terrorpup
openSUSE Ambassador/openSUSE Member
skype,twiiter,identica,friendfeed -- terrorpup
freenode(irc) --terrorpup/lupinstein
Register Linux Userid: 155363

Have you tried SUSE Studio? Need to create a Live CD,  an app you want to
package and distribute , or create your own linux distro. Give SUSE Studio
a try.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.ale.org/pipermail/ale/attachments/20170912/9cd221ff/attachment.html>