[ale] Mysql connection fail

[leamhall at gmail.com (Leam Hall)]

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 might impact things.

Can you cli as wordpress from the wordpress host?