For some reason when I installed MySQL on my machine (a Mac running OS X 10.9) the 'root' MySQL account got messed up and I don't have access to it, but I do have access to the standard MySQL account 'sean@localhost' which I use to log into phpMyAdmin.  I am trying to reset the 'root' password by starting the mysqld daemon using the command mysqld --skip-grant-tables and then running the following lines in the mysql> shell.  mysql&gt; UPDATE mysql.user SET Password=PASSWORD('MyNewPass')  -&gt;                   WHERE User='root';  mysql&gt; FLUSH PRIVILEGES;  Problem is when I try to run that MySQL string the daemon spits back a ERROR 1142 (42000): UPDATE command denied to user ''@'localhost' for table 'user'  as if I didn't use the -u argument when I started the mysql shell, either though I did.  Any help is muchly appreciated as I am lost at this point. :/
I have a MySQL database that I "inherited" and I was not given the admin credentials.  I do however have access to the box that it runs on.  Is there a way to either recover the admin credentials or create new ones?
Cannot sort on numeric field with SOQL in Custom Metadata Cannot sort on a soql-request in a custom meta data type. When i perform SELECT .. FROM x__mdt WHERE ... ORDER BY x. Then field x cannot be numeric to get a correct order. Change it to a string-field ordering works ok. Playing with ASC/DESC makes no difference! In the 1960s I read book--an older children's book, I think--which I loved, and still remember, roughly.  I have no idea what the title is or who the author is, and I'm wondering if anyone knows this one:  Scientists had invented a device which they didn't fully understand, and which had puzzling effects.  For example, when a pencil was put into the machine, it disappeared, and then reappeared inside out: The lead was on the outside.  When people went into the machine, they came back dead, having died from fright.  Finally they sent a very open-minded person into the machine.  She was an artist, I think.  She was able to return alive, and described an alternate universe in which geometry was very different.  I distinctly remember that there were supposedly square triangles or four-sided triangles--or was it three-sided squares?  (This is, of course, a literally contradictory claim, but I didn't see the matter as clearly then.)  Thanks! How to force the browser to reload cached CSS and JavaScript files No more updates for Google Chrome 32-bit I am using Google Chrome 48.0 32-bit. Today when I launched Google Chrome, I got this message:    This computer will soon stop receiving Google Chrome updates because this Linux system will no longer be supported   I thought Ubuntu 14.04 is supported for five years, what's exactly happening here?  And on 64-bit Ubuntu, I get an error from Update Manager and apt-get update:  Failed to fetch http://dl.google.com/linux/chrome/deb/dists/stable/Release  Unable to find expected entry 'main/binary-i386/Packages' in Release file (Wrong sources.list entry or malformed file)   Some index files failed to download.   They have been ignored, or old ones used instead. Some sites are . What additional sites should the chat support?  One suggestion per answer. How to mass rename files with ill-formed numbering? Using "you" and "your" as a representation for yourself and everyone in general Example sentence:     I love when your dog just lets you sit there to pet them. You don’t necessarily know if they are enjoying it, but they love you enough to just sit there with you for a bit.   Is this correct? We assume the words "you" and "your" refer to the speaker of the sentence, and not to the listener, as second-person usually does. But it also refers to dog owners in general. I have always been curious about this. banner set interval Recently I have started playing with jQuery, and have been following a couple of tutorials. Now I feel slightly competent with using it (it's pretty easy), and I thought it would be cool if I were able to make a 'console' on my webpage (as in, you press the ` key like you do in  games, etc.), and then have it Ajax itself back to the server in-order to do stuff.  I originally thought the best way would be to just get the text inside the textarea, and then split it, or should I use the keyup event, convert the keycode returned to an ASCII character, append the character to a string and send the string to the server (then empty the string).  I couldn't find any information on getting text from a textarea, all I got was keyup information. Also, how can I convert the keycode returned to an ASCII character? Computing matrix-vector calculus derivatives $x, a$ in $\mathbb R^n$, $A$ in $\mathbb  R^{n\times n}$. Compute $d(x^T a)/dx$ and $d(x^T A x)/dx$.  I'm not sure about how to think about these and how to do these. Can someone explain how to derive the expressions for the two?  Finally, what happens when we have $A$ and $X$, BOTH in $\mathbb R^{n\times n}$, and we want to find $dTrace(XA)/dX$? How can I show or hide boot messages when Ubuntu starts? Is there a way to easily turn on/off showing the boot messages (loading the services) when Ubuntu starts? Is it something in Grub2?  I am running 10.04. Is there a phrase that means sleeping with someone without sex? is there a way to add hyperlinks in a Illustrator document? I am creating a CV in Illustrator and exporting it to a PDF. I just read an article which stated that it is a good idea that we use hyperlinks in the CV so that the employer can just click and not have to copy the address. I like this idea, but I don't know how to add a hyperlink to text in Illustrator. Is it possible? How can I automatically log out the guest account after a period of inactivity? As part of a kiosk system, I have set up a Guest account on a Mac OS X Snow Leopard computer. This account is cleared every time someone logs off the computer. However, plenty of people don't. Is there any way that I can automatically log out this guest account after a period of inactivity?  I tried using the security preferences pane, but that just causes the confirm logout dialog to show up.  I have hacked around the /System/Library/User Templates/ folder, so I can set the screensaver, desktop background, &amp;c. If something like ScriptSaver can solve my problem, I will gladly use it. How can I execute a file without giving myself execute permissions (with chmod u+x) for it?   If I try and tick the 'Allow executing file as program' checkmark, the checkmark is immediately removed. Baking lots of bread - keeping a yeast starter Like many people sheltering-at-home, I'm baking . My yeast supply is running low, and I'm not sure I'll be able to get more on demand. I'd like a simple way to make sure I have yeast on hand for my next batch. Could you all recommend a method for storing a starter culture?  Specifically:   How should I store it (how much? where? I have a fridge ~4C and a wine cooler ~13C)  How often should I feed it? With what? Should I divide the culture when feeding?  How much should I use when baking? Can I treat it like dry active yeast, or does it need more/less time?   For some other context, I'm a novice at making bread (I've made it a few times, and others in my family make it more often). I see lots of advice on sourdough starters, but am interested in something that's a replacement for dry active yeast (unless sourdough starters are actually easier to maintain). I found a  that was similar, but it focused on long-term storage of yeast and the answers did not describe how to use the starter.  Your advice is appreciated. How can I convert string to datetime with format specification in JavaScript? Redefining "cited on" string (and others) in biblatex Arduino Negative Voltage Reading with Positive Ground I am trying to measure voltage &amp; current off a solar charge controller from panel, battery &amp; load simultaneously with my arduino. I have managed to achieve this by tying all the negatives together and using it as GND, however, when I do that the charge controller doesn't function properly and when I switch to off-mode the loads still run. After checking the instruction manual further, I found out that the positives are shared common between Pan, Bat, Load. This was confirmed with a multimeter.   So now what I am thinking of doing is using the positive from the battery as the GND reference and then measuring all other voltages (through voltage dividers with respect to the GND). The voltages should then range between -17V to 0V.   However, I have read that the analog input pins are not able to read negative voltages, and with respect to the positive GND, the Analog inputs will all be negative.   EDIT: I was thinking of using an amplifier to invert positive ground to a negative ground, meaning I could measure all the positive sides of the voltages. But after getting answers from you guys it seems I may not have to use an amplifier and a voltage divider may suffice. I have currently included a 2 resistor voltage divider between each analog input, +5V source, Vmeasure which you can see in the diagram below.  According to my calculations, if this works, @-17V I should see 0.6V @ analog input. @0V I should see 4V at analog input.   I'd appreciate feedback on this circuit, and below in the second image I've also included a piece of another method suggested by @jonk (thanks), and would be interested in knowing what the benefits are of method B) over method A)  Thanks!  Ps. the ameters are there in place of ACS712 current sensors which also go into analog input pins.   Method A)        &ndash; Schematic created using   Method B (EDIT: This method has worked, I am still yet to test method A) thanks @Jonk)) IMO 1987 - function such that $f(f(n))=n+1987$ Show that there is no function $f: \mathbb{N} \to \mathbb{N}$ such that $$f(f(n))=n+1987, \ \forall n \in \mathbb{N}$$  This is problem 4 from IMO 1987 - see, for example, .