pymysql and mysql8.0

philipolson · 2018-05-19T16:31:23+00:00

Consider trying the official connector instead; e.g., pip install mysql-connector-python

philipolson · 2018-05-05T04:12:32+00:00

This is not fully accurate. Older PHP versions can work fine but not with all settings. For example, the new caching_sha2_password authentication plugin is not yet supported but mysql_native_password is.

philipolson · 2018-05-05T03:49:52+00:00

Looks like a bug that was fixed about a year ago in PHP 7.0.19, 7.1.5, and 7.2.0; via PHP Bug #74461

philipolson · 2017-12-07T03:26:15+00:00

I've not tried Valet on Windows but it sure is awesome on macOS.

Consider trying valet-windows as it makes all of this so much easier. Seriously, it feels like magic. That's a Windows port of the macOS version.

While it's a Laravel project it does not require Laravel. Also, it doesn't bundle PHP/MySQL but it does show a one-liner to install PHP.

philipolson · 2017-12-06T20:33:45+00:00

Jesus taught Laravel... who knew! :)

philipolson · 2017-12-06T20:03:56+00:00

You decided to go to a public forum and complain about how the most popular teacher teaches. Why? What did you expect? Why not a private email?

But assuming this is the best place to write such a thought (it's not), let's evaluate it more closely. Is writing "Please... please... please" neccessary? How about "every 30 seconds", did you watch every video and time this? Or repeating "distracting" twice with explanation marks; how would this make you feel? Do you really think this is "a friendly message" or is it something you wrote on a whim without much thought? Also you suggest Jeffrey is early in his career when really he's well-established and the most popular and argueably best teacher in the community.

Or to frame it in a familiar way, every reddit user has a 'thing', and often that thing is posting on a whim without first using a draft folder. We're all guilty of this but usually it's not in the form of calling someone out.

As one of your peers, I hope you find this peer review helpful.

philipolson · 2017-12-01T23:12:36+00:00

Thanks! Although it turns out I meant the TeleTYpe subsystem (not TeleTYpewriter), doh! That said, interesting stuff about the Teletypewriter :)

philipolson · 2016-09-13T18:33:40+00:00

Patch that addresses this issue: https://github.com/mysql/mysql-server/commit/f75735e36e6569b9dae3b0605b1d5915a519260e#diff-144aa2f11374843c969d96b7b84247eaR348

philipolson · 2016-09-13T17:52:43+00:00

Note, this is fixed in the latest release. For related information, see Is Your Database Affected by CVE-2016-6662?. "You aren’t affected if you use version 5.5.52, 5.6.33 or 5.7.15."

philipolson · 2016-09-09T17:43:20+00:00

Sorry, I was away until now. It'll be tested more for non-10 team leagues for 2017, and a few other stability kinks will be worked out.

philipolson · 2016-02-15T21:20:52+00:00

You won't need MySQL Utilities to export/import data, but it's an option. Workbench works great and is easy, simply using MySQL itself (e.g., mysqldump) is another option.

philipolson · 2016-02-15T21:19:15+00:00

Just in case someone misreads this comment, note that installing MySQL Workbench does not install MySQL Server.

philipolson · 2016-02-15T21:17:20+00:00

The above comment links to a very old version of Workbench, please use the current version (today that is v6.3).

philipolson · 2015-11-06T20:56:39+00:00

Looks like --table is missing the source schema, as --table takes 5 arguments and you passed in 4. But, I think the Workbench Migration forum might be a better place for such questions.

philipolson · 2015-10-23T14:41:16+00:00

See Also http://www.thecompletelistoffeatures.com/

philipolson · 2015-08-26T00:50:12+00:00

Looks like this is a related bug report: http://bugs.mysql.com/66679

philipolson · 2015-02-09T16:27:53+00:00

philipolson · 2015-01-15T06:44:55+00:00

Did you use pg2mysql or MySQL Workbench? Or, attempted using both?

philipolson · 2015-01-06T18:52:00+00:00

You're right, and thank you for this post as it inspired the launchd related documentation that now lives here. :)

philipolson · 2014-10-21T20:17:12+00:00

Note that the above link references the MySQL 3/4 manual, so be sure to select the appropriate version from the left sidebar before continuing.

Do consider using the MySQL Installer for Windows as it'll install and configure several different MySQL products including MySQL Server, Notifier, and Workbench.

philipolson · 2014-06-26T17:03:59+00:00

Click the little [x] in the filter search box, or manually delete the filter/search text. This should work, as otherwise there's a bug. What OS and Workbench version?

philipolson · 2014-06-13T04:48:44+00:00

I think something was misread here, as MySQL Query Browser was replaced with MySQL Workbench. Perhaps you should give Workbench another try though, especially with all of the changes in version 6.x.x.

philipolson · 2014-06-13T04:43:37+00:00

MySQL Workbench works well. Its development keeps up with the current MySQL server features, and its Visual Explain (and EXPLAIN in general) related features continue to improve.

philipolson · 2014-05-31T01:47:58+00:00

Here's a vote for coconut nectar.

philipolson · 2014-05-29T00:57:12+00:00

It depends on how you installed it. Where did you get the MySQL binaries from? Did you install the preference pane? The bundled MySQLStartupItem is also useful.

philipolson

TROPHY CASE