https://sysfiddler.com/mysql-error-1819-hy000-your-password-does-not-satisfy-the-current-policy-requirements/
only_full_group_by
https://stackoverflow.com/questions/34115174/error-related-to-only-full-group-by-when-executing-a-query-in-mysql
https://stackoverflow.com/questions/36864206/sqlstatehy000-1698-access-denied-for-user-rootlocalhost
Turns out you can't use the root user in 5.7 anymore without becoming a sudoer. That means you can't just run mysql -u root anymore and have to do sudo mysql -u root instead.
That also means that it will no longer work if you're using the root user in a GUI (or supposedly any non-command line application). To make it work you'll have to create a new user with the required privileges and use that instead.
https://askubuntu.com/questions/763336/cannot-enter-phpmyadmin-as-root-mysql-5-7/763359#763359
SQL dump data extended insert or not (or batched).
Knowing how to dump database properly is useful in robust development or deployment. Optimize dump data speed and import speed help deployment of big DB less stressful due to delay, data error etc.
https://dba.stackexchange.com/questions/98814/mysql-dump-import-incredibly-slow-on-my-developers-machine
https://stackoverflow.com/questions/2167522/innodb-takes-over-an-hour-to-import-600mb-file-myisam-in-a-few-minutes/2167641#2167641
Dump data line by line (opposed with --extended-insert) is slower but it help fix data error, ie. importing process interrupted; it is easier to continue import with this kind of export. You can use Vim or some combination of linux command to extract missing data to continue import, but it is more complex and time consuming.
Chrome new https auto redirect feature affect on local dev virtual host.
chrome://net-internals/#hsts
I have experienced few year ago that some local domain (vhost) like yoursite.abc.dev is preserved or translated to a real domain by Chrome, so setting vhost domain to something like this is not working (I am not sure but most of the time). So I often have to use junk / random domain ending like .local ...
only_full_group_by
https://stackoverflow.com/questions/34115174/error-related-to-only-full-group-by-when-executing-a-query-in-mysql
https://stackoverflow.com/questions/36864206/sqlstatehy000-1698-access-denied-for-user-rootlocalhost
Turns out you can't use the root user in 5.7 anymore without becoming a sudoer. That means you can't just run mysql -u root anymore and have to do sudo mysql -u root instead.
That also means that it will no longer work if you're using the root user in a GUI (or supposedly any non-command line application). To make it work you'll have to create a new user with the required privileges and use that instead.
https://askubuntu.com/questions/763336/cannot-enter-phpmyadmin-as-root-mysql-5-7/763359#763359
SQL dump data extended insert or not (or batched).
Knowing how to dump database properly is useful in robust development or deployment. Optimize dump data speed and import speed help deployment of big DB less stressful due to delay, data error etc.
https://dba.stackexchange.com/questions/98814/mysql-dump-import-incredibly-slow-on-my-developers-machine
https://stackoverflow.com/questions/2167522/innodb-takes-over-an-hour-to-import-600mb-file-myisam-in-a-few-minutes/2167641#2167641
Dump data line by line (opposed with --extended-insert) is slower but it help fix data error, ie. importing process interrupted; it is easier to continue import with this kind of export. You can use Vim or some combination of linux command to extract missing data to continue import, but it is more complex and time consuming.
Chrome new https auto redirect feature affect on local dev virtual host.
chrome://net-internals/#hsts
I have experienced few year ago that some local domain (vhost) like yoursite.abc.dev is preserved or translated to a real domain by Chrome, so setting vhost domain to something like this is not working (I am not sure but most of the time). So I often have to use junk / random domain ending like .local ...
Comments
Post a Comment