tag:blogger.com,1999:blog-16959946.post589327846487948676..comments2023-12-09T16:44:47.897+01:00Comments on The Data Charmer: MySQL 5.7.6 is out. Be prepared for big changesGiuseppe Maxiahttp://www.blogger.com/profile/15801583338057324813noreply@blogger.comBlogger15125tag:blogger.com,1999:blog-16959946.post-84910946859068444312015-04-01T13:32:20.416+02:002015-04-01T13:32:20.416+02:00Feel free to translate. Please post a link to the ...Feel free to translate. Please post a link to the translation when done.Giuseppe Maxiahttps://www.blogger.com/profile/15801583338057324813noreply@blogger.comtag:blogger.com,1999:blog-16959946.post-83706513951401756402015-04-01T13:30:08.833+02:002015-04-01T13:30:08.833+02:00Hello,
Very interesting article. so can i re-post...Hello,<br /><br />Very interesting article. so can i re-post your article to translate korean ?<br /><br />It is really useful information, I want to share for korean people.<br /><br />Thank you.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-16959946.post-4099538313999016142015-03-24T20:55:18.152+01:002015-03-24T20:55:18.152+01:00About phpMyAdmin, work is in progress for the upco...About phpMyAdmin, work is in progress for the upcoming 4.4.1 version to fully support MySQL 5.7.6.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-16959946.post-68608575058906841862015-03-17T01:53:05.284+01:002015-03-17T01:53:05.284+01:00@Ben,
Thanks for the link. Joro's post is very...@Ben,<br />Thanks for the link. Joro's post is very enlightening.Giuseppe Maxiahttps://www.blogger.com/profile/15801583338057324813noreply@blogger.comtag:blogger.com,1999:blog-16959946.post-22871028786805450472015-03-16T21:56:49.263+01:002015-03-16T21:56:49.263+01:00Hi Giuseppe -
Nice writeup, as always! :) I not...Hi Giuseppe -<br /><br />Nice writeup, as always! :) I noticed Joro also posted about some of these bootstrap changes, giving a little background on the reasoning; don't know whether you've already seen it. Just in case you're interested -<br /><br />http://mysqlserverteam.com/initialize-your-mysql-5-7-instances-with-ease/<br /><br />Thank you (and thanks for<br />continuing to maintain Sandbox)<br /><br />Ben KrugBen Krugnoreply@blogger.comtag:blogger.com,1999:blog-16959946.post-87597805646112841082015-03-11T10:05:20.806+01:002015-03-11T10:05:20.806+01:00Hm, it never printed any password to the screen. H...Hm, it never printed any password to the screen. However I was able to login with skip grant tables. Then ran "update user set authentication_string=password('test') where user='root';". Then "set password='test123';" once logged in.<br /><br />Thanks!Chrishttps://www.blogger.com/profile/07418691476618587542noreply@blogger.comtag:blogger.com,1999:blog-16959946.post-88764515948601928092015-03-11T07:58:11.762+01:002015-03-11T07:58:11.762+01:00@Chris,
Quoting myself from above:
Compared to t...@Chris,<br />Quoting myself from above: <br /><br /><i>Compared to the previous versions, the most notable difference is that there is no .mysql_secret file, but a simple line on the screen mentioning the temporary password.</i><br /><br />If you missed the output on screen, I don't know how to recover from that.Giuseppe Maxiahttps://www.blogger.com/profile/15801583338057324813noreply@blogger.comtag:blogger.com,1999:blog-16959946.post-61951099559977503372015-03-11T01:57:34.758+01:002015-03-11T01:57:34.758+01:00can't seem to find the ~/.mysql_secret file (t...can't seem to find the ~/.mysql_secret file (this is a clean install). Anyway to login as root? Or should I just re-install?Chrishttps://www.blogger.com/profile/07418691476618587542noreply@blogger.comtag:blogger.com,1999:blog-16959946.post-78103357744744055512015-03-10T22:02:36.140+01:002015-03-10T22:02:36.140+01:00@Don,
I am not excusing anything. I am, actually, ...@Don,<br />I am not excusing anything. I am, actually, quite annoyed by this bug. But since there is little I can do except spreading the news, I can only speculate on the cause.<br />If you want to get deep conclusions from this fact, be my guest. <br />I am satisfied by having found the issue, having got it fixed (in the <a href="https://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-7.html" rel="nofollow">next version</a>), and having a workaround in my own <a href="http://mysqlsandbox.net" rel="nofollow">project</a>.Giuseppe Maxiahttps://www.blogger.com/profile/15801583338057324813noreply@blogger.comtag:blogger.com,1999:blog-16959946.post-20896608061655344222015-03-10T21:46:10.360+01:002015-03-10T21:46:10.360+01:00It's not my impression that you're making ...It's not my impression that you're making fun of it, but that you're trying to excuse it as an inconsequential "accident" instead of incompetence. Accidents like that don't happen without causes like incompetence or negligence or malice. Accidents like that are a symptom that something is deeply wrong.<br />Donhttps://www.blogger.com/profile/14540759596834244448noreply@blogger.comtag:blogger.com,1999:blog-16959946.post-83704825938949980402015-03-10T20:43:44.540+01:002015-03-10T20:43:44.540+01:00@Don
"LOL away?" What gave you the impre...@Don<br />"LOL away?" What gave you the impression that I was making fun of it? I am the one who found the bug and reported it, and this is the explanation I got. Since the person I talked to is someone I trust, I don't have reason to think otherwise.<br />I can elaborate further and tell you why this particular error was likely to happen: it's because since the beginning MySQL was built with root user without password, and most of the tests were running in such conditions. That was the culture of rapid growth that gave MySQL its popularity and the developers are paying now the technical debt that has left so many features with poor testing behind. What Oracle is doing now is trying to redress that situation by strengthening the defaults, for which I commend them. Being a QA developer, I am less pleased with the quality of tests that let such mistake pass, but I know that such things happen, and it does not necessarily mean that there is a can of worms behind this bug.Giuseppe Maxiahttps://www.blogger.com/profile/15801583338057324813noreply@blogger.comtag:blogger.com,1999:blog-16959946.post-29155567864511204342015-03-10T20:27:47.628+01:002015-03-10T20:27:47.628+01:00"The old syntax was meant to be only deprecat..."The old syntax was meant to be only deprecated, but it was accidentally completely removed."<br /><br />How could Oracle have possibly "accidentally completely remove" the old syntax for setting a password even though it "was meant to be only deprecated", without being completely incompetent? <br /><br />I can not in my wildest imagination come up with a scenario in which a competent developer could possibly "accidentally remove" something like that. If they made such a huge "accident" with that security feature, what other terrible negligent "accidents" lurk just beneath the surface of this new release of MySQL? <br /><br />How can you "LOL" away such an incompetent "accident" like that? <br />Donhttps://www.blogger.com/profile/14540759596834244448noreply@blogger.comtag:blogger.com,1999:blog-16959946.post-34442094570447239372015-03-10T17:49:12.817+01:002015-03-10T17:49:12.817+01:00removing password field does not just break tests/...removing password field does not just break tests/scritps:<br />"You cannot use mysqldump to dump the user table from a version of MySQL older than 5.7.6 and reload the dump file into MySQL 5.7.6 or later. Instead, perform a binary (in-place) upgrade to MySQL 5.7.6 or later and run mysql_upgrade to migrate the Password column contents to the authentication_string column."Justin Swanharthttps://www.blogger.com/profile/08193089637089861226noreply@blogger.comtag:blogger.com,1999:blog-16959946.post-40332906882856618152015-03-10T12:13:38.645+01:002015-03-10T12:13:38.645+01:00I don't know about phpMyAdmin. If it runs oper...I don't know about phpMyAdmin. If it runs operations that deal with passwords, it may be affected.<br /><br />I haven't tested the performance. I am sure someone at Percona would do it sooner or later.<br />Giuseppe Maxiahttps://www.blogger.com/profile/15801583338057324813noreply@blogger.comtag:blogger.com,1999:blog-16959946.post-56884782742569731562015-03-10T11:29:06.163+01:002015-03-10T11:29:06.163+01:00Hi Giuseppe,
Do you think that the current versio...Hi Giuseppe,<br /><br />Do you think that the current version of phpMyAdmin will suffer from compatibility issues with 5.7.6?<br /><br />Also, do you have any references asserting that the performance of 5.7.6 is 2 to 3 times better than the predecessor (usually, these claims are substantiated but only under certain conditions).Fadi El-Eter (itoctopus)http://www.itoctopus.comnoreply@blogger.com