[ale] Mysql connection fail

[Lightner, Jeffrey]

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.ale.org/pipermail/ale/attachments/20170912/dc7d0b7c/attachment.html>