How to grant all privileges to root user in MySQL 8.0

by

Starting with MySQL 8 you no longer can (implicitly) create a user using the GRANT command. Use CREATE USER instead, followed by the GRANT statement:

mysql> CREATE USER 'root'@'%' IDENTIFIED BY 'PASSWORD';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;

Caution about the security risks about WITH GRANT OPTION, see:

More Related Contents:

  1. How can I fix MySQL error #1064?
  2. How do you use the “WITH” clause in MySQL?
  3. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  4. How to delete from multiple tables in MySQL?
  5. Why does MySQL report a syntax error on FULL OUTER JOIN?
  6. Error creating table: You have an error in your SQL syntax near ‘order( order_id INT UNSIGNED NOT NULL AUTO_INCREMENT, user_id ‘ at line 1 [duplicate]
  7. phpMyAdmin on MySQL 8.0 [duplicate]
  8. Node.js can’t authenticate to MySQL 8.0
  9. MySQL search json value by key in array
  10. apache mysql – “packets out of order” on 3306
  11. In MySQL SERVER 8.0 the PASSWORD function not working
  12. How do I specify unique constraint for multiple columns in MySQL?
  13. Select all columns except one in MySQL?
  14. MYSQL OR vs IN performance
  15. ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
  16. MySQL Conditional Insert
  17. How to properly create composite primary keys – MYSQL
  18. Is there a MySQL option/feature to track history of changes to records?
  19. MySQL JOIN ON vs USING?
  20. How to store IPv6-compatible address in a relational database
  21. How to change the foreign key referential action? (behavior)
  22. Select data between a date/time range
  23. Docker (Apple Silicon/M1 Preview) MySQL “no matching manifest for linux/arm64/v8 in the manifest list entries”
  24. What is the difference between BIT and TINYINT in MySQL?
  25. MySQL Pivot Table Column Data as Rows
  26. updating columns with a sequence number mysql
  27. How repair corrupt xampp ‘mysql.user’ table?
  28. How to only select numeric data from mysql?
  29. What is the MySQL query equivalent of PHP strip_tags?
  30. Select all months within given date span, including the ones with 0 values

Leave a Comment