Questions tagged [mysql8]
45 questions
7
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
- 203
- 1
- 2
- 7
4
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
- 95
- 1
- 8
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,041
- 1
- 22
- 48
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…
JackJohnstone53
- 23
- 4
2
votes
1 answer
'--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
- 445
- 3
- 16
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…
Tron Natthakorn
- 21
- 3
2
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
- 119
- 1
- 3
2
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
- 445
- 3
- 16
1
vote
0 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
- 111
- 3
1
vote
0 answers
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
- 369
- 3
- 9
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
- 6
1
vote
1 answer
MySql 8 crashing on loop without specific errors and with enough memory
I'm running Ubuntu 20.04.03 with Mysql 8.0.27.
I have reinstalled LAMP from scratch several times and at the moment I only have 3 WordPress sites but I have tested only 1 and only 2 sites as well. Increased the RAM to 2GB and 3GB Swap.
Nothing seems…
gallo2000sv
- 11
- 2
1
vote
0 answers
Unable to connect to MySQL through port 3306 Windows Server 2012 R2
It looks like weird happening, I've followed and fixed all the possible things but still MySQL port 3306 is not accessible remotely.
Here's my setup:
Machine: Windows Server 2012 R2
MySQL Server: 8.xx
Settings have been applied:
In my.ini…
Code Cooker
- 111
- 2
1
vote
0 answers
Alternate method for caching mysql query (query_cache) on version above 8.0
On mysql version 8+ the query_cache support was removed.
I know why it is not a friendly thing with InnoDB when considering the CPU.
But I've some databases which really need this support where user repeat the same query in most cases.
Is it…
TELA
- 33
- 5
1
vote
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
- 133
- 1
- 7