155 reputation
110
bio website limepepper.co.uk
location London, United Kingdom
age 38
visits member for 2 years, 10 months
seen Jun 26 '13 at 21:04

I spend my professional time working with Linux server technologies.

I previously obtained an RHCE, and studied Computing and Statistics for an undergraduate degree and am currently working through a Medicinal Chemistry MSc.

Have made some minor contributions to some open-source projects on github; https://github.com/tolland

and maintain a terrible ranty, unresearched speculation blog on blogspot.co.uk; http://take-your-vitamins.blogspot.com/

None of this is fit for human consumption.


Sep
5
awarded  Popular Question
Jun
26
awarded  Notable Question
May
31
awarded  Popular Question
Mar
11
awarded  Popular Question
Feb
5
awarded  Commentator
Feb
5
awarded  Citizen Patrol
Feb
5
comment How to forcibly create/modify MySQL user grants, without restarting the database service
@ShlomiNoach You seem to be suggesting that the "forced restart" in order to use "skip-grant-tables" or a "--init-file" option provides a level of security, however this is really "security by inconvenience" and is probably related in principle to "security by obscurity", ie is not a security measure at all. As root, I have umpteen options to "implant a user" into mysqld, i) by modifying the init.d script, ii) by poking into the running memory, iii) by spinning up another mysqld on another port, and then using iptables to switch new connections on to the nefarious 2nd service.
Feb
5
comment How to forcibly create/modify MySQL user grants, without restarting the database service
@ShlomiNoach "> I mean the attempted approach to implanting new accounts bypassing the root/other administrator login" - so to clarify. I am root on the box, I have the administrator login. I have sufficient access that I could just copy off any data that I wish to inspect. There is no escalation of privileges.
Feb
5
awarded  Autobiographer
Jan
29
comment How to forcibly create/modify MySQL user grants, without restarting the database service
Many thanks. I will try this and let you know. (I don't have enough points to upvote... ;-)
Jan
23
comment How to forcibly create/modify MySQL user grants, without restarting the database service
However, as a linux sysadmin by trade, and a MySQL dba by necessity, its slightly irks me, that the mysqld would refuse to submit to my will. I AM THE SERVER ADMINISTRATOR. BOW TO MY WILL PUNY PROCESS!!!!
Jan
23
comment How to forcibly create/modify MySQL user grants, without restarting the database service
So it's fairly obvious that this is not something that is going to be recommended for the general case, in that its going to be risky, and could result in an unstable app. Which was the whole point of the use-case, to avoid that impacting the underlying app.
Jan
22
revised How to forcibly create/modify MySQL user grants, without restarting the database service
added 28 characters in body
Jan
22
comment How to forcibly create/modify MySQL user grants, without restarting the database service
I think steps 4,5 and 7 are out too... ;-) so the catch in a solution to the problem of needing the root password requires the root password
Jan
22
revised How to forcibly create/modify MySQL user grants, without restarting the database service
added 2347 characters in body
Jan
22
comment How to forcibly create/modify MySQL user grants, without restarting the database service
So editing /etc/my.cnf is pretty much out, for the reasons of impact to the configuration, and the requirement for a restart.
Jan
22
revised How to forcibly create/modify MySQL user grants, without restarting the database service
added 334 characters in body
Jan
22
asked How to forcibly create/modify MySQL user grants, without restarting the database service
Aug
24
revised How to print out the query SQL text of a transaction by querying the “fn_dblog” or DBCC LOG('DataBaseName')?
added 508 characters in body
Aug
24
asked How to print out the query SQL text of a transaction by querying the “fn_dblog” or DBCC LOG('DataBaseName')?