Re: mysql CLI - history shared by users?
From: "Daniel Jitnah" <djitnah@greenwareit.com.au>
YEP -confirmed!! - even if you use a different linux login user and a different mysql user.
Sure it was a different Linux user? I realized that the Unix user is having a $HOME/.mysql_history which gets updated when you close the mysql CLI. That makes sense and explains why I could see the commands of a different MySQL user.
But then I logged out of MariaDB only and logged in again.... and it did NOT do it anymore, using same user. Does not seem to be consistent behaviour??
If you really have a different Linux user - maybe it is shared memory somewhere that gets cleared? But I cannot reproduce it with a different Unix user - so it's just noise from my side. Sorry about that Peter
Hi Make sure that they do not have the same home directory. I know a lot if businesses which set up many users with the same home directory. Gordon. Sent from my iPhone
On 9 Oct 2013, at 1:06 pm, Petros <Petros.Listig@fdrive.com.au> wrote:
From: "Daniel Jitnah" <djitnah@greenwareit.com.au>
YEP -confirmed!! - even if you use a different linux login user and a different mysql user.
Sure it was a different Linux user?
I realized that the Unix user is having a $HOME/.mysql_history which gets updated when you close the mysql CLI.
That makes sense and explains why I could see the commands of a different MySQL user.
But then I logged out of MariaDB only and logged in again.... and it did NOT do it anymore, using same user. Does not seem to be consistent behaviour??
If you really have a different Linux user - maybe it is shared memory somewhere that gets cleared?
But I cannot reproduce it with a different Unix user - so it's just noise from my side.
Sorry about that Peter
_______________________________________________ luv-main mailing list luv-main@luv.asn.au http://lists.luv.asn.au/listinfo/luv-main
On 09/10/13 13:06, Petros wrote:
From: "Daniel Jitnah" <djitnah@greenwareit.com.au>
YEP -confirmed!! - even if you use a different linux login user and a different mysql user. Sure it was a different Linux user? Yes, I had a gnome session on terminal 7 and another mate session on terminal 8, 2 different users. Login to the mysql server from each terminal as 2 different users (root and normal user) - And 2 different mysql users too (drupaluser and root). That surprised me, because I would have thought it would not happen with 2 linux users.
As I said weird thing is when I logged out of one mysql session and relogged in again, I could not reproduce it. (note again it was MariaDB)
I realized that the Unix user is having a $HOME/.mysql_history which gets updated when you close the mysql CLI.
That makes sense and explains why I could see the commands of a different MySQL user.
But then I logged out of MariaDB only and logged in again.... and it did NOT do it anymore, using same user. Does not seem to be consistent behaviour?? If you really have a different Linux user - maybe it is shared memory somewhere that gets cleared?
Yes that what I am thinking too.
But I cannot reproduce it with a different Unix user - so it's just noise from my side.
Sorry about that Peter
_______________________________________________ luv-main mailing list luv-main@luv.asn.au http://lists.luv.asn.au/listinfo/luv-main
Petros <Petros.Listig@fdrive.com.au> writes:
From: "Daniel Jitnah" <djitnah@greenwareit.com.au>
YEP -confirmed!! - even if you use a different linux login user and a different mysql user.
Sure it was a different Linux user?
I realized that the Unix user is having a $HOME/.mysql_history which gets updated when you close the mysql CLI.
Could be petros doing "sudo mysql" instead of "sudo -H mysql" and root & his normal user are inadvertently sharing $HOME.
participants (4)
-
Daniel Jitnah -
Gordon Heydon -
Petros -
trentbuck＠gmail.com