I had this error as well. I fixed it by running
mysql_upgrade -u root -p
Also, restart the mysql service by running
service mysqld restart
More Related Contents:
- Im trying to create some temporary tables in mysql using php
- the update query just update the last row and affect other with it’s value
- How to insert images into a database using PHP [closed]
- How to apply bindValue method in LIMIT clause?
- How to change mysql to mysqli?
- php mysqli_connect: authentication method unknown to the client [caching_sha2_password]
- MySQLi prepared statements error reporting [duplicate]
- Importing CSV data using PHP/MySQL
- Convert latin1 characters on a UTF8 table into UTF8
- Laravel-5 ‘LIKE’ equivalent (Eloquent)
- Connect to a MySQL server over SSH in PHP
- PDO multiple queries
- Using strtotime for dates before 1970
- How to store NULL values in datetime fields in MySQL?
- Is “SET CHARACTER SET utf8” necessary?
- ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it
- How to convert ISO8601 to Date format in php
- Javascript function post and call php script
- while ($row = mysql_fetch_array($result)) – how many loops are being performed?
- Trying to access array offset on value of type bool
- onbeforeprint() and onafterprint() equivalent for non IE browsers
- How to get a query error from prepare() in PDO PHP?
- Fatal error: Call to a member function query() on null
- MySQL & PHP Parameter 1 as Resource
- MySQL GROUP BY and Fill Empty Rows
- mysql injection damages?
- PHP PDO how to run a multiple query request?
- Backup a mysql database and download as a file
- MYSQL select a piece of a string and order by that piece
- Is a BLOB converted using the current/default charset in MySQL?