MySQL is an open-source relational database management system (RDBMS). MySQL 8.0 was released on April 8, 2018. Version 8.0 will reach end of life on April 30, 2025, and version 8.4 will reach end of life on April 30, 2029. Versions 8.1 through 8.3 are end of life. https://endoflife.date/mysql
Questions tagged [mysql8]
53 questions
12
votes
2 answers
Install MySQLDump for MySQL 8.0 on Ubuntu 18.04
I am trying to install mysqldump on a Azure hosted Ubuntu VM.
During the build process I attempt the following command:
sudo apt-get update
sudo apt-get install -y --no-install-recommends mysql-client-8.0
This results in the following error:
Unable…
JimmyBanks
- 263
6
votes
1 answer
MySQL 8 undo log not truncating after excessive growth
Apparently I started a SELECT query 20 days ago that never finished. It kept running even though the client had disconnected, and ran for so long that one of the undo logs grew to 230 gb in size. (The database in question is 320 gb of data). I've…
ErikPerik
- 115
- 1
- 8
4
votes
2 answers
'--ssl=off' Error in Mysql 8.0.26 service startup
I'm seeing an odd error in the mysqld.service status notes...
The syntax '--ssl=off' is deprecated and will be removed in a future release. Please use --tls-version=invalid instead.
The thing is I've disabled SSL using skip_ssl in the /etc/my.cnf…
oucil
- 718
- 1
- 7
- 23
4
votes
1 answer
How to skip-name-resolve in Mysql8 and use IPs instead?
I'm trying to disable the DNS name resolving as I have many other servers connecting to the central database. The DNS resolving is slow and can apparently be disabled like this:
[mysqld]
pid-file = /var/run/mysqld/mysqld.pid
socket =…
Houman
- 1,735
3
votes
0 answers
MySQL 8 InnoDB taking a long time to start
I upgrade some month ago from Ubuntu 18.04 to 20.04.
So MySQL upgrade from 5.7.33 to 8.0.23.
I notice after the upgrade that MySQL is slow to start.
2021-02-24T09:20:16.972632Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user
Inglebard
- 163
3
votes
2 answers
High memory usage on digital ocean droplet by mysql 8
I have a laravel application which I've installed on a 1GB standard droplet running ubuntu 20.4, nginx, MySQL 8 and php 7.4
The application isn't even live yet and I notice it's already using over 60% memory - 68%
Below is a snap shot of the current…
adam78
- 129
3
votes
0 answers
mysqlx reported: failed at ssl configuration
I have MySQL 8 with the mysqlx plugin enabled running on a standalone server that will never allow access to 3306 from outside the instance and have no worries about security within the instance.
I do not want the overhead of SSL connections for…
oucil
- 718
- 1
- 7
- 23
2
votes
3 answers
Reset root admin password in mysql 8
I'm trying to work out how to reset the root mySQL users password. I've found:
https://www.tecmint.com/reset-root-password-in-mysql-8/
I tried the first option, and at first it appears to work:
root@admin:~# cat /tmp/init-file.txt
ALTER USER…
Andrew Newby
- 1,224
2
votes
1 answer
MySQL Errors / Corruption after updating WordPress
Yesterday I updated my Wordpress website to the latest version of WordPress (6.0), and I updated several other plugins to their latest versions. After the updates everything appeared to be working fine, so I disabled my maintenance page. Several…
2
votes
1 answer
Why ubuntu 20.04 cannot support mysql 5.7.33?
Today I tried to update ubuntu from 18.04 LTS to 20.04 LTS.
with do-release-uprade
After upgrade completed, I tried to start mysql with service mysql start
The result is
Job for mysql.service failed because the control process exited with error…
1
vote
1 answer
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…
gamaverse
- 111
- 4
1
vote
1 answer
Can't connect Postfix to AWS MySQL RDS over SSL SSL_CTX_set_default_verify_paths
I'm trying to set up a mail server with Postfix (3.3.0) with virtual domains, queried against an Amazon RDS MySQL (8.0.11) instance, with SSL between the mail server and the RDS instance.
I'm just at the very beginning of setting this up, so haven't…
philolegein
- 449
1
vote
1 answer
Output of mysqldump all-databases failed to run in MySQL 8.0 because of dropping the 'mysql' database
Problem statement
mysqldump --add-drop-database --all-database
creates a dump that contains
....
/*!40000 DROP DATABASE IF EXISTS `mysql`*/;
....
This is expected and I believe is a correct behavior.
Yet, if cat'ing this dump into a mysql server,…
HelloSam
- 171
- 1
- 7
1
vote
1 answer
Connection test to remote MySQL fails: what can I try further?
MySQL runs on remote Windows VM.
VM is up and running, mysqld.exe too.
MySQL is while installation activated for TCP/IP access.
Port 3306 is in my.ini and in connectivity settings of MySQL.
Firewall opened while installation and freed in…
Evgeniy
- 265
1
vote
1 answer
Postfix Dovecot connection with MySQL8 SSL mode disabled
I have a production running installation of Postfix 3.1 and Dovecot. Recently upgraded to a new version of MySQL, passing from 5.6 to 8 hosted in a new server.
The problem now is that postfix and dovecot services can't connect to MySQL8 due to…
Sergi
- 113