Medior PHP https://leanpub.com/b/mediorphp by Joseph Kanyo is the featured bundle of ebooks 
on the Leanpub homepage! https://leanpub.com #Php #Databases #Mysql #ComputerProgramming #Laravel #Symfony #Html #Refactoring #Apis #ApiDesign #books #ebooks
Uncover key lessons learned from managing MySQL in the cloud — from scaling challenges to performance tuning and high availability strategies with Igor Donchovski at #fossasiasummit2025
Click here https://youtu.be/5R6edJ1xXrU to watch on the FOSSASIA YouTube channel.
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.
Know Your Meme: April 2025 4chan Hack. “April 2025 4chan Hack refers to memes and jokes about the Soyjak.party community supposedly hacking 4chan, restoring the deleted /QA/ board, and leaking the emails of 4chan moderators, also known as ‘janitors.’ The attackers reportedly exploited outdated PHP code and deprecated MySQL functions in 4chan’s backend, particularly in a core script named […]
https://rbfirehose.com/2025/04/15/know-your-meme-april-2025-4chan-hack/
Join us on Wednesday 16th April for our Scaling Writes on MySQL event!
https://www.meetup.com/leedsphp/events/306614649/
#php #MYSQL #db #leedsphp
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
Question, my colleague want's a small database with only a few tables ( #Mariadb / #mysql #sql ) - Data pushed with PowerShell Scripts
He also wants a small Web UI to search in this database with "basic" filtering
I've found #Adminer (https://www.adminer.org/de/) which looks simpler then things like phpMyAdmin
Is this a good choice ? thx
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.
My hot take: if you chose MySQL in 2025, you are doing it wrong. Just Use Postgres™
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.
Sometimes mysql shuts down unexpectedly when using with XAMPP.
There is a workaround here to solve this:
https://stackoverflow.com/a/61859561
Kinda cool to create an AquaShell script to automate that task:
https://www.aquashell-scripting.com/examples#fix-xampp-mysql-shutdown-error
CookUnity is hiring Engineering Manager, Growth
#kotlin #swift #typescript #react #android #ios #aws #mysql #postgresql #engineeringmanager
Buenos Aires, Argentina
Full-time
CookUnity
Job details https://jobsfordevelopers.com/jobs/engineering-manager-growth-at-cookunity-com-dec-19-2024-4107a2?utm_source=mastodon.world&utm_medium=social&utm_campaign=posting
#jobalert #jobsearch #hiring
Migrating your #OpenProject installation?
From Docker to packages, older setups to the latest version, or even switching databases — it’s important to understand your options.
Our latest blog article outlines best practices and recommended paths to guide you through: https://www.openproject.org/blog/migration-installation-guide/
Debugging PHP App Engine Applications Locally: A Guide to Troubleshooting MySQL Connections
Debugging App Engine PHP deployments with MySQL often involves local environment discrepancies. Connection failures, like "No such file or directory," happen when your local setup doesn't match App Engine's Cloud SQL Proxy. Learn how to emulate the App Engine environment locally using the Cloud SQL Auth Proxy to fix these issues. #AppEngine #PHP #MySQL #Deployment #Troubleshooting #CloudSQL #GoogleC...
Qiita - 人気の記事 
