This tag is for questions related to the MySQL database, version 8.0.
MySQL 8.0 is the version of mysql that follows version mysql-5.7.
Important Links:
Questions tagged [mysql-8.0]
916 questions
666
votes
38 answers
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 loaded:
dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image
not found
I have tried with…
Aman Aggarwal
- 17,619
- 9
- 53
- 81
274
votes
24 answers
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 have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax…
Praveen
- 2,740
- 2
- 8
- 8
226
votes
8 answers
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:
Connect Error: SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client
PHP might show this…
mohammed yaser
- 2,291
- 2
- 12
- 16
156
votes
7 answers
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 failing. Here's an example:
WITH t1 AS
(
SELECT article.*, userinfo.*, category.*
FROM question
INNER JOIN userinfo ON…
user161433
- 4,419
- 5
- 32
- 55
100
votes
2 answers
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 below). Why does it happen and how do I fix it?
It's the "mostly" part that bothers me. As you can see below, not all lines are…
gamasexual
- 1,267
- 2
- 8
- 9
84
votes
18 answers
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 phpMyAdmin, but when I try to access it from the browser the following errors occur:
#2054 - The server…
Lucas Noetzold
- 1,670
- 1
- 13
- 29
37
votes
14 answers
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, you get this error message:
14:50:22 Dumping db (table_name)
Running: mysqldump.exe…
Flo Bayer
- 1,190
- 4
- 12
- 25
36
votes
4 answers
In MySQL SERVER 8.0 the PASSWORD function not working
Error while executing the PASSWORD function in MySQL Server version 8.0.12
I have the following query:
SELECT *
FROM users
WHERE login = 'FABIO'
AND pwd = PASSWORD('2018')
LIMIT 0, 50000
I am getting this error:
Error Code: 1064. You have an…
Fabio C
- 489
- 1
- 4
- 11
32
votes
4 answers
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 that on the mysql.conf.d/mysqld.cnf , I don't have any bind-address line, so I added it by hand (bind-address 0.0.0.0)
And I granted…
sHaDeoNeR
- 617
- 2
- 8
- 14
32
votes
5 answers
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 a production setup).
This is the code that creates the connection:
const mysql = require('mysql');
const dbConn = mysql.createConnection({
host:…
Hey
- 1,701
- 5
- 23
- 43
27
votes
8 answers
How to set sql_mode in my.cnf in MySQL 8?
I'm running MySQL 8.0.11 community version. I need to set sql_mode to exclude ONLY_FULL_GROUP_BY in my.cnf so that it's restart safe. I tried the following variants:
sql_mode=…
RayCh
- 571
- 3
- 8
- 17
25
votes
4 answers
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 seem to find it by searching, but I bet someone here knows :)
Pete_1
- 981
- 3
- 14
- 23
24
votes
3 answers
Error Code: 3685. Illegal argument to a regular expression
I am trying to find an exact number in MySQL 8.0 using the below SQL statement
SELECT * FROM rulebook.node__body
WHERE body_value REGEXP "[[:<:]]DVP[[:>:]]";
when i am running the above SQL statement i am getting below error
Error Code: 3685.…
Zahid Hussain
- 981
- 2
- 13
- 28
16
votes
4 answers
docker-compose : The server requested authentication method unknown to the client
I have this yml file for configuration of MySQL in docker:
# Use root/example as user/password credentials
version: '3.1'
services:
db:
image: mysql
restart: always
environment:
MYSQL_ROOT_PASSWORD: 'pass'
…
Navin Gelot
- 1,264
- 3
- 13
- 32
15
votes
5 answers
How to resolve the error: SQL authentication method unknown in Laravel-MySql
I using docker and I have a container of Laravel Framework 5.5.25 and other with mysql Ver 8.0.11 for Linux on x86_64 (MySQL Community Server - GPL). in my configuration of docker compose I have this:
version: "2"
services:
mysql:
image:…
andreszam24
- 351
- 2
- 3
- 12