Thursday, February 25. 2010
Expunging MySQL root@ trivia from my brain....
I'm posting this simply because I had to go to the trouble of figuring this out. Imagine a MySQL* database that has several databases, and only one admin account, but that admin account is bound to a particular database and not global to the entire server. Don't ask me how, but there was no root user in the database. Not a bad idea from a security perspective, but it's problematic to administrate the machine (read: try adding new databases, users or doing anything with the mysql database). It may seem like the simple fix would be to reboot the database with --skip-grant-tables and fire off a:
Quicksearch
- Lunch amusement: go to link view source, then search for <strong> Keep searching. You'll laugh. #fb2 days ago
- BlueArc picked up $20M for dev and heads in eng/S&M? Wonder who would buy hw NAS gateways. 13custs? #fail #tech #writeoff link2 days ago
- U don't tweet about shit you hear in bathroom, but this must be told. ~3yo in stall says, "oop! Daddy, it wooshed my pooper!" Everyone LOL'd6 days ago
- What's more sad: lamenting Schorr's death after listening for >15yrs, or reading Schorr's bio & legacy after his passing? He will be missed.6 days ago
- Firefox Tabcandy is browser tabs done right. WTB this feature everywhere, ten years ago. link1 week ago
- @loganb @marginoferror If a future maintenance eng doesn't know # is a comment or that python is whitespace bound... bigger issues at play.1 week ago
- @marginoferror Depends on the local talent market. I didn't start using it till recently, but it was never fringe.1 week ago
- @marginoferror What's your definition of non-standard? :) django productivity > rails productivity, would the cust care?1 week ago
- @mjasay weak password, malware or gmail security issue server-side?1 week ago
- Actually read the paper today while at breakfast. Once I was done, I pulled out my iPhone to read the news. USA Today? Nearly a tabloid. #fb1 week ago
