Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [mysql8]

49 questions
11
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
  • 253
  • 1
  • 2
  • 9
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
  • 557
  • 6
  • 21
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
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
  • 153
  • 3
  • 7
3
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,545
  • 4
  • 22
  • 36
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
  • 557
  • 6
  • 21
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,102
  • 2
  • 25
  • 58
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
  • 5
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
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
  • 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
  • 409
  • 4
  • 12
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
0 answers

Multiple MySQL instances one server through systemd - cannot connect client

I am using MySQL 8.0.33 Following the official documentation, I set up multiple instances of mysql using systemd. My cnf file is below. I am able to get all the instances up and running at the same time, systemctl status shows each of them with its…
Fred Polli
  • 11
  • 2
1
vote
1 answer

mariadb-client cannot connect to db throwing "RSA Encryption not supported"

I have a docker-compose with a 'db' and 'web' containers. The db is a mysql:8.0 image, and the web is a python:3.9-slim. If I try to connect to the MySQL server inside the db container, it works. But not if I try it inside the web container, from…
Amat Martinez
  • 13
  • 1
  • 4
1
2 3 4