Discussion:
[ale] Mysql connection fail
Jim Kinney
2017-09-12 12:32:57 UTC
Permalink
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?
--
Sent from my Android device with K-9 Mail. All tyopes are thumb related and reflect authenticity.
Leam Hall
2017-09-12 12:50:57 UTC
Permalink
Post by Jim Kinney
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,
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?
_______________________________________________
Ale mailing list
***@ale.org
http://mail.ale.org/mailman/listinfo/ale
See JOBS, ANNOUNCE and SCHOOLS lists at
http://mail.ale.org/mailman/listinfo
Jim Kinney
2017-09-12 13:08:11 UTC
Permalink
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, the host IP, host fqdm, short name) but that seems to have no impact.
Post by Jim Kinney
Post by Jim Kinney
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,
failed/not
Post by Jim Kinney
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?
_______________________________________________
Ale mailing list
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.
Beddingfield, Allen
2017-09-12 13:16:21 UTC
Permalink
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
***@ua.edu

On 9/12/17, 8:08 AM, "ale-***@ale.org on behalf of Jim Kinney" <ale-***@ale.org on behalf of ***@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 <***@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.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.org
http://mail.ale.org/mailman/listinfo/ale
See JOBS, ANNOUNCE and SCHOOLS lists at
http://mail.ale.org/mailman/listinfo
Chuck Payne
2017-09-12 13:29:18 UTC
Permalink
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.
Post by Beddingfield, Allen
What does your mysql.user table look like? I've found that "grant all
identified by 'password".
--
Allen Beddingfield
Systems Engineer
Office of Information Technology
The University of Alabama
Office 205-348-2251
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.
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,
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
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
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.
Jim Kinney
2017-09-12 13:42:01 UTC
Permalink
I need to go find internet. Can't test anything. Starting to twitch. Might pass out soon. Working off phone is poor substitute.
Post by Chuck Payne
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.
Post by Beddingfield, Allen
What does your mysql.user table look like? I've found that "grant
all
'password'" is
Post by Beddingfield, Allen
identified by 'password".
--
Allen Beddingfield
Systems Engineer
Office of Information Technology
The University of Alabama
Office 205-348-2251
It's all on one host. Can't cli as wordpress access from the only
host
Post by Beddingfield, Allen
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
Post by Beddingfield, Allen
(methodically test all combos of localhost,
127.0.0.1 <http://127.0.0.1>, the host IP, host fqdm, short name)
but
Post by Beddingfield, Allen
that seems to have no impact.
On September 12, 2017 8:50:57 AM EDT, Leam Hall
This was bugging me (until internet went out late yesterday).
I can't connect to a mysql database from cli. The wordpress user
can
Post by Beddingfield, Allen
from wordpress. But even as the wordpress user with proper credentials,
failed/not
Post by Beddingfield, Allen
allowed.
That kind of horks a mysqldump.
Tried ip, hostname, access by root (that also fails - WTF!) all
with
Post by Beddingfield, Allen
same error. Yet wordpress just chugs along.
Ideas?
I'm not an expert, but the database permissions might specify a
remote
Post by Beddingfield, Allen
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
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
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.
Lightner, Jeffrey
2017-09-12 13:51:07 UTC
Permalink
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-***@ale.org [mailto:ale-***@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 <***@gmail.com<mailto:***@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 <***@ua.edu<mailto:***@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>
***@ua.edu<mailto:***@ua.edu>

On 9/12/17, 8:08 AM, "ale-***@ale.org<mailto:ale-***@ale.org> on behalf of Jim Kinney" <ale-***@ale.org<mailto:ale-***@ale.org> on behalf of ***@gmail.com<mailto:***@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 <***@gmail.com<mailto:***@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.org<mailto:***@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.org<mailto:***@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.
Jim Kinney
2017-09-12 13:56:34 UTC
Permalink
I'm going in to work :-) Emory U is closed so network should be decent.
Post by 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.
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
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
What does your mysql.user table look like? I've found that "grant all
identified by 'password".
--
Allen Beddingfield
Systems Engineer
Office of Information Technology
The University of Alabama
Office 205-348-2251<tel:205-348-2251>
on behalf of Jim Kinney"
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
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,
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
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
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.
Lightner, Jeffrey
2017-09-12 14:01:57 UTC
Permalink
I came to office today even though we’re also closed and my home internet is working. It’s only a couple of miles for me and it seems this part of Cobb County was spared the worst of Irma. However, they’re still predicting flooding for Austell.


From: Jim Kinney [mailto:***@gmail.com]
Sent: Tuesday, September 12, 2017 9:57 AM
To: Atlanta Linux Enthusiasts; Lightner, Jeffrey
Subject: Re: [ale] Mysql connection fail

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" <***@dsservices.com<mailto:***@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-***@ale.org<mailto:ale-***@ale.org> [mailto:ale-***@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 <***@gmail.com<mailto:***@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 <***@ua.edu<mailto:***@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>
***@ua.edu<mailto:***@ua.edu>

On 9/12/17, 8:08 AM, "ale-***@ale.org<mailto:ale-***@ale.org> on behalf of Jim Kinney" <ale-***@ale.org<mailto:ale-***@ale.org> on behalf of ***@gmail.com<mailto:***@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 <***@gmail.com<mailto:***@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.org<mailto:***@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.org<mailto:***@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.
Jim Kinney
2017-09-12 14:06:24 UTC
Permalink
Tucker was mostly spared as well.
Post by Lightner, Jeffrey
I came to office today even though we’re also closed and my home
internet is working. It’s only a couple of miles for me and it seems
this part of Cobb County was spared the worst of Irma. However,
they’re still predicting flooding for Austell.
Sent: Tuesday, September 12, 2017 9:57 AM
To: Atlanta Linux Enthusiasts; Lightner, Jeffrey
Subject: Re: [ale] Mysql connection fail
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"
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.
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
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
What does your mysql.user table look like? I've found that "grant all
identified by 'password".
--
Allen Beddingfield
Systems Engineer
Office of Information Technology
The University of Alabama
Office 205-348-2251<tel:205-348-2251>
on behalf of Jim Kinney"
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
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,
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
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
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.
Jim Kinney
2017-09-12 16:24:23 UTC
Permalink
OK. Found the problem. There had been an update quite some time back.
Once I reran mysql_secure_installation again it started working
correctly.
Maybe it's just me but I'm NOT amused that a mandatory security update
to mysql-server unsecured the system silently and did not mention
anything about needing to resecure the database access after the
update. It allowed localhost anonymous access and reinstated the test
database.
Post by Lightner, Jeffrey
I came to office today even though we’re also closed and my home
internet is working. It’s only a couple of miles for me and it
seems this part of Cobb County
was spared the worst of Irma. However, they’re still predicting
flooding for Austell.
Sent: Tuesday, September 12, 2017 9:57 AM
To: Atlanta Linux Enthusiasts; Lightner, Jeffrey
Subject: Re: [ale] Mysql connection fail
I'm going in to work :-) Emory U is closed so network should be decent.
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.
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.
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.
What does your mysql.user table look like? I've found that "grant
'password'" is not equal to "grant all privileges on dbname.* to
--
Allen Beddingfield
Systems Engineer
Office of Information Technology
The University of Alabama
Office 205-348-2251
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.
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,
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
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
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.
_______________________________________________
Ale mailing list
http://mail.ale.org/mailman/listinfo/ale
See JOBS, ANNOUNCE and SCHOOLS lists at
http://mail.ale.org/mailman/listinfo
DJ-Pfulio
2017-09-12 23:18:32 UTC
Permalink
Dump the Oracle software and use MariaDB.
Post by Jim Kinney
OK. Found the problem. There had been an update quite some time back.
Once I reran mysql_secure_installation again it started working correctly.
Maybe it's just me but I'm NOT amused that a mandatory security update
to mysql-server unsecured the system silently and did not mention
anything about needing to resecure the database access after the update.
It allowed localhost anonymous access and reinstated the test database.
I came to office today even though we’re also closed and my home
internet is working. It’s only a couple of miles for me and it seems
this part of Cobb County was spared the worst of Irma. However,
they’re still predicting flooding for Austell.
_______________________________________________
Ale mailing list
***@ale.org
http://mail.ale.org/mailman/listinfo/ale
See JOBS, ANNOUNCE and SCHOOLS lists at
ht
Jim Kinney
2017-09-13 00:48:40 UTC
Permalink
That is happening with this dump, migrate and restore. This machine was assembled 10 years ago so before mariadb.
Post by DJ-Pfulio
Dump the Oracle software and use MariaDB.
Post by Jim Kinney
OK. Found the problem. There had been an update quite some time back.
Once I reran mysql_secure_installation again it started working
correctly.
Post by Jim Kinney
Maybe it's just me but I'm NOT amused that a mandatory security
update
Post by Jim Kinney
to mysql-server unsecured the system silently and did not mention
anything about needing to resecure the database access after the
update.
Post by Jim Kinney
It allowed localhost anonymous access and reinstated the test
database.
Post by Jim Kinney
Post by Lightner, Jeffrey
I came to office today even though we’re also closed and my home
internet is working. It’s only a couple of miles for me and it
seems
Post by Jim Kinney
Post by Lightner, Jeffrey
this part of Cobb County was spared the worst of Irma. However,
they’re still predicting flooding for Austell.
_______________________________________________
Ale mailing list
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.
Loading...