The following code is for Debian 9 Stretch but should work on older Debian with minor changes
Category: MySQL
PHP – WordPress Backup (MySQL & Files)
After writing WordPress – Backup & Restore I came across a site that I do not have SSH/CLI access to so I needed to have another option. If you have SSH/CLI access it’s best to use the process on WordPress – Backup & Restore. Sometimes you just need a quick…
PowerShell – Install MySQL
Recently I had to install MySQL and configure it rather quickly, hopefully this will help someone else First off install Chocolatey Then Install MySQL
MySQL – WordPress Multisite Settings
Currently this is not an ideal process but will provide needed information. First get a list of all of the site’s option tables. Typically the main/root site will be wp_options and sub-sequential sites will be wp_2_options, wp_3_options, etc. The results should look similar to this: Once we have the tables…
WordPress – Ninja Forms – Disable Form Saves
If you have a concern about PHI or other concerns of saving data on your SQL database of the Ninja Forms follow the step on their site http://docs.ninjaforms.com/customer/en/portal/articles/2045697-faq#faq_save on the save-sub.php file. The save-sub.php location may vary based on your operating system but if you are on a UNIX based…
Recover/Replace MySQL Root Password – UNIX
Forgetting or never having the root password for a MySQL database can be rather difficult if it is now your job to support it. Note: You will need root access on the UNIX box to follow these commands. If for some reason you get an error saying mysql database doesn’t…
PHP Create MySQL Table From CSV File Headings
Reference: https://bytes.com/topic/mysql/answers/746696-create-mysql-table-field-headings-line-csv-file
MySQL – Get Max Length of Column
Similar to Max Length of Data In Column – MSSQL this query will do the same for MySQL Replace host (column) along with hosts (table) with what you’d like to check
PHP WordPress – Use Radius Server Login
Securing WordPress with Radius Server login. This project was created in mind to help secure WordPress but allow users an easier way to securely login without having to have a really long password to remember. While I do not go into creating the Radius server you can go to http://www.radiusdesk.com/getting_started/install_ubuntu_nginx…