phpMyAdmin: Deprecation Notice
sudo apt-get remove –purge phpmyadmin php-gettext php-mbstring -y sudo apt-get autoremove -y sudo apt-get update sudo apt-get install phpmyadmin php-gettext php-mbstring -y
Category: MySQL
phpMyAdmin: Securing web console
I installed PHPMyadmin to check my help manage my database, eventhough I also use the desktop program MySQL Workbench, I fell sometimes its important to use the webconsole. Recently, upon checking my MySQL Logs (/var/logs/mysql/error.log) I encountered that everyday I […]
MySQL: Enable Logging
mysql> show variables like ‘%log%’; Recreate the log files I deleted by mistake. It appears the MySQL does not recreate them automatically. touch /var/log/mysql.log chown mysql:adm /var/log/mysql.log touch /var/log/mysql/error.log chown mysql:adm /var/log/mysql/error.log touch /var/log/mysql/mysql-slow.log chown mysql:adm /var/log/mysql/mysql-slow.log touch /var/log/mysql/mysql.log chown […]
CSV IMPORT MANUAL
Remove Commas from strings Truncate String Length using LEFT function in Excel Use CLEAN Function to remove unwanted breaks and non displaying characters
SQL Query: Remove Leading and Trailing Double Quotes
UPDATE m_product SET name = TRIM(BOTH ‘”‘ FROM name) WHERE m_product_id = ‘1128493’ UPDATE m_product set name = replace(name, ‘””‘, ‘”‘) WHERE m_product_id = ‘1128493’