How To Enable Remote Access to MySQL via SSH in linux or unix server

Once you log into your server via SSH, the steps are as follows: 1. Edit the MySQL configuration file, to tell the MySQL server to listen on all available IP addresses. We recommend using nano if you are unfamiliar with more advanced text editors such as vim. To install nano, you can run the following […]

Continue Reading

mysql disabled strict standards on your server

Get following error on php site and upload images, video, files, not working also folder creation & copy files from other server via url copy not working. error display as bellow ================================================================================ Fatal error: [SQL] [1364] Field ‘icon’ doesn’t have a default value INSERT INTO files (`name`,`path`,`pid`,`time`,`size`) VALUES ================================================================================ here is solution: looks to be […]

Continue Reading