{"id":640,"date":"2018-09-25T19:11:21","date_gmt":"2018-09-25T22:41:21","guid":{"rendered":"http:\/\/blog.pelleys.com\/?p=640"},"modified":"2018-09-25T19:11:27","modified_gmt":"2018-09-25T22:41:27","slug":"ubuntu-16-04-and-mysql-upgrades","status":"publish","type":"post","link":"https:\/\/blog.pelleys.com\/?p=640","title":{"rendered":"Ubuntu 16.04 and MySQL Upgrades&#8230;"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">So, I&#8217;ve been having this issue with upgrading MySQL 5.7 on a Ubuntu 16.04 server. It kept erroring out. Even uninstalling MySQL and reinstalling it did not help. Until I found this <a href=\"https:\/\/askubuntu.com\/questions\/835628\/access-denied-for-user-debian-sys-maint-installing-mysql\">post<\/a>\u00a0by\u00a0<a href=\"https:\/\/askubuntu.com\/users\/597657\/iqbal-cs\">iqbal_cs<\/a>:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>root@iqbal: mysql -u root -p\nEnter password:\nmysql> GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY '&lt;your password>';\nERROR 1819 (HY000): Your password does not satisfy the current policy requirements\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">If the error(1819) is raised, type this on the mysql terminal<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql> uninstall plugin validate_password;\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Then restart mysql:\u00a0<code>systemctl restart mysql<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Finally<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>apt install -f\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">to fix broken dependencies<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If error continues, enter again to mysql terminal, login: type this:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql> GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY '&lt;your password>'\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><code>apt -f install<\/code>\u00a0for the last time.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>So, I&#8217;ve been having this issue with upgrading MySQL 5.7 on a Ubuntu 16.04 server. It kept erroring out. Even uninstalling MySQL and reinstalling it did not help. Until I found this post\u00a0by\u00a0iqbal_cs: If the error(1819) is raised, type this &hellip; <a href=\"https:\/\/blog.pelleys.com\/?p=640\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-640","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/blog.pelleys.com\/index.php?rest_route=\/wp\/v2\/posts\/640","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.pelleys.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.pelleys.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.pelleys.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.pelleys.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=640"}],"version-history":[{"count":0,"href":"https:\/\/blog.pelleys.com\/index.php?rest_route=\/wp\/v2\/posts\/640\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.pelleys.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=640"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.pelleys.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=640"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.pelleys.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=640"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}