Oracle VS MariaDB & MySQLworkbench

🇬🇧 https://qgqlochekone.blogspot.com/2020/04/mariadb-mysql-and-mysqlworkbench.html

🇪🇨 https://venenux.github.io/venenux/z-guides-packages-debian-mysql-mariadb-es.html#que-sucede-con-mysqlworkbench-y-mariadb

#mysql #workbench #mariadb #war #oracle #gui #linux @venenux

🇬🇧 #MariaDb/#MySQL considers 'localhost' to be different than '127.0.0.1' so you could set a #password for TCP and #sockets for local users 😱

🇪🇨 #MariaDB/#MySQL considera 'localhost' distinto que '127.0.0.1' por ende puedes asignar una #clave para TCP y #socket para usuarios locales 💥

🇬🇧 change user password depends of mysql fork type:
🇻🇪 cambiar clave de usuario depende de el tipo de mysql:

mysql 5.0 to 5.7 & mariadb 5.3 to 10.1.19 ->

SET PASSWORD FOR 'user'@'host' = PASSWORD('newpass')

mysql 5.7+ & mariadb 10.2+

ALTER USER 'user'@'host' IDENTIFIED BY 'pass';

#mysql #mariadb #password #user #manage

🇬🇧 MySQL a 'pretty poor database' says departing Oracle engineer
🇻🇪 MySQL a poco menos que una pobre base de datos dice Oracle
https://www.theregister.com/2021/12/06/mysql_a_pretty_poor_database/ #mysql #oracle #postgresql
https://www.geekersdigest.com/mysql-is-a-pretty-poor-database-says-ex-mysql-developer/

#LAMP : #apache + #mysql + #postgresql + #php + #odbc + #alpine + #linux

https://codeberg.org/alpine/alpine-wiki/src/branch/main/tutorials/server-alpine-LAMP-professional-fast-forward.md

https://t.me/alpine_linux 👍

#mysql #perconadb #percona #mariadb
🇬🇧 troubleshooting access and privileges issues
🇻🇪 solución de problemas de acceso y privilegios
🇷🇺 устранение проблем с доступом и привилегиями
🇨🇳 排除访问和权限问题

📁 https://t.me/open_tecnologies/1222

#zabbix #server #proxy #mysql #debian #devuan #alpine

🇬🇧 when you migrate from 4 to 5 or 6 you must execute double.sql
🇲🇽 cuando migras desde 4 a 5 o 6 debes ejecutar double.sql
🇷🇺 когда вы переходите с 4 на 5 или 6, вы должны выполнить double.sql
🇨🇳 当你从 4 到 5 或 6 时，你必须执行 double.sql

Debian: /usr/share/doc/zabbix-proxy-mysql/double.sql (zabbix-proxy-mysql)
Alpine: /usr/share/zabbix/database/mysql/double.sql (zabbix-setup)

#mysql #error #connection #solution

error reading communication packets

🇬🇧 silent killers of MySQL Connections is the MySQL Packet, try playing with max_allowed_packet also interactive_timeout or max_connections but take care of open_files_limit and RAM available
🇻🇪 asesino silencioso de conecxiones MySQL es MySQL Packet, intente jugar con max_allowed_packet con interactive_timeout o max_connections pero tenga cuidado con open_files_limit y RAM disponible


https://t.me/vegnuli/992
https://t.me/latam_programadores

#adminerevo #adminer #php #web

UI to manage #sql #mysql #mongodb #postgresql #sqlite #mssql #Oracle #Elasticsearch

https://github.com/adminerevo/adminerevo

#php #container #docker #deploy #redis #mysql

🇬🇧 a docker with php+redis+mysql+node deployed ready to use
🇻🇪 un docker con php+redis+mysql+node #desplegado listo para uso
🇷🇺 #докер с #развернутым php+redis+mysql+node

https://vessel.shippingdocker.com/

#php #container #docker #deploy #redis #mysql

🇬🇧 a docker with php+redis+mysql+node deployed ready to use
🇻🇪 un docker con php+redis+mysql+node #desplegado listo para uso
🇷🇺 #докер с #развернутым php+redis+mysql+node

https://vessel.shippingdocker.com/

#LAMP #alpine + #apache + #mysql + #php

🇬🇧 https://venenux.github.io/alpine-wiki/#/tutorials/server-alpine-LAMP-ospos-320
🇪🇸 https://venenux.github.io/alpine-espanol/#/recetas/server-alpine-LAMP-ospos-320