[ale] Mysql connection fail

[Jim Kinney]

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> 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>
>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.

-- 
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/72ccc20e/attachment.html>