<html><head></head><body>It's all on one host. Can't cli as wordpress access from the only host mysql has ever known.<br>
<br>
One other account can get in but it seems to be just a dumb user account with ability to adjust permission.<br>
<br>
Google was not helpful. Related fails discussed /etc/hosts entries (methodically test all combos of localhost, <a href="http://127.0.0.1">127.0.0.1</a>, the host IP, host fqdm, short name) but that seems to have no impact.<br><br><div class="gmail_quote">On September 12, 2017 8:50:57 AM EDT, Leam Hall <leamhall@gmail.com> wrote:<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<pre class="k9mail">On 09/12/2017 08:32 AM, Jim Kinney wrote:<br /><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #729fcf; padding-left: 1ex;"> This was bugging me (until internet went out late yesterday).<br /> <br /> I can't connect to a mysql database from cli. The wordpress user can <br /> from wordpress. But even as the wordpress user with proper credentials, <br /> no cli access. Errors out with a user @localhost credential failed/not <br /> allowed.<br /> <br /> That kind of horks a mysqldump.<br /> <br /> Tried ip, hostname, access by root (that also fails - WTF!) all with <br /> same error. Yet wordpress just chugs along.<br /> <br /> Ideas?<br /></blockquote><br /><br />I'm not an expert, but the database permissions might specify a remote <br />host but not a local one. Also, selinux or iptables restricting <br /><a href="http://127.0.0.1">127.0.0.1</a> might impact things.<br /><br />Can you cli as wordpress from the wordpress host?<br /><hr /><br />Ale mailing list<br />Ale@ale.org<br /><a href="http://mail.ale.org/mailman/listinfo/ale">http://mail.ale.org/mailman/listinfo/ale</a><br />See JOBS, ANNOUNCE and SCHOOLS lists at<br /><a href="http://mail.ale.org/mailman/listinfo">http://mail.ale.org/mailman/listinfo</a><br /></pre></blockquote></div><br>
-- <br>
Sent from my Android device with K-9 Mail. All tyopes are thumb related and reflect authenticity.</body></html>