Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [mysql8]

49 questions
0
votes
0 answers

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. every time the instance is restarted we lost near 1…
Daniel Santos
  • 168
  • 1
  • 9
0
votes
1 answer

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 reboot mysql does not start anymore. Everything else seems to…
Tola
  • 101
  • 1
0
votes
1 answer

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 MySQL C++ 8 connector and I want to avoid using…
txtechhelp
  • 101
  • 1
0
votes
0 answers

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 doesn't come up automatically as it used to. The…
Dr. Gianluigi Zane Zanettini
  • 478
  • 7
  • 22
0
votes
1 answer

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 the issue at this point as far as I can tell is…
user61917
  • 121
  • 5
0
votes
0 answers

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@ubuntu:/var/www/html/politechnika# mysql…
Tomasz Filipek
  • 101
  • 1
0
votes
1 answer

MySQL 8 - connecting to server with different port

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 » localhost:33899. And I can manage databases, but this…
noszone
  • 11
  • 3
0
votes
0 answers

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 DDR4 ECC 480 GB NVMe SSD With MySQL 8 and…
Avatar
  • 127
  • 1
  • 1
  • 10
0
votes
0 answers

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 under [mysqld] in my.cnf…
Aneeez
  • 101
  • 2
0
votes
1 answer

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 on the private ip so it's only accessible from…
Glen Elkins
  • 113
  • 2
  • 6
0
votes
4 answers

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 to MyISAM because previously we were using MyISAM…
Vishal
  • 215
  • 2
  • 9
0
votes
1 answer

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 Plugin is with the below query, and if no password…
Tolsadus
  • 1,183
  • 11
  • 23
0
votes
1 answer

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 is with MySQL configuration (or maybe with my…
IgnacV
  • 1
  • 2
0
votes
1 answer

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 to (2) the first slave. Log format: ROW Main…
aviv
  • 167
  • 1
  • 1
  • 9
0
votes
1 answer

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 pointers may be invalid and cause the dump to…
Luke Hol
  • 1
  • 1
1 2
3
4