#changelog Database duplication #mariadb #mysql #postgresql → https://changelog.alwaysdata.com/461/detail/

#Shaarli: How to Add Multiple Hosts in phpMyAdmin – TecAdmin - Méthode pour gérer plusieurs bases MySQL dans un même PhpMyAdmin.

Pour des bases en docker, installer le container PMA sur le même réseau docker et donner le nom du container pour afficher la base.

Permet en théorie de sélectionner des bases docker internes et des bases externes (hébergeur). : https://tecadmin.net/add-multiple-hosts-in-phpmyadmin/ #phpmyadmin #docker #bases #mysql

Has anyone setting up a #friendica instance for the #fediverse run into an issue where #php is unable to get authorized to log in to #mysql or #mariadb ? I am able to log in as those users in the cli and adminer webpages, and the user is given all privileges + has a wildcard for the host name.

https://blog.martinscloud.com/mariadb-use-docker-compose-for-mariadb/ #docker #docker-compose #compose #mysql #mariadb

Oracle released #MySQL Workbench version 8.0.42. https://dev.mysql.com/downloads/workbench/

How to Install #MySQL 8 on #VPS Server

This article provides a guide for how to install #MySQL 8 on VPS server.

Database Management Systems (DBMSs) are applications designed to store and organize data in an organized fashion, usually as part of an e-commerce or data warehousing application. One such DBMS is MySQL, an open-source and highly scalable free DBMS that's free and open source; we will cover how to install MySQL 8 onto a VPS server so you ...
Continued https://blog.radwebhosting.com/how-to-install-mysql-8-on-vps-server/?utm_source=mastodon&utm_medium=social&utm_campaign=ReviveOldPost

How to Install #ClusterControl on #AlmaLinux VPS This article provides a guide for how to install ClusterControl on AlmaLinux VPS.
How to Install ClusterControl on AlmaLinux VPS
ClusterControl is a robust database management platform that simplifies deployment, management, and scaling of database clusters. If you’re using AlmaLinux VPS for your infrastructure, this guide will walk you through installing ClusterControl seamlessly. ...
Continued https://blog.radwebhosting.com/how-to-install-clustercontrol-on-almalinux-vps/?utm_source=mastodon&utm_medium=social&utm_campaign=ReviveOldPost #installguide #mysql

Working with Transactions inside a store procedure on #Mysql / #MariaDB

https://stackoverflow.com/a/46125452

Getting MySQL Error 1175 when trying to update or delete? That’s Safe Update Mode kicking in. Learn how to disable it safely and run your queries smoothly.

Read the full guide: https://www.izoate.com/blog/how-to-fix-mysql-error-1175-disable-safe-update-mode-mysql/

PHP & MYSQL: 200 Solved Exercises and Projects for Practice https://leanpub.com/php-mysql-exercices-projects #books #ebooks #PHP #MYSQL

Open Source Linux MySQL Tools!

Was ist MySQL?

MySQL ist ein weit verbreitetes, relationales Datenbankmanagementsystem (RDBMS), das auf der Structured Query Language (SQL) basiert. Es wird häufig für die Speicherung, Verwaltung und Abfrage von Daten in verschiedenen Anwendungen eingesetzt, von kleinen Websites bis hin zu großen Unternehmensanwendungen.

https://www.linuxlinks.com/mysqltools/

Upgrade from MySQL 8.0.33 to 8.0.41 this morning on production.

Everything went smoothly... until:

Lock timeout when upgrading an intermediate primary in a ClusterSet. It looks like https://bugs.mysql.com/bug.php?id=100242. I know that kill -9 has been used in the past (yes, MySQL can be challenging and it's the only solution), so let's re-initialize the host. 6TB of data, it's going to be long but we have no choice at this point.

The Percona Server version of MySQL Shell doesn't support the Javascript interface anymore. The official documentation has Javascript examples everywhere but not Python. I had to guess and learn the Python equivalent in emergency.

Then if we define a "localAddress" to "Cluster.add_instance", MySQL tries to use the deprecated "XCOM" communication stack instead of "MYSQL". If you have errors on port 33061, you should remove the localAddress and/or use the "MYSQL" communication stack https://dev.mysql.com/doc/mysql-shell/8.0/en/shell-admin-api-communication-stack.html

Every time the service is started, it takes 30 seconds to initialize the InnoDB buffer pool because the host has 1TB of RAM.

For an unknown reason, the mandb process takes multiple minutes when upgrading a package.

Time is really long when you do upgrades.

Hoy fueron buena onda en la uni y nos dieron una herramienta libre llamada HeidiSQL para aprender sobre creación de procedimientos en SQL.

I am throwing a fit trying to get the python mysql-connector installed.

pip gives me an error:
error: externally-managed-environment

× This environment is externally managed

How do I get this thing installed? So many of my programs use this.

#Hate Update: re prev toot ... today I hate #MySQL #information_schema because it tells great big dirty LIES. You need to `ANALYZE TABLE` on any table you're interested in immediately before you ask information_schema for its metadata.

How to Install #ClusterControl on #AlmaLinux VPS This article provides a guide for how to install ClusterControl on AlmaLinux VPS.
How to Install ClusterControl on AlmaLinux VPS
ClusterControl is a robust database management platform that simplifies deployment, management, and scaling of database clusters. If you’re using AlmaLinux VPS for your infrastructure, this guide will walk you through installing ClusterControl seamlessly. ...
Continued https://blog.radwebhosting.com/how-to-install-clustercontrol-on-almalinux-vps/?utm_source=mastodon&utm_medium=social&utm_campaign=ReviveOldPost #mysql #installguide

NameCrane Offloaded SQL: Get Hosted MySQL in the Cloud for Very Cheap! https://lowendbox.com/blog/namecrane-offloaded-sql-get-hosted-mysql-in-the-cloud-for-very-cheap/ #offloadedpostgresql #offloadedpostgres #offloadpostgres #offloadedmysql #SpecialOffers #offloadedsql #offloadsql #namecrane #namecrane #database #buyvm #mysql

Video: Convert a #MySQL database to #PosgreSQL using Database Workbench.

https://youtu.be/L4nOo26CIdU

#MySQL
#MariaDB
#SQLServer
#Oracle
#Firebird
#InterBase
#PostgreSQL
#NexusDB
#databasetools #databasedevelopment #DatabaseWorkbench