Changing column collation and character set in mysql database / schema
In the examples below, change: To create the ALTER SQLs, …
Changing column collation and character set in mysql database / schema Read More »
mysql
change / reset root password in mysql
Resetting the Root Password: Generic Instructions The preceding sections provide …
How to install phpMyAdmin with nginx on Debian 11
In this guide, we will show you how to install …
How to install phpMyAdmin with nginx on Debian 11 Read More »
how to export mysql database from docker container
In order to export the base from the docker container, …
how to export mysql database from docker container Read More »
how to find size of the database via mysql console
There are a bunch of different tools with a graphical …
how to find size of the database via mysql console Read More »
How to replace MySQL with Percona Server on Debian or Ubuntu
You can safely replace MySQL with Percona Server without lossing …
How to replace MySQL with Percona Server on Debian or Ubuntu Read More »
how to Upgrade MariaDB 10.1 to 10.5 on Debian Stretch
These instructions detail the upgrade from a previous version of MariaDB Community Server to MariaDB …
how to Upgrade MariaDB 10.1 to 10.5 on Debian Stretch Read More »
How to add remote MySQL database server VestaCP
1. It is assumed you already have your second server …
howto upgrade mariadb 10.x to 10.3.x on Centos 7
#1: Perform a full backup The first thing to do …
howto upgrade mariadb 10.x to 10.3.x on Centos 7 Read More »
How to disable MySQL Strict Mode?
Q: I’m going to start handling my own data validation …