Questions tagged [mysql8]
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
51
questions
0
votes
0
answers
55
views
MySQL 8.4 out of memory [migrated]
We have an instance of MySQL 8.4 running on Windows Server 2022. It ran fine for 12 days, but suddenly it is consuming a lot of memory. I've deducted this from the Windows Event log and the MySQL ...
- 11
0
votes
1
answer
2k
views
How can I disable SSL (TLS) in MySQL 8.0.36+?
If I use tls-version='' in the config file, I'm getting the following warnings in the log:
[Warning] [MY-013595] [Server] Failed to initialize TLS for channel: mysql_main. See below for the ...
- 292
0
votes
2
answers
62
views
Connect remote MySQL Client to MySQL Server
I can connect locally but not remotely.
On my client I have:
mysql Ver 8.0.35-0ubuntu0.22.04.1 for Linux on x86_64 ((Ubuntu))
On my server I have:
mysql Ver 8.2.0 for Linux on x86_64 (MySQL ...
- 101
0
votes
2
answers
116
views
MySQL Client taking more than 14 sec to be connected
IN our on-prem server we have installed mysql 4 node cluster 2 for mgmt and 2 for datanode. All are physical server with 1TB ram and 64 core processor. When a user trying to connect to mysql server ...
- 21
0
votes
0
answers
129
views
How can I fix this Mysql login?
I have installed MYSQL community edition on Windows server, I also added the Environment variable to execute the mysql command.
The scenario is: When I try to connect to mysql using the CMD I get the ...
- 71
1
vote
1
answer
104
views
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 ...
- 113
-1
votes
1
answer
872
views
Mysql server eating all RAM (100GB) when load is running
I am using Mysql - Server version: 8.0.29 MySQL Community Server - GPL
My server has 100GB RAM.
Of it I allocated innodb_buffer_pool_size as 90 GB
SET GLOBAL innodb_buffer_pool_size = 96636764160;
I ...
- 103
1
vote
0
answers
350
views
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 ...
- 11
0
votes
1
answer
679
views
MySQL client 8.0 showing "fwrite: Broken pipe" on large query when using a pager
I have always been using a pager (--pager="less -SFX" to be more specific) for MySQL client. Previously I was on version 5.6 of MySQL client/server and it was doing great. Recently I ...
- 59
0
votes
0
answers
164
views
My GCP MySQL 8 CloudSQL Database, Randomly Restarts without a clue
I using a mysql instance on cloud sql. However this instances began to restart the mysqld (mysql deamon) several times per day.
It was not due a change or anything, but just increasing like this.
...
google-cloud-platform
0
votes
1
answer
1k
views
mysql8: mysql tables corrupted, but mysqlcheck tells they are OK
I run mysql in Ubuntu 20.04 under wsl2.
Today, when I started windows, it started in recovery mode "Recovery: It looks Windows hasn't loaded properly...", like it does time to time. After ...
- 101
0
votes
1
answer
312
views
Enable mysqlx plugin on AWS RDS
Is there any way to enable the mysqlx plugin on an AWS RDS running MySQL 8?
When I do a SHOW plugins, it shows that the mysqlx plugin is installed, but DISABLED.
I have some C++ code that's using the ...
- 111
0
votes
0
answers
872
views
MySQL 8 won't autostart at boot on Ubuntu 20.04: Can't start server: Bind on TCP/IP port: Cannot assign requested address
I've a fully up-to-date Ubuntu 20.04 with MySQL 8.0.30 provided by mysql.com.
MySQL is set to autostart at system boot (systemctl enable mysql).
Lately I've a problem when I restart the server: MySQL ...
2
votes
1
answer
2k
views
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 ...
1
vote
1
answer
4k
views
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 ...
0
votes
1
answer
1k
views
Fortify Software Security Center 21.2.0 Unable process the Fortify_Process_Seed_Bundle-2021_Q4_0001.zip during initial setup
I am trying to set up Fortify SSC 21.2.0 for a demo, and I am
having a bit of trouble getting the database seeded.
The following describes my set-up specifications and
my progress so far. Apparently ...
- 121
1
vote
1
answer
6k
views
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. ...
- 11
4
votes
2
answers
7k
views
'--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 ...
- 608
0
votes
0
answers
40
views
Can log any user to mysql database
I have mysql database 'politechnika_new' and user 'politechnika' with all privilages for this daabase, and host set as %, but I can't login to this database with this user.
How Can i fix it?
root@...
- 101
1
vote
0
answers
2k
views
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
...
- 111
1
vote
0
answers
987
views
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 ...
- 33
0
votes
1
answer
1k
views
MySQL 8 - connecting to server with different port [closed]
I have MySQL 8 on Debian 9 vps, and my problem that I can connect to server from php Adminer (web) with any port I've chosen:
localhost:3307, 33650, any port.
And php Adminer showing - MySQL » ...
- 111
2
votes
1
answer
3k
views
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 ...
0
votes
0
answers
1k
views
Optimizing the configuration with MySQL 8 / InnoDB on a high-end server
I am new to InnoDB and database performance/tweaking.
I am running five websites and estimate about 5k to 10k concurrent users (within a 3 min timeframe).
Hardware of my new server:
32 CPUs AMD
128 GB ...
- 149
0
votes
0
answers
3k
views
Mysql keyring_file not loading
I am trying to encrypt some tables in a mysql database. I found a way in Mysql documentation (https://dev.mysql.com/doc/refman/8.0/en/innodb-data-encryption.html)
I have added the following lines ...
- 101
3
votes
0
answers
5k
views
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] [...
- 163
1
vote
1
answer
2k
views
How do I deal with MySql incompatibility (8 -> 5)
Recently, we updated one system to UBUNTU 20.04 (it has been way backlevel). The new installation includes MySQL at version 8.
One of the functions we've been performing on the retiring system, is to ...
- 188
0
votes
1
answer
1k
views
How To Get Remote MySql Access On AWS Ec2
I have a setup in ec2 where i have 2 servers, one just hosts mysql while the other houses the software. I need the software server to have remote mysql access to the mysql server, ideally wanting it ...
- 113
3
votes
1
answer
20k
views
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 ...
- 1,695
1
vote
0
answers
443
views
MySQL max_execution_time not working
We have a general problem with MySQL 8 running on Windows 2019.
We see queries running forever and the CPU is 100%, the system becomes unresponsive.
While we know this needs a better investigation to ...
- 41
1
vote
0
answers
2k
views
MySQL Ubuntu doesn't start anymore after disk storage was full
MySQL Version: Ver 8.0.22-0ubuntu0.20.04.2 for Linux on x86_64 ((Ubuntu))
Today I encountered that my MySQL stopped running, all my websites are offline.
When I try to run manually I get the following ...
0
votes
4
answers
637
views
Is there any major performance issue if you switch default-storage-engine setting from InnoDB to MyISAM?
Recently we upgraded version of MySQL on the database server, Almost all of our tables are in MyISAM but in my.ini we have set
--default-storage-engine=InnoDB
But now we want to change this setting ...
- 225
2
votes
2
answers
7k
views
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% ...
- 119
12
votes
2
answers
54k
views
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-...
- 263
5
votes
1
answer
6k
views
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 ...
- 105
0
votes
1
answer
304
views
Get rid of debian-sys-maint instead of root in MySQL 8
We've recently upgraded from MySQL Percona 5.7 to 8 and we're in the phase of transitioning from mysql_native_password to caching_sha2_password.
As far as I understand, the only way to upgrade the ...
- 1,193
0
votes
2
answers
3k
views
MySQL 8.0.20 via SSH
DBeaver 7.1.0 on Windows 10 trying to connect to MySQL 8.0.20 on Ubuntu 20.04 using SSH.
I also tried other Windows MySQL GUI clients, with the identical results, which leads me to believe the problem ...
- 1
0
votes
1
answer
394
views
MySQL 8.0 replica going out of sync with error on executing statements
I have this configuration:
Master running MySQL 5.5 with log file format: STATEMENT
Slave running MySQL 8.0 - connected to (1) master. Log file format: ROW
Another Slave running MySQL 8.0 - connected ...
- 167
1
vote
0
answers
2k
views
how to disable SSL for samhain when connecting to a mysql database?
I have just compiled samhain from source and I added database connection credentials to the samhainrc file. For some reason, samhain will not write any entries to the mysql database.
The db ...
- 585
-1
votes
1
answer
65
views
MySQL 8 unusual behavior
The project that I'm working on using database frequently and does heavy procedures.
I'm always monitoring the system. with 16GB of RAM and 8 CPU's system usually works fine and not reaching it's ...
- 99
3
votes
0
answers
795
views
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 ...
- 608
0
votes
1
answer
2k
views
MySQL crashes after upgrade to mysql 8
After we upgraded our database to MySQL 8, one query stopped working and is causing the database to crash.
MySQL version 8.0.19, before: 5.7
Error.log output:
Trying to get some variables.
Some ...
- 1
0
votes
1
answer
223
views
Is it possible to interchange Azure Database for MySQL between general-purpose and memory-optimised?
I have one instance of Azure Database for MySQL. The current configuration of the instance is "Gen5 - General Purpose - 2 vCore - 10GBMem". I would like to scale it to "Gen5 - Memory Optimised - 2 ...
- 163
1
vote
0
answers
2k
views
mysql 8 only creating single log file instead of 2 (ib_logfile0)
I am having an issue with one of my mysql servers that has to do with the innodb logfiles. Even though it is configured to have 2 logfiles as normal, when I start up the server it only creates one of ...
0
votes
1
answer
948
views
How do I grant or alter an existing user to allow remote authentication in MySQL 8?
The ultimate goal is to have the latest Zabbix release running in container, monitoring a bunch of switches.
Zabbix wants some flavor of MySQL (or postgres) so I figured I would set use the official (...
- 959
2
votes
3
answers
4k
views
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:
...
- 1,204
1
vote
1
answer
1k
views
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 ...
- 111
0
votes
0
answers
689
views
Not able to connect MySQL server using new administrator account
I created a new administrator account when I upgraded to MySQL server 8.0.15 in windows 10.
However, I am not able to log into the server using mysql -u root -p. So, I tried using the newly created ...
0
votes
1
answer
1k
views
InnoDB Cluster - MySQL 8.0.13 upgrade to 8.0.14 on Ubuntu 18.04.1 LTS - Cluster creation fails
With the recent upgrade of MySQL from 8.0.13 to 8.0.14 on Ubuntu 18.04.1 LTS, I started getting an error by the time I issue the dba.createCluster('mycluster') after following the procedure to create ...
- 3
1
vote
1
answer
522
views
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 ...
- 429