mysql

mysql-common : Conflicts: mysql-server-8.0 but 8.0.34-0ubuntu0.22.04.1 is to be installed sudo apt-get purge mysql-client-8.0 mysql-server-8.0 mysql-server-core-8.0 Reading package lists… Done Building dependency tree… Done Reading state information… Done Package ‘mysql-client-8.0’ is not installed, so not removed Package ‘mysql-server-8.0’ is not installed, so not removed Package ‘mysql-server-core-8.0’ is not installed, so not removed 0 upgraded, 0 …

MySQL ignore LD_PRELOAD I trying to use jemalloc with MySQL. I found that I should add enviroment variable LD_PRELOAD to SystemD unit and thats all. But lsof /usr/lib/x86_64-linux-gnu/libjemalloc.so.2 shows nothing. I also tryed to start MySQL from cli with LD_PRELOAD, but still no success. Tested on Debian 12 and Ubuntu 22.04 with MySQL 8.0.34. What …

Joomla 4 MySQL Not Fully Initialized Issue I am getting this error when trying to run my Joomla site: Access denied for user ‘testuser’@’localhost’ (using password: YES) Now, heres the thing. I just moved a Joomla 4 site from one VPS to this new one. The old mysql version was 5.7. The new version is …

MariaDB log_error system variable, configuration file difference between Ubuntu 20.04 and 22.04 Ubuntu 20.04 (Focal Fossa) # dpkg -l | grep mariadb-server-10 ii mariadb-server-10.3 1:10.3.38-0ubuntu0.20.04.1 amd64 MariaDB database server binaries # grep -E ‘skip_log_error|syslog|log_error’ /etc/mysql/ -R | grep -v ‘#’ /etc/mysql/mariadb.conf.d/50-server.cnf:log_error = /var/log/mysql/error.log /etc/mysql/mariadb.conf.d/50-mysqld_safe.cnf:skip_log_error /etc/mysql/mariadb.conf.d/50-mysqld_safe.cnf:syslog # tail -2 /var/log/mysql/error.log 2023-07-28 8:30:23 0 [Note] /usr/sbin/mysqld: ready …

Make Mysql listening to all ports Ubuntu 22.04 I have this code: [mysqld] bind-address = 0.0.0.0 default-storage-engine = innodb innodb file per table collation-server = utf8 general ci init-connect = ‘SET NAMES utf8’ character-set-server = utf8 This is for an older version of Ubuntu, now I am using Ubuntu 22.04 and I am trying to …

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 /usr/bin/gdb /usr/bin/make /usr/bin/nc /usr/bin/netcat /usr/bin/perl Right after their removal, …

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 of troubleshooting, I was able to find that this only …

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, 0 to remove and 2 not upgraded. Installing mysql-client-8.0 und mysql-server-8.0 doesnt work: […] apt install mysql-server-8.0 mysql-client-8.0 […] …

mysqldump failing when launched from script Running next command in terminal is working fine like expected. /var/www$ sudo mysqldump –defaults-extra-file=/mnt/./.sql/mysqldump.cnf –databases site3 –hex-blob | sudo tee /mnt/site3/20230404_site3.sql running the same command from within script -rwx—— 1 root root 1686 apr 4 22:23 BackupDrupal.sh /var/www$ sudo ./BackupDrupal.sh site3 is ending with next message: /*!40000 ALTER TABLE …

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 that, I’ve tried with a YouTube video on how to install …

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 have to go through more stuff but in the long run I think it’s worth …

ansible mysqldb not accepting item in tagrget options I have a db host, on which some sql files are present. I want to source it into db using an ansible playbook. so I find all files & register in variable, then try to source those using below code. – name: get schema files find: paths: …

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, but I cannot understand how I achieve …

Is not possible change MySQL's port at Fedora Server 36 For Fedora Server 36 was installed MySQL 8 Community through the .rpm from MySQL Community Downloads. Now according with the Editing Conf. Files section is indicated to use the /etc/my.cnf.d/community-mysql-server.cnf file, but it does not exist, it because the /etc/my.cnf.d/ directory is empty, the truly …

Automatic backups of MySQL database with Cronjob I would like to backup my MySQL database with a cron job, but I cannot make it work. This is the code that I am using: 0 2 * * * mysqldump -u root toko_db | gzip > /var/backup/toko_db_`date ‘+%Y-%m-%d’`.sql.gz Asked By: SEOSatu || Source The date section …

MySQL – Cannot update to 8.0.31 from 8.0.30 at Ubuntu 22.04.1 I have 2 updates that could not be installed automatically. When I try to upgrade with: sudo apt upgrade then I got this message: The following packages have been kept back: mysql-client mysql-server So when I try to install it manually like: sudo apt …

Increase Mysql row size When I run a laravel migration i get an error complaining about row size how can i solve i have run a couple of commands but not changed anything SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting …

phpMyAdmin installation/config I’m a noob to Linux and packages, not to mention websites and databases, however, I’ve followed this guide and completed all steps successfully and have a working wordpress site that I can access via the web, the tutorial I followed can be found here. System info: Linux 5.19.0-21-generic, Ubuntu 22.10 I am connected …

How can I reinstall mysql/mysqld on Fedora? I’m experiencing some issues where the mysqld won’t start, so I’d like to purge or (at least) reinstall its files in order to replace the current configuration files with the stock ones so that it will start again. This is the content of journalctl -xeu mysqld.service: ░░ The …

Cant get mysql db to update from php website xubuntu 22.04-mysql 8..0.3 php 7.4.30 I’m not that good with code and basically copy and modified stuff to get it to work for my purposes without fully understanding it. Now I’m having issues trying to create a webpage that will allow me to update one entry …