Can’t open the mysql.plugin table. Please run mysql_upgrade to create it

You probably misunderstood/skipped point 4 in your list, Initialize MySQL. It means to either copy an existing data directory there or to create a new one, see Initializing the Data Directory Manually Using mysqld .

To initialize a fresh data directory, you basically (after setting your config file) just have to run either

bin\mysqld --initialize

or

bin\mysqld --initialize-insecure

The latter will set an empty root password

Related Posts:

  1. Xampp MySQL not starting – “Attempting to start MySQL service…”
  2. Differences between utf8 and latin1
  3. What specific database privileges does WordPress need?
  4. What is the most secure way to set up the MySQL user in WPMU?
  5. WordPress installation on valet php 8 (PHP Fatal error: Uncaught mysqli_sql_exception Table ‘wp_options’ doesn’t exist in wp-includes/wp-db.php:2056)
  6. Uncaught Error: Call to undefined function mysql_connect() – WordPress installation
  7. Connect to MySQL using Windows Authentication
  8. Setting up WordPress Locally on WAMP for a new site (with one already)
  9. WordPress fails to install with “Can’t Select Database” Error (WAMPServer)
  10. Running WordPress from MySQL Cluster with HAPRoxy
  11. Cannot add or update a child row: a foreign key constraint fails
  12. Cannot delete or update a parent row: a foreign key constraint fails
  13. ERROR 2003 (HY000): Can’t connect to MySQL server on localhost (10061)
  14. Rename a column in MySQL
  15. Not unique table/alias
  16. Install mysql-python (Windows)
  17. #1055 – Expression of SELECT list is not in GROUP BY clause and contains nonaggregated column this is incompatible with sql_mode=only_full_group_by
  18. Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
  19. Select from multiple tables without a join?
  20. Disable ONLY_FULL_GROUP_BY
  21. MySQL WHERE IN ()
  22. SELECT list is not in GROUP BY clause and contains nonaggregated column …. incompatible with sql_mode=only_full_group_by
  23. Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server
  24. difference between primary key and unique key
  25. How to export a mysql database using Command Prompt?
  26. MySQL AS keyword
  27. Should I use the datetime or timestamp data type in MySQL?
  28. MySQL Error #1133 – Can’t find any matching row in the user table
  29. How can I prevent SQL injection in PHP?
  30. Best way to store an array in MySQL database?
  31. Unknown Column In Where Clause
  32. Cannot connect to Database server (mysql workbench)
  33. mysqld: Can’t change dir to data. Server doesn’t start
  34. How to solve “Error: MySQL shutdown unexpectedly”?
  35. Python official installer missing python27.dll
  36. Can you do a For Each Row loop using MySQL?
  37. Drop all databases in MySQL
  38. CAST to DECIMAL in MySQL
  39. How to properly create composite primary keys – MYSQL
  40. MySQL – count total number of rows in php
  41. How to get the count of each distinct value in a column?
  42. Data is not constantly loading from custom wordpress table
  43. How to run WordPress across 2 VMs for high availability
  44. Mysqldump add drop table?
  45. How to disable `SQL_CALC_FOUND_ROWS` [duplicate]
  46. “#1067 – Invalid default value for ‘post_date'” when trying to reset AI after backup
  47. #1115 – Unknown character set: ‘utf8mb4’
  48. Trying to install WordPress on WSL Windows 10, and running into issues with wp-cli and “wp db create”
  49. WordPress Deadlock Error
  50. How to do a MySQL dump from production site without using a search and replace script for local development?
  51. How to bulk edit canonical url’s in SQL?
  52. Concurrent / simultaneous MySQL connections
  53. How to check for empty and not a failure
  54. Database: Custom table: sprintf value for DateTime column
  55. How many ‘wp_insert_post’ calls can be performed in one shot, in a very long ‘for’ loop?
  56. Keeping database within limits, please help!
  57. Best settings for MySQL to speed up site? [closed]
  58. HTML Entities in Post Title
  59. Can’t find my wordpress DB in phpmyadmin
  60. Deprecated: mysql_connect():
  61. $wpdb select all meta for each post
  62. Calculate average crossing post categories
  63. Replacing link URL ending strings via MySQL
  64. Many slow queries post_type = ‘attachment’;
  65. SQL command to convert all tags in lowercase?
  66. Problem with admin login after deployment
  67. Find out how many times the user has logged in
  68. Is it possible to create a WordPress table using array and loop?
  69. Can’t run database query
  70. WordPress doesn’t display accents after migration
  71. How to stop $wpdb from prepending database name
  72. Match tag names with form titles
  73. Error missing MySQL extension
  74. Getting Error Trying to Create Table
  75. Best approach for a custom database filling in WP custom post types
  76. Why doesn’t custom mysql query return results? Is syntax correct?
  77. $wpdb->get_var multiple queries in one database check
  78. Insert two row in wordpress database
  79. SQL statement using placeholder is not returning results
  80. How to Bulk find and replace MySQL for post image url
  81. Mysql Server keeps crashing
  82. Wpdb query with dynamic table name
  83. Regular XML-RPC timeouts
  84. update multiple rows in mysqli table base on two values
  85. Error Connecting to Database WHEN Installing WordPress on XAMPP [Tried All the Usual Stuff] (Pics Included)
  86. How can I verify WordPress nonce from the following code?
  87. How to write in MySQL more characters in user_nicename
  88. $wpdb->get_var not returning count
  89. Custom user query – orderby meta_key (that may not exist)
  90. How to get Attachments(image) with specific width\height ratio
  91. What is the cron doing?
  92. Apache Redirect based on WordPress permissions
  93. SQL error on restoring database
  94. MySQL database gives blank page (white screen of death)
  95. Datatabase error: Commands out of sync
  96. optimise SQL wordpress call
  97. why is $wpdb->update() causing a DB error from within wp_set_password()
  98. Global MySQL replacing of text patterns/matches
  99. InnoDB: Error: log file ./ib_logfile0 is of different size
  100. Postgres equivalent to MySQL’s \G?

Leave a Comment