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. MariaDB version not recognised
  12. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  13. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  14. How to use mysqli_query() in PHP?
  15. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  16. Tensorflow import error: No module named ‘tensorflow’
  17. How can I install pip on Windows?
  18. How to log in to phpMyAdmin with WAMP, what is the username and password?
  19. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  20. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  21. Column count doesn’t match value count at row 1
  22. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  23. MySQL string replace
  24. Cannot add or update a child row: a foreign key constraint fails
  25. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  26. How do I install and use cURL on Windows?
  27. String concatenation in MySQL
  28. What’s the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN? [duplicate]
  29. Can’t connect to MySQL server on ‘localhost’ (10061) after Installation
  30. Cannot add or update a child row: a foreign key constraint fails
  31. MySQL Error “Operand should contain 1 column”
  32. Can’t connect to MySQL server on ‘localhost’ (10061) after Installation
  33. How to use MySQL DECIMAL?
  34. Access denied for user ‘root@localhost’ (using password:NO)
  35. Can’t connect to local MySQL server through socket ‘/var/mysql/mysql.sock’ (38)
  36. How to make MySQL table primary key auto increment with some prefix
  37. Access denied for user ‘root@localhost’ (using password:NO)
  38. MySQL ERROR 1290 (HY000) –secure-file-priv option
  39. How to install MinGW 64 on windows 10
  40. MySQL error 2006: mysql server has gone away
  41. Which MySQL data type to use for storing boolean values
  42. sql query with multiple where statements
  43. ERROR 2003 (HY000): Can’t connect to MySQL server on localhost (10061)
  44. ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
  45. Cannot delete or update a parent row: a foreign key constraint fails
  46. Cannot delete or update a parent row: a foreign key constraint fails
  47. ERROR 2003 (HY000): Can’t connect to MySQL server on localhost (10061)
  48. MySQL server startup error ‘The server quit without updating PID file’
  49. Rename a column in MySQL
  50. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  51. Cannot delete or update a parent row: a foreign key constraint fails
  52. MySQL server startup error ‘The server quit without updating PID file’
  53. How do I restore a dump file from mysqldump?
  54. Syntax error due to using a reserved word as a table or column name in MySQL
  55. ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
  56. MySQL root password change
  57. Installation of MySQL for Visual Studio 1.2.8 failed
  58. Not unique table/alias
  59. How do I import an SQL file using the command line in MySQL?
  60. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  61. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  62. MySQL ERROR 1045 (28000): Access denied for user ‘bill’@’localhost’ (using password: YES)
  63. Your password does not satisfy the current policy requirements
  64. How do I quickly rename a MySQL database (change schema name)?
  65. What does SQL Select symbol || mean?
  66. Install mysql-python (Windows)
  67. MySQL: Access denied for user ‘test’@’localhost’ (using password: YES) except root user
  68. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  69. SQL – Update multiple records in one query
  70. Mysql: Setup the format of DATETIME to ‘DD-MM-YYYY HH:MM:SS’ when creating a table
  71. What is the definition of cardinality in SQL
  72. How to restart remote MySQL server running on Ubuntu linux?
  73. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  74. MySQL DROP all tables, ignoring foreign keys
  75. #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
  76. When to use SELECT … FOR UPDATE?
  77. Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server
  78. Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
  79. Setting up foreign keys in phpMyAdmin?
  80. Select from multiple tables without a join?
  81. PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP
  82. ERROR 1396 (HY000): Operation CREATE USER failed for ‘jack’@’localhost’
  83. SQL Query Where Field DOES NOT Contain $x
  84. Create a new database with MySQL Workbench
  85. Duplicating a MySQL table, indices, and data
  86. Disable ONLY_FULL_GROUP_BY
  87. what does “/index.php?admin/admin_dashboard” in my url mean
  88. Column ‘user_id’ in field list is ambiguous
  89. How to join two tables by multiple columns in SQL?
  90. How to get size of mysql database?
  91. mysql Foreign key constraint is incorrectly formed error
  92. Database sharding vs partitioning
  93. Selecting data from two different tables without using joins
  94. MySQL WHERE IN ()
  95. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  96. Is there an SQLite equivalent to MySQL’s DESCRIBE [table]?
  97. ERROR 2003 (HY000): Can’t connect to MySQL server on ‘127.0.0.1’ (111)
  98. SQL – Update multiple records in one query
  99. Difference between VARCHAR and TEXT in MySQL
  100. mysql is not recognised as an internal or external command,operable program or batch

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)