Top "Mysql-8.0" questions

This tag is for questions related to the MySQL database, version 8.0.

Authentication plugin 'caching_sha2_password' cannot be loaded

I am connecting MySQL - 8.0 with MySQL Workbench and getting the below error: Authentication plugin 'caching_sha2_password' cannot be …

mysql database mysql-workbench mysql-8.0
How to grant all privileges to root user in MySQL 8.0

Tried mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION; Getting ERROR 1064 (42000): You …

mysql mysql-error-1064 mysql-8.0
How do you use the "WITH" clause in MySQL?

I am converting all my SQL Server queries to MySQL and my queries that have WITH in them are all …

mysql common-table-expression with-clause subquery-factoring mysql-8.0
PHP with MySQL 8.0+ error: The server requested authentication method unknown to the client

I'm running MySQL version 8 on PHP 7.0. I'm getting the following error when I try to connect to my database from …

php mysql mysql-8.0
phpMyAdmin on MySQL 8.0

UPDATE Newer versions of phpMyAdmin solved this issue. I've successfully tested with phpMyAdmin 5.0.1 I have installed the MySQL 8.0 server and …

mysql phpmyadmin database-connection mysql-8.0
Mysql 8 remote access

I usualy setup correctly MySQL for having remote access. And currently I got stuck with MySQL 8. The first thing is …

mysql authentication mysql-8.0
How to disable column-statistics in MySQL 8 permanently?

Since MySQL 8 the column-statistics flag is enabled by default. So if you try to dump some tables with MySQL Workbench 8.0.12, …

mysql mysql-workbench mysql-8.0
Node.js can't authenticate to MySQL 8.0

I have a Node.js program that connects to a local MySQL database with the root account (this is not …

mysql node.js authentication mysql-8.0
Homebrew, MySQL 8 support

Anyone have the inside scoop on when Homebrew will be updated to support MySQL 8's first general release (8.0.11)? I can't …

mysql version-control homebrew mysql-5.7 mysql-8.0
How to fix "mbind: Operation not permitted" in mysql error log

I have a problem with my MySQL error log which currently mostly consists of "mbind: Operation not permitted" lines (see …

docker nginx ubuntu-18.04 mysql-8.0