Spyderserve Web Development

Category: Hosting and Databases

Disable Errors from displaying for PHP

You can disable errors from displaying on you website by modifying the php.ini file or you can add the following to you web page: error_reporting(0); @ini_set(‘display_errors’, 0); Source: http://stackoverflow.com/questions/1308379/how-can-i-stop-php-notices-from-appearing-in-wordpress

Force WordPress not to display PHP errors

If you want to disable php errors from being displayed on your wordpress site you can add the following to your wp-config.php file: define(‘WP_DEBUG’, false); I have, however, experienced instances where plugins will still cause notices to show on the webpages of my site.  To make sure no PHP notices show on the site I […]

Check MySQL Database for Errors and Repair

When checking the mysql server logs (located at /var/log/mysqld.log)  I started seeing errors ending in: …is marked as crashed and should be repaired. You can use (run from server cli): mysqlcheck [database name] to check all of the tables.  If one is identified as being in an error state you can repair it using (run […]

MySQL WorkBench 6.0 Issue Logging Into Database Server

Recently I upgraded to Workbench 6.0 and everything was working fine until I tried to log into an old database server that I manage.  The interface kept returning the following error: Connection using old (pre-4.1.1) authentication protocol refused (client option ‘secure_auth’ enabled)

MySQL user Table Modification

I routinely manipulate the mysql.user table to change host ip addresses of different users.  The easiest way for me is to use a simple UPDATE statement that changes all Host=’xxx.xxx.xxx.xxx’ to Host=’yyy.yyy.yyy.yyy’ using this statement: UPDATE user SET Host=’yyy.yyy.yyy.yyy’ WHERE Host=’xxx.xxx.xxx.xxx’; If this is done then the changes will not immediately be reflected in the […]

Spyderserve  2225 Bemiss Road Suite D Valdosta, Georgia 31602 United States