
Tag: MySQL


MySQL RSA private key file not found resolution

Apply an SSL to MySQL
Change Forgotten MariaDB Root Password

How to install a specific version of MySQL (or other app) via yum

Change Forgotten root password in MySQL 5.7.10

MySQL Disable Bin Logging
One of the MySQL servers was running out of space, it turned out to be over 7GB of bin logs filling up the hard drive rather quickly. Since this server is not replicating, then a few modifications to the my.ini or my.cnf file will disable this “feature”. Edit the my.cnf file. Yours may be somewhere so search for it with…
Read More »
MySQL Reset root Password
Every now and again a MySQL root password may have been forgotten or undocumented along the way, but that does not negate the need to access the MySQL server. There is a way to gain access to the MySQL server to change the password for root and eventually log in as root. Applies to: CentOS / RHEL / Scientific Linux…
Read More »
A Working MySQL Database Automatic CRON Backup Script
After creating a usable MySQL database backup script and having tested it throughly, I put it in the /etc/cron.daily directory where I had expected it to run automatically. I had even tested it from that directory manually with success. After some time had past, I realized that the script was running as it read in the logs; however had only...
Read More »Vsftpd FTP Server With Virtual Users ( MySQL + PAM )
vsftpd (“Very Secure FTP Daemon”) is an FTP server for Linux and supports PAM (“pluggable authentication modules”). A virtual user cannot login to the Linux system and is considered more secure than using a “real” user whom can login to a Linux system. This guide offers a script that demonstrates yet another way to setup a vsftpd server using PAM…
Read More »
MySQL Rename a Database
MySQL Commands
There are many sites that will provide far greater detail and comment than this one. However, this is a list of basic commands that I have found repeatedly useful. MySQL Commands Create a database List all databases Switch to a database Show tables in a database Delete a database Delete a table Show data in a table Find a specific…
Read More »