[ale] Mysql connection fail

[Jim Kinney]

I'm going in to work :-) Emory U is closed so network should be decent. 

On September 12, 2017 9:51:07 AM EDT, "Lightner, Jeffrey" <JLightner at dsservices.com> wrote:
>Do you have a phone that allows you to tether or serve as a wi-fi
>hotspot?   Not as fast as other solutions but great in a pinch.
>
>
>From: ale-bounces at ale.org [mailto:ale-bounces at ale.org] On Behalf Of Jim
>Kinney
>Sent: Tuesday, September 12, 2017 9:42 AM
>To: Atlanta Linux Enthusiasts; Chuck Payne
>Subject: Re: [ale] Mysql connection fail
>
>I need to go find internet. Can't test anything. Starting to twitch.
>Might pass out soon. Working off phone is poor substitute.
>On September 12, 2017 9:29:18 AM EDT, Chuck Payne
><terrorpup at gmail.com<mailto:terrorpup at gmail.com>> wrote:
>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<mailto: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<tel:205-348-2251>
>allen at ua.edu<mailto:allen at ua.edu>
>
>On 9/12/17, 8:08 AM, "ale-bounces at ale.org<mailto:ale-bounces at ale.org>
>on behalf of Jim Kinney"
><ale-bounces at ale.org<mailto:ale-bounces at ale.org> on behalf of
>jim.kinney at gmail.com<mailto: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<mailto: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<mailto: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<mailto: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.
>
>--
>Sent from my Android device with K-9 Mail. All tyopes are thumb related
>and reflect authenticity.

-- 
Sent from my Android device with K-9 Mail. All tyopes are thumb related and reflect authenticity.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.ale.org/pipermail/ale/attachments/20170912/831bde88/attachment.html>