meta user
network profile
| bio | website | limepepper.co.uk |
|---|---|---|
| location | London, United Kingdom | |
| age | 36 | |
| visits | member for | 1 year, 4 months |
| seen | May 11 at 6:23 | |
| stats | profile views | 7 |
I spend my professional time working with Linux server technologies.
I previously obtained an RHCE, and studied Computing and Statistics for an undergraduate degree.
Currently working through a Medicinal Chemistry MSc with the Open University.
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/
Also I am trying to collect together my various IT best-practice notes in a wiki here; http://bodgeit.wikia.com/wiki/Bodge-it_Wiki
None of this is fit for human consumption.
|
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')? |
|
Mar 1 |
accepted | strategy for enabling a general query log on MySQL 5.0.95 with no restart? |
|
Mar 1 |
comment |
strategy for enabling a general query log on MySQL 5.0.95 with no restart? I should have known that they have covered this topic at percona. There should probably be a captcha on dba stackexchange that prevents you asking mysql questions until you have read every single mysql performance blog post evar. |
|
Mar 1 |
asked | strategy for enabling a general query log on MySQL 5.0.95 with no restart? |
