Use the instructions for resetting the root password – but instead of resetting the root password, we’ll going to forcefully INSERT a record into the mysql.user table
In the init file, use this instead
INSERT INTO mysql.user (Host, User, Password) VALUES ('%', 'root', password('YOURPASSWORD')); GRANT ALL ON *.* TO 'root'@'%' WITH GRANT OPTION;
Related Posts:
- Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
- Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
- String concatenation in MySQL
- MySQL root password change
- Authentication plugin ‘caching_sha2_password’ cannot be loaded
- Create a new database with MySQL Workbench
- MySQL error code: 1175 during UPDATE in MySQL Workbench
- Cannot connect to Database server (mysql workbench)
- Is there a naming convention for MySQL?
- How to unblock with mysqladmin flush hosts
- MySQL Error: : ‘Access denied for user ‘root’@’localhost’
- ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
- What’s the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN? [duplicate]
- MySQL server startup error ‘The server quit without updating PID file’
- How do I restore a dump file from mysqldump?
- SQL – Update multiple records in one query
- Disable ONLY_FULL_GROUP_BY
- Column ‘user_id’ in field list is ambiguous
- Database sharding vs partitioning
- 1052: Column ‘id’ in field list is ambiguous
- Escape string Python for MySQL
- 1052: Column ‘id’ in field list is ambiguous
- how to overcome ERROR 1045 (28000): Access denied for user ‘ODBC’@’localhost’ (using password: NO) permanently
- SQL ZOO List each continent and the name of the country that comes first alphabetically
- MySQL Error #1133 – Can’t find any matching row in the user table
- How can I prevent SQL injection in PHP?
- Fatal error: Please read “Security” section of the manual to find out how to run mysqld as root
- Can’t connect to MySQL server on ‘127.0.0.1’ (61) on Mac
- ERROR 1044 (42000): Access denied for user ”@’localhost’ to database ‘db’
- How to install Python MySQLdb module using pip?
- Access denied for user ‘root’@’localhost’ (using password: YES) after new installation on Ubuntu
- MySQL Workbench Dark Theme
- Dump all tables in CSV format using ‘mysqldump’
- How to check if mysql database exists
- How to do a batch insert in MySQL
- mysqlworkbench giving version error on exporting database
- If variable equals value php [duplicate]
- MySQL: Cloning a MySQL database on the same MySql instance
- mysqldump data only
- PHP date() format when inserting into datetime in MySQL
- WordPress mysqli and PDO
- MySQL Replication Latency Issues in wp-admin pages
- Alternative to mysql_real_escape_string
- Same option_id=0 for 2 options in wp_options?
- How to let a user choose an authors and save it to the database?
- How to remove ‘GROUP BY’ from SQL query produced from get_posts?
- MySQL LIKE not working
- Importing MariaDB into Mysql in WordPress
- Is a MySQL DATETIME or TIMESTAMP value retrieved through $wpdb in UTC?
- Converting mysql to $wpdb
- Update a WordPress post or page takes 60+ seconds
- Join new table with SQL query
- 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)
- MySQL crashed because of the large number of requests
- Why doesn’t this code add a table to my database?
- SQL database export-import
- add_post_meta does not respect the content
- Can Someone Help Me Fix This WordPress Missing Argument Error?
- How do I get create a custom table showing the hours remaining for all customers in one page from this transactions page?
- Uncaught Error: Call to undefined function mysql_connect() – WordPress installation
- SQL Database, repeated tables?
- Visual/Text Editor displays blank pages in WP-Admin- but HTML on client side displays correctly
- Code to remove authors with no posts connected to them
- SQL Query in WordPress – Getting Impossible WHERE error
- WordPress create database not working
- database optimization and server errors
- Setting up WordPress Locally on WAMP for a new site (with one already)
- Will reducing mysql permissions hinder WP function? [duplicate]
- Calling mysql_query() on another database, assumes WordPress using that database
- WordPress VIP realpath Alternative?
- querying user bookmarks from a large number of bookmarks
- Pull post name from value of a specific meta key
- PHP variables in mysql query
- Php Mysql Terms
- How to fix the amount of comments displayed for each post?
- How do I echo all users’ display_name and their meta_value who have a certain meta_key?
- How to simulate web traffic to test performance of a website
- SQL query to change custom field in WordPress database
- SQL. Select category descendants
- MySQL Actibity without any active visitors via Google Analytics
- How to configure WordPress Database for CentOS 7
- Why should be SQL keywords, like CREATE TABLE and UPDATE, must be uppercase in WordPress?
- Why is local wordpress install calling live site executions?
- Display MySQL as part of a Page
- Migration of wordpress database from mariadb 10.0.20 to 5.5.50
- WP Meta Query – mixed AND / OR query doesn’t work
- get_results() query not working only when entering strings
- Add value to array in database
- Second completely independent and disposable WordPress installation in subdirectory?
- Making CURDATE() recognize current_time()
- get_results suddenly not working on a single table
- Internal error (500) on local & Fatal error on live when trying to access post type edit screen
- Query sql for truncate post_content in wp_posts table
- How should I troubleshoot a database serialization issue with a WordPress migration
- Foreach only outputs if id is 0
- “Error 1064” when importing msql database after updating wordpress version to 4.2.1
- remove wordpress post links
- SQL get last entry of a specific gravity form
- mysqldump to a tar.gz
- Where is my mysql log on OS X?