Questions tagged [mysql]
Questions regarding the MySQL database server, client and tools.
2,968
questions
0
votes
1
answer
31
views
APT / DPKG Broken After mysql-server-8.0 update on Ubuntu 20.04.5
During monthly patching [security updates only], it updated mysql-server-8.0 from [0/8.0.36/0ubuntu0.20.04.1/X86_64] to mysql-server-8.0[0:8.0.37-0ubuntu0.20.04.3] however as it tries to continue ...
- 21
-3
votes
0
answers
45
views
I need help with the temporary ban code [closed]
actually, I need help implementing a temporary ban. I will provide the path to the .sql database. The first HTML of the admin panel:
``` your text
Админ-панель
Admin-panel
...
- 3
-1
votes
0
answers
34
views
Can't Launch Apache after Installation
I am very new to Ubuntu, I have installed 20.04.4. I have MariaDB 11.4.2 and phpMyAdmin 8.2.12. Control Panel for XAMPP is v3.3.0. The problem developed when I was installing Moodle 4.4 on my ...
1
vote
1
answer
25
views
Using mysqldump on remote Ubuntu 22.04 server in rsnapshot returns code 127 while the very same command used locally works fine
As said in the title, I want to backup my remote MySQL database with rsnapshot, using mysqldump. I don't have any syntax error, but get a:
WARNING command returned 127
and the SQL file is not written....
0
votes
1
answer
22
views
Ubuntu 20.04 Can't set system variables using mysqld with OS errno: 13 - Permission denied
I need to change innodb_buffer_pool_size in a MySQL server running on Ubuntu 20.04. I'm getting Permission denied error on the default data directory /var/lib/mysql/ although mysql is the owner of ...
- 11
0
votes
0
answers
31
views
Ubuntu 22.04 - Mysql crash
I set up a new VPS 10 days ago (Ubuntu 22.04 / 2 CPU / 2 GB RAM), everything was running fine until last night : I found out in the syslog that MySQL had crashed. Here is what I have the logs before ...
-1
votes
0
answers
52
views
Attempting to download MySQL 5.7 on Ubuntu 20.04, the public key for the repository has expired, how can I still download it? [duplicate]
I have been trying to download MySQL 5.7 on a Ubuntu 20.04 server. I specifically need MySQL 5.7 and cannot use a newer version. The public key for http://repo.mysql.com/apt/ubuntu in the bionic ...
0
votes
1
answer
147
views
Random MySQL Server 8 on Ubuntu 20.0.4 - 2 processes trying to run gets stuck on Loading Status
I have been running into this issue now for the last 2 weeks. Our Ubuntu 20.04 server was stable and running without issue until one day it pinged me a 500 error with UpTime Robot monitoring.
When I ...
-1
votes
1
answer
45
views
How to find out persistant SET GLOBAL max_connect_errors value in MySQL
How to find out persistant SET GLOBAL max_connect_errors value in MySQL
SHOW VARIABLES LIKE 'max_connect_errors';
0
votes
0
answers
37
views
Smooth transition of mysql server from Ubuntu 18.04 LTS to 20.04 LTS
This issue is all around the internet (ex.: here, or here) without a definite solution. Last time I tried to upgrade my Ubuntu server and after one day of malfunction, I had to roll back to 18.04 LTS (...
- 1,182
0
votes
0
answers
68
views
Ubuntu 20.04 Skipping acquire of configured file 'mysql-8.4-lts/source/Sources'
Installing Mysql in my ubuntu machine that is 20.04 following this documentation
after downloading the deb package
$ sudo dpkg -i mysql-apt-config_0.8.30-1_all.deb
installed successfully but after
$ ...
- 101
0
votes
0
answers
34
views
Issue with Removing MySQL Server Package
I'm encountering difficulties removing the mysql-server-8.0 package from my server. Every attempt to remove it results in an error indicating that the package is in a very bad inconsistent state. The ...
-1
votes
1
answer
38
views
mysql hangs on dkpg upgrade
Today I ran an upgrade to 24.04 and towards the end of the upgrade it appears MySQL went into running mode and the upgrade never passed mysqld is running as pid X. So I rebooted and fortunately it all ...
- 279
1
vote
1
answer
896
views
How to use apt to install MySQL 8.0.37 on Ubuntu 22.04
A scan detected that MySQL 8.0.36 has risks, but the latest version available for Ubuntu 22.04 is still MySQL 8.0.36. Do I need to manually download and update MySQL to 8.0.37?
https://www.oracle.com/...
- 11
1
vote
1
answer
162
views
Unable to start MYSQL server in Ubuntu 22.04 LTE
I installed MySQL in my ubuntu 22.04 LTE environment but I am unable to get the server started. I am getting a
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/...
- 21