I have an ancient MySQL database that I've kept running for a very long time, probably about 14 years. Apparently, I'd missed to run mysql_upgrade on it long ago, perhaps during the upgrade from 4.x to 5.x (and ever since). Now, after upgrading to 5.6.22 (from 5.5.x) yesterday, I can no longer log in, and I also can't seem to solve the issue. Apparently, old-style password hashes have been deprecated for over 10 years, but I have never seen any warnings saying so, until it stopped working just now.  The first symptom something was wrong was this:  mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connect   I get the same error using mysql -u root -p. I got past that by using the --skip-secure-auth option to the mysql command. After that, :  SET old_passwords = 0; UPDATE mysql.user SET plugin = 'mysql_native_password', Password = PASSWORD('DBA-chosen-password') WHERE (User, Host) = ('user1', 'localhost'); FLUSH PRIVILEGES;   This fails:  ERROR 1054 (42S22): Unknown column 'plugin' in 'field list'   The solution to that error appears to be to run mysql_upgrade, which updates the mysql.user table to add the plugin column. However, that also fails, with this wonderful error:  # mysql_upgrade -u root -p Enter password:  Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck FATAL ERROR: Upgrade failed   My guess is that this is because there is no --skip-secure-auth option to mysql_upgrade, so it can't log in. I tried to disable secure-auth for the server, but if I did it correctly, it didn't help. (Possibly because mysql_upgrade that ships with 5.6.x uses it by default and doesn't allow you to disable it?)  Does anyone have a solution to this? I'm not above things like temporarily disabling passwords etc. while solving it; the server is only accessible from localhost, and I'm the only local user.
using this command I changed root password   mysqladmin -u root password fg$pkh@567fghu   And now I cant access mysql. Is this because mysql parse the chars other than what I expect?  Also I completely removed and installed mysql and Problem is extant. How do I remove mysql so that I get rid of password?
"I let him do it" and "I allow him to do it", why exactly does one require 'to'? Is "89.9%" singular or plural? I’m writing a dissertation on network security. I’m unsure which of the following to use:   ...89.9%, which is 57 million users.  ...89.9%, which are 57 million users.   Technically it should be are because it refers to a plural amount of people, but it doesn’t sound right to me considering that 57 million is in a sense one group. How to disable or uninstall Microsoft Edge in Windows 10 My try, using $x = \sec(u)$ substitution:  $$ \begin{eqnarray} \int \frac{\sqrt{x^2-1}}{x} \mathrm{d}x &amp;=&amp; \int \frac{\sqrt{\sec^2(u) - 1}}{\sec(u)}\tan(u)\sec(u) \mathrm{d}u \\ &amp;=&amp; \int \tan^2(u) \mathrm{d}u \\ &amp;=&amp; \tan(u) - u + C \\ &amp;=&amp; \tan(arcsec(x)) - arcsec(x) + C \end{eqnarray} $$  However, according to , the answer should be: $$ \int \frac{\sqrt{x^2-1}}{x} \mathrm{d}x = \sqrt{x^2-1}+\arctan \left( \frac{1}{\sqrt{x^2-1}} \right)+C $$ When I derive this last answer I don't get back the integrand, but rather: $$ \frac{\mathrm d}{\mathrm d x}\left(\sqrt{x^2-1}+\arctan \left( \frac{1}{\sqrt{x^2-1}} \right)+C\right) = \frac{x}{\sqrt{x^2-1}}- \frac{x}{(x^2-1)^{3/2}\left(1+\frac{1}{x^2-1}\right)} $$  I don't know how to simplify this expression more. Also, I am unable to check whether my answer is correct because I don't know how to find the derivative of $arcsec(x)$.  Can someone check my calculations and tell me where I've done something wrong and how one can simplify the last expression to get back the integrand? Create WiFi hotspot on ubuntu mkdir error: no such file or directory on a linux machine running CENTOS v 7.8.2003 I am in a directory Neutrinos I now do  mkdir /pionloop/ this works. I then go to into this new directory pionloop and do mkdir /E_0.3 and this works as well. I thus have as a result a directory Neutrinos/pionloop/E_0.3.  Now, starting in Neutrinos I want to do this in one command and therefore do mkdir /pionloop/E_0.3 and get: `mkdir: cannot create directory ‘/pionloop/E_3.0’: No such file or directory  What is going wrong here?? How to know if other threads have finished? equality of two operators... Please help me with the following problem( give some hints or references):  Let $X$ be a Banach space and $B(X)$ be the algebra of bounded linear operators on $X$. Suppose that $A$ and $B$ are two operators in $B(X)$ such that for every $T \in B(X)$ we have $\sigma(AT)=\sigma(BT)$. Show that $A=B$.  Here $\sigma(A)$ denotes the spectrum of $A$, i.e., the the set of all complex numbers $\lambda$ such that $\lambda I − A$ has no inverse in $B(X)$.  Thanks in advance. You "show" someone a picture. You "---" someone a song? In , we have a verb meaning &quot;to show&quot; corresponding to &quot;to see/to look&quot;, and we have a different verb corresponding to &quot;to hear/to listen&quot;:  inti tara stampa (you look at a picture.) ---- jiena nurilek stampa (I show you a picture) inti tisma' diska (you listen to a song.) ----- jiena nsemmagħlek diska (I 'show' you a song)  In English, do you &quot;show someone a song&quot; (sounds weird to me) or is there a verb that corresponds more directly to the Maltese insemmgħek? Is adjoint of singular matrix singular? What would be its rank? Crop simple features object in R Navigating lookup relationships with dot notations, to retrieve field values I need to access the value from a roll-up field on my Opportunities, from it's related Opportunity Product.  When I use oli.Opportunity.Software_Line_Item__c the value retrieved is always null.  So I've also tried oli.OpportunityId.Software_Line_Item__c which causes an error in the compiler     Invalid foreign key relationship: OpportunityLineItem.OpportunityId   &amp; just to make sure that it's not the roll-up field calculation that's not working as expected, I've tested oli.Opportunity.Name which is also returning null.  I know this is basic but I don't have Eclipse installed so I can't check the correct reference to use. Could someone please let me know how I can navigate this relationship, to retrieve the value from the Software_Line_Item__c field? How do I adjust the Clock Indicator format? I noticed that, for each research project, there comes a point where I have to consult the literature, and find all the previous research related to the current project.  Unfortunately, I seem to be very inefficient in my approach. I spend a lot of time digging through papers that are really interesting, but only of tangential importance to my current work, just to find the few papers that actually do similar things. (The pile of "cool paper, read when time" just keeps growing.)  Hence, I'm wondering: What is the most time efficient way to get a thorough overview of the literature in a specific niche of a field?    While searching for an answer I came across these questions:   - This question is quite similar and I liked the approach. I debated with myself if this is a duplicate, but I think it is focused more on how to be sure the search was exhaustive, whereas I'm worried about time efficiency. (Also, I'm a bit curious if things have changed since 2012.)   - The answer provides tips on how to identify what literature generally is important in a field, but I am looking for the most cost effective (least time consuming) way to do it in an area, where I know the broad literature, but not the specifics. For all infinite cardinals $\kappa, \ (\kappa \times \kappa, <_{cw}) \cong (\kappa, \in).$ I don't understand the proof to the a/m claim. How we know that $\eta &lt; \kappa$ and $(\alpha,\beta)&lt;_{cw} (0, \eta) $ and hence $h: \mu \to \eta \times \eta$ is injective? Appreciate if anyone could advise.  Here is an excerpt of the proof:  For an infinite ordinal $\kappa,$ the canonical well-ordering of $\kappa \times \kappa,$ denoted by $&lt;_{cw}$ is defined as follows: $(\alpha_1, \beta_1)&lt;_{cw} &lt; (\alpha_2, \beta_2)$ iff either one of the following holds.  $(1): \max\{\alpha_1,\beta_1\} &lt; \max\{\alpha_2,\beta_2\}$  $(2): \max\{\alpha_1,\beta_1\} =\max\{\alpha_2,\beta_2\}$ and $\alpha_1&lt;\alpha_2$   $(3): \max\{\alpha_1,\beta_1\} =\max\{\alpha_2,\beta_2\}$ and $\alpha_1 = \alpha_2$ and $\beta_1 &lt; \beta_2.$  Claim: For all infinite cardinals $\kappa, (\kappa \times \kappa, &lt;_{cw}) \cong (\kappa, \in).$  Proof: (It has been show that it is true for $\kappa = \omega$) Assume there is a counterexample  $\kappa.$ Let $A= \{\lambda \in \kappa + 1| \lambda\geq \omega \ is \ a \ cardinal \ and \ (\lambda \times \lambda, &lt;_{cw}) \not\cong (\lambda, \in)\}.$ Then, $\kappa \in A.$ Let $\mu$ be least element of $A.$ Thus, $\mu &gt; \omega$ and for all $\lambda,$ if $\omega \leq \lambda &lt; \mu$ and $\lambda$ is a cardinal, then $(\lambda \times \lambda, &lt;_{cw}) \cong (\lambda, \in).$  By Comparability theorem, $(\mu, \in)$ is isomorphic to initial segment of $(\mu \times \mu, &lt;_{cw})$ since $|\mu \times \mu| \geq \mu$ and $\mu$ is cardinal. Let $(\alpha, \beta) \in \mu \times \mu$ such that $(\mu, \in)$ is isomorphic to initial segment of $(\mu \times \mu, &lt;_{cw})$ given by $(\alpha, \beta).$ Let $h$ be the isomorphism. Let $\eta= \max\{\alpha, \beta\}+ \omega.$ Then $\eta &lt; \kappa$ and $(\alpha,\beta)&lt;_{cw} (0, \eta).$ HENCE, $h: \mu \to \eta \times \eta$ is injective. Let's say we have $2$ particles facing each other and each traveling (almost) at speed of light.    Let's say I'm sitting on #$1$ particle so in my point of view #$2$ particle's speed is (almost) $c+c=2c$, double light speed? Please say why I am incorrect :)    EDIT: About sitting me is just example, so in point of view of #1 particle, the second one moves at (almost) $c+c=2c$ speed? How to boot from non-Ubuntu live ISO images like Fedora or CentOS? I have a repeated composition of functions ${T_n}(z) = {\tau _0} \circ {\tau _1} \circ {\tau _2} \circ  \cdots  \circ {\tau _n}(z)$  By analogy with $\sum\limits_{i = 1}^n {} ,\prod\limits_{i = 1}^n {} ,\bigcup\limits_{i = 1}^n {} ,\bigcap\limits_{i = 1}^n {} ,$ I want to write ${T_n}(z) = \left( {\mathop  \circ \limits_{i = 0}^n {\tau _i}} \right)(z)$ or even ${T_n}(z) = {\mathop  \circ \limits_{i = 0}^n {\tau _i}} (z)$. Can I do this? Just watched the 'How Big is the Universe?' TV program and it indicated that the universe is believed to be infinite in size. They used an approach involving measuring the internal angles of triangles. Or something like that anyway.  But hang on, the Universe has a known starting time and size followed by a finite time expanding at a finite speed. So surely, by definition, it cannot be infinite? I can accept it is honking big but by definition it cannot be infinite. Are they misleading me? I need some help importing MrSID Raster files in QGIS. I am running 2.6.0 on Linux Mint 17. After an internet search I have found a couple of resources that are perhaps outdated. The most promising is found here :    However when I attempted to follow the instructions my terminal and I could not find the file "libgdal-mrsid-src" on either the stable or unstable Ubuntu GIS repos. Has anyone had success or could lead me in the right direction?