{"id":5523,"date":"2018-07-25T11:56:40","date_gmt":"2018-07-25T02:56:40","guid":{"rendered":"https:\/\/auctionpro.co.kr\/?p=5523"},"modified":"2018-07-25T12:01:27","modified_gmt":"2018-07-25T03:01:27","slug":"mysql-error-mysql_upgrade","status":"publish","type":"post","link":"https:\/\/www.auctionpro.co.kr\/?p=5523","title":{"rendered":"mysql Error ->  mysql_upgrade"},"content":{"rendered":"<p>Error Saving Account<br \/>\nError creating account vpopmail@%: Column countof mysql.user is wrong, Expected 42&#8230;<br \/>\nPlease use myslq_upgrade to fix this error.<\/p>\n<p><a href=\"https:\/\/auctionpro.co.kr\/wp-content\/uploads\/2018\/07\/vopmail_insert_Error.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5524\" src=\"https:\/\/auctionpro.co.kr\/wp-content\/uploads\/2018\/07\/vopmail_insert_Error.jpg\" alt=\"\" width=\"832\" height=\"765\" srcset=\"https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2018\/07\/vopmail_insert_Error.jpg 832w, https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2018\/07\/vopmail_insert_Error-300x276.jpg 300w, https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2018\/07\/vopmail_insert_Error-768x706.jpg 768w, https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2018\/07\/vopmail_insert_Error-150x138.jpg 150w, https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2018\/07\/vopmail_insert_Error-400x368.jpg 400w\" sizes=\"auto, (max-width: 832px) 100vw, 832px\" \/><\/a><\/p>\n<p><strong>mysql_upgrade -u root -p<\/strong><\/p>\n<pre class=\"lang:vim decode:true\">[root@ns1 etc]# mysql_upgrade -u root -p\r\nEnter password:\r\nLooking for 'mysql' as: mysql\r\nLooking for 'mysqlcheck' as: mysqlcheck\r\nRunning 'mysqlcheck with default connection arguments\r\nRunning 'mysqlcheck with default connection arguments\r\nError    : Table 'ihave.wp_tp_special_offer' doesn't exist\r\nstatus   : Operation failed\r\nmysql.columns_priv                                 OK\r\nmysql.db                                           OK\r\nmysql.event                                        OK\r\nmysql.func                                         OK\r\nmysql.general_log                                  OK\r\nmysql.help_category                                OK\r\nmysql.help_keyword                                 OK\r\nmysql.help_relation                                OK\r\nmysql.help_topic                                   OK\r\nmysql.host                                         OK\r\nmysql.ndb_binlog_index                             OK\r\nmysql.plugin                                       OK\r\nmysql.proc                                         OK\r\nmysql.procs_priv                                   OK\r\nmysql.servers                                      OK\r\nmysql.slow_log                                     OK\r\nmysql.tables_priv                                  OK\r\nmysql.time_zone                                    OK\r\nmysql.time_zone_leap_second                        OK\r\nmysql.time_zone_name                               OK\r\nmysql.time_zone_transition                         OK\r\nmysql.time_zone_transition_type                    OK\r\nmysql.user                                         OK\r\n\r\nRepairing tables\r\nihave.wp_tp_special_offer\r\nError    : Table 'ihave.wp_tp_special_offer' doesn't exist\r\nstatus   : Operation failed\r\nRunning 'mysql_fix_privilege_tables'...\r\nOK<\/pre>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Error Saving Account Error creating account vpopmail@%: Column countof mysql.user is wrong, Expected 42&#8230; Please use myslq_upgrade to fix this error. mysql_upgrade -u root -p <a class=\"mh-excerpt-more\" href=\"https:\/\/www.auctionpro.co.kr\/?p=5523\" title=\"mysql Error -&gt;  mysql_upgrade\">[&#8230;]<\/a><\/p>\n<\/div>","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[88],"tags":[],"class_list":["post-5523","post","type-post","status-publish","format-standard","hentry","category-mysql"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/5523","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5523"}],"version-history":[{"count":0,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/5523\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5523"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5523"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5523"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}