Questions tagged [mysql]

Questions regarding the MySQL database server, client and tools.

Filter by
Sorted by
Tagged with
0 votes
0 answers
18 views

Installing mysql 5.7 on Ubuntu 20.04. Hopelessly mired in dependency deadlocks

I have a dead machine (really dead) and have its legacy in the form of data backups. I have a new machine and struggle beyond description (going into the third week full time!) trying to transfer ...
magpie's user avatar
  • 1
0 votes
0 answers
69 views

Mysql doesn't start after moving var/lib/mysql

I'm running mysql 8 under Xubuntu 20.04. I needed more space for my database so I moved it using rsync. I then updated /etc/mysql/mysql.conf.d/mysqld.cnf to my new datadir. I then ran sudo systemctl ...
MGibbons's user avatar
0 votes
0 answers
35 views

Can't connect to mysql server on 'public ip address' (10060)

I was following this guide to setup a mysql server on my ubuntu machine (https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-ubuntu-22-04). But when I tried to connect to the ...
david backx's user avatar
0 votes
0 answers
14 views

System is not started due to Mysq server issue

My system is recently upgraded from 16.04 to 18.04. The system is not started. I am connected with the recovery mode. When I tried to empty spaces, I am facing the issue below:
Hayat Bellafkih's user avatar
0 votes
0 answers
34 views

Getting error while configuring dpkg

While trying to execute the command to install mysql, getting below error while executing sudo dpkg --configure -a. Setting up mysql-community-server (5.7.42-1ubuntu18.04) ... AppArmor parser error ...
Vipul's user avatar
  • 1
0 votes
1 answer
28 views

ERROR 2002 (HY000): Can't connect to local MySQL server through socket after removing some packages

So, my Security department requested me to remove some unused packages from a certain Ubuntu machine, as their presence is a security risk in case some intruder get access: /usr/bin/g++ /usr/bin/gcc /...
Roman Rdgz's user avatar
1 vote
1 answer
274 views

MySQL Server 8.0.33 on Ubuntu 20.04 not compatible with UA FIPS enabled

I'm running into an issue on an Ubunutu 20.04 server when upgrading from MySQL Server 8.0.32 to 8.0.33 that's causing the upgrade package to fail, leaving it only partially installed. After many hours ...
Nate's user avatar
  • 11
0 votes
1 answer
42 views

apt: mysql-client and mysql-server not upgraded

since mysql-client and mysql-server got the update to 8.0.33 they are kept back and not upgraded. The following packages have been kept back: mysql-client mysql-server 0 upgraded, 0 newly installed, ...
provil's user avatar
  • 3
0 votes
1 answer
52 views

Unable to use Kmail : akonadi not operational

When i start KMail in Kubuntu 23.04, it says Akonadi personal information manager is not operational. I had recently been setting up mysql for use in amarok. this is what happens when i try to start ...
Tweak's user avatar
  • 1
0 votes
2 answers
170 views

Ubuntu 22.04 -- phpmyadmin error: mysqli extension missing

I can't get phpmyadmin to run, it reports The mysqli extension is missing. I have been running MySQL using MariaDB for a while, through multiple versions of Ubuntu. Currently running 22.04. After ...
jwk's user avatar
  • 1
0 votes
0 answers
178 views

ERROR: Unable to start MySQL server: mysqld got signal 11 ;

when I install mysql-server-8.0 ver. 8.0.33-0ubuntu0.20.04.1 armhf on my Ubuntu 20.04.6 LTS on Raspberrypi4 (8GB ram) the result is the following: sudo apt-get install mysql-server Preconfiguring ...
Nicola Modugno's user avatar
0 votes
0 answers
80 views

error 1045 sqlstate 28000

code: 'ER_ACCESS_DENIED_ERROR', errno: 1045, sqlState: '28000', sqlMessage: "Access denied for user ''@'localhost' (using password: NO)", sql: undefined i have done ...
oritsegbubemi's user avatar
0 votes
1 answer
103 views

Installing mysql-server 8 - stuck at "Renaming removed key_buffer and myisam-recover options (if present)"

I'm trying to install mysql-server on a fresh vagrant box based on Ubuntu 22.04. That's my Vagrantfile. Vagrant.configure("2") do |config| config.vm.box = "ubuntu/jammy64" ...
Vassy's user avatar
  • 1
1 vote
2 answers
412 views

MariaDB killed by OOM Killer every couple days

my MariaDB server is being killed every couple days. × mariadb.service - MariaDB 10.6.12 database server Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled) Active: ...
Johnathan Nguyen's user avatar
0 votes
0 answers
176 views

Fresh Ubuntu 23.04 and MySQL install but can't log into databases

I've installed MySQL many times without a problem but now I cannot seem to log in to the databases. I created the same users as I always have with the same access and I can access the databases ...
DonP's user avatar
  • 346
0 votes
1 answer
42 views

How to promote MySQL replica to primary during failover

In a test environment, I stop a healthy MySQL primary server to simulate a fault and I'm trying to promote the replica to primary. Both servers: run on Ubuntu kinetic with mysql-server 8.0.32-...
jean-christophe manciot's user avatar
0 votes
0 answers
18 views

Problem with connecting with remote database

Hello there I have a question about connecting my website with my database on another server on the same network. My database uses a cluster-based system with MariaDB and my website uses apache2. I ...
daan's user avatar
  • 1
-1 votes
1 answer
64 views

Wordpress Mysql Database File - Ubuntu 20.04

I installed Wordpress on Ubuntu 20.04 using the following link: https://ubuntu.com/tutorials/install-and-configure-wordpress#1-overview Then, I created a website on localhost. Now I need to migrate it ...
alvin77's user avatar
1 vote
0 answers
22 views

Rclone and S3 SPaces: How to remove files older than X from my remote s3 space?

I'm learning to use rclone in order to create backups for my application, I store these backups into my DigitalOcean Space (S3), this is the line I use to backup my sql database. rclone copy "${...
gabogabans's user avatar
1 vote
0 answers
66 views

MySQL "Server is operational"

MySQL server was working fine, than unexpectedly going out, I can not connect to it from WorkBench. #sudo service mysql status ● mysql.service - MySQL Community Server Loaded: loaded (/lib/systemd/...
JJohn's user avatar
  • 11
1 vote
1 answer
46 views

How to limit mariadb logs?

I have a nextcloud server which is using Mariadb for the database, but running into issues due to Mariadb spamming log files (namely: mariadb-bin.0000** in /var/log/mysql. This seems to be due to how ...
RolandiXor's user avatar
  • 51.2k
0 votes
0 answers
36 views

seems like there is a php script that runs on my wsl, but i don't know which

I have an app that I built (using laravel 8), and I run it using sail (docker). the docker/app are located in my WSL2 ubuntu system. For some reason (that is the question here ..), "something&...
yossi's user avatar
  • 131
0 votes
0 answers
65 views

mysql installation error on Ubuntu 22.04

After I installed MySQL-server I got the error: The following packages have unmet dependencies: MySQL-cluster-community-client-core : Depends: mysql-cluster-community-client-plugins (= 8.0.32-...
Rudy99's user avatar
  • 1
0 votes
0 answers
88 views

HTTP ERROR 500 when running to linux server?

I have this PHP code for importing excel to mysql using PhpSpreadsheet in xampp. This code is OK when running in windows environment but if I hosted it to a Linux Server(Ubuntu 22.04) using XAMPP ...
moski's user avatar
  • 1
0 votes
0 answers
28 views

Why do I have a plethora of mysqld instances running? [duplicate]

I am running Ubuntu 22.04, which I recently installed from scratch. I use eclipse, apache2 primarily, browser. For the past few days, eclipse runs out of memory and halts. When investigating, I ...
TheGeeko61's user avatar
0 votes
0 answers
37 views

How to recover user access to Mysql database?

I am working in LAMP(Mysql), I wanted to allow an external ip to connect to the database but it was not possible because Mysql was using MyISAM storage engine, so I tried to change it to InooDB adding ...
Ander Canales Medina's user avatar
0 votes
0 answers
53 views

mysql workbench login error but working on terminal

mysql-workbench is throughing some error but it works in terminal i have installed mysql and set user and password by using sudo codes in Ubuntu. but when i open mysql-workbench, it shows the same ...
Sapna Gupta's user avatar
1 vote
0 answers
37 views

Missing Text in MySQL Workbench Performance Dashboard

I've installed MySQL Workbench on Ubuntu 22.04 following the directions here. I'm able to connect to my database server and run queries just fine. However, when I access the Performance Dashboard, ...
George's user avatar
  • 11
0 votes
0 answers
108 views

Unable to install Percona on Ubunutu 22.04

I've previously had MySQL 8.0 installed but heard that I could get a bit more out of my server with the Percona version. I removed every trace of the previous MySQL install and rebooted before ...
kaPa's user avatar
  • 1
0 votes
2 answers
54 views

How to troubleshoot extremely high load averge (over 550)?

I am Ubuntu 18.04 user, running in OVHCloud Datacenter for 3 years with PHP Application and Mysql server on it. For 2.5 years, everything was ok, but in last 6 months i have strange issuee: Every 4th ...
MaxIT's user avatar
  • 1
0 votes
1 answer
32 views

Uninstall MySQL and perform first time setup

I know this seems like a repeated question but I've tried every other answer and none of them worked. I'm trying to follow this guide in order to create a database for my Minecraft server but before ...
NinetyRalph's user avatar
0 votes
1 answer
43 views

MySQL remote setup

I'll be honest I know nothing about Linux, but for a few weeks I've been setting up my Minecraft server on a virtual machine on the cloud because it's way better than hosting companies, of course you ...
NinetyRalph's user avatar
0 votes
0 answers
69 views

Problem while installing MySQL

Ubuntu 22.04 While installing MySQL this information come up luis@l-System-luisj:~$ sudo apt-get install mysql-server [sudo] password for luis: Reading package lists... Done Building dependency tree.....
Luis Jacinto's user avatar
0 votes
0 answers
164 views

Sqlyog not connected to ubuntu 22.04

Trying connect to mysql database with SQLYOG latest version but got this error message "SSH ERROR: Fatal error network error : connection timed out"
Aram Asatryan's user avatar
0 votes
1 answer
123 views

when i am upgrading from Ubuntu 20.04 LTS to Ubuntu 22.04 LTS. The terminal is showing this error. Please resolve this

You might want to run 'apt --fix-broken install' to correct these. The following packages have unmet dependencies: libmysqlclient21 : Depends: mysql-common (>= 8.0.32-1ubuntu20.04) but 5.8+1.0....
NISHANT GUPTA's user avatar
0 votes
1 answer
390 views

Install mysql 8 along with mysql 5.7 on Ubuntu 22.04

Is there any way to install MySQL 8 along with the already installed MySQL 5.7? I want to run two instances, one for version 8 and one for version 5.7. I have tried this on Windows, it's effortless, ...
Abdullah's user avatar
0 votes
0 answers
251 views

Issue installing mysql in Ubuntu 22.04 LTS

I am new to Ubuntu and I have been trying to install mysql on Ubuntu 22.04 LTS -hosted on a virtualbox but I keep on getting the same message regardless of what I try. I have tried to uninstall mysql ...
Habtamu S's user avatar
0 votes
0 answers
277 views

apache2 oom_killer killed mariadb

Discovered mariadb was down and found this logging in syslog. Apache is running mediawiki and wordpress. Could it be a rogue Wordpress plugin? It looks like apache told linux to kill mariadb - is that ...
Adam's user avatar
  • 1,061
0 votes
0 answers
188 views

How to install mysql5 client in ubuntu 22.04?

I have ubuntu 22.04 and my current mysql client is at version: Ver 8.0.31-0ubuntu0.22.04.1 for Linux on x86_64 ((Ubuntu)) located at: /usr/bin/mysql. However when I try to connect to a database server ...
Marinos An's user avatar
0 votes
0 answers
341 views

Configuring MySQL for SLURM

I'm having problems getting SLURM (for job scheduling) to work with a MySQL database. I was using this as a reference, but perhaps I misunderstood something in it. If someone can let me know what I'...
Ray's user avatar
  • 1,967
-1 votes
1 answer
1k views

Mysql error "'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (13)'" and I can't reset root password either

I'm getting the following error for a couple of commands I'm trying to run AND I don't know the password whenever I'm prompted for that. (note: I just updated my ubuntu distribution to 22.04, but I ...
coniferous's user avatar
0 votes
0 answers
60 views

What is the user/password for `sudo mysql` on Ubuntu 20.04?

When I installed mysql, I didn't write down the mysql root user password. I can get to the mysql prompt with just sudo mysql. However, mysql -u root -p does not work with the system's root password. I ...
user1045680's user avatar
0 votes
1 answer
68 views

mediawiki does not find mysql

After a reinstall of Ubuntu 22.10 and copy of backup to /var/www/html/ of mediawiki-1.38.4, reinstall of PHP8 and enabling of mbstring, intl and xml in a webbrowser to localhost/mediawiki-1.38.4 the ...
Tommy Pollák's user avatar
0 votes
2 answers
251 views

docker mysql 5.7 on ubuntu 22.04

I'm used to using Ubuntu 20.04 and docker mysql created like this: sudo docker run --name mysql-57-container -p 127.0.0.1:3310:3306 -e MYSQL_ROOT_PASSWORD=. -d --volume=/usr/share/docker/mysql57/conf....
reinforcers's user avatar
0 votes
2 answers
55 views

Mythtv backend install problems

I am trying to install mythtv on Proxmox as Ubuntu 22.04 container. I had fallowed instructions on web and video on youtube I ended with command: sudo apt-get install mysql-server mythtv-backend ...
ruffpl's user avatar
  • 21
1 vote
0 answers
77 views

MySQL does not create socket when launched at boot

After a reboot, mysqld is running, but no socket gets created and you cannot connect to the MySQL server: # mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/...
Paul Schreiber's user avatar
0 votes
1 answer
1k views

Mysql database root access denied

I cannot access my sql database on my server 22.04 LTS as root from localhost with and without password after just installing mysql-server-8.0 via apt I have tried to alter the password via the ...
reventcake295's user avatar
2 votes
0 answers
35 views

Is there an easy way to find all files on an ubuntu server and load them along with path information into mysql?

I am using Ubuntu server 20.04 for OwnCloud and backups of multiple networked computers. I know I have many duplicate files on the server and would like to have one database of all files so I can ...
CncJerry's user avatar
0 votes
0 answers
137 views

MySql workbench 8.0.31 on Ubuntu 22.04 looks like gibberish

I just installed and reinstalled MySQL Workbench Community 8.0.31-1 on Ubuntu 22.04 but when I open it through the icon or the terminal window it looks like gibberish. I'm running Ubuntu through ...
Carioca's user avatar
1 vote
0 answers
62 views

MySQL error while create databaseon mariadb

Trying new adventures, been set up cacti on my VirtualBox Machine, sticking to vary instructions, exploring my problem I stuck in, but can't go further. I'm doing alright till I'm creating database on ...
Claude Monet's user avatar

1
2 3 4 5
58