XOFTMADE Web Solutions

12 May 2016

2002 Cannot log in to the MySQL server

adminp
Database, Linux

If you are getting Mysql connection error in cPanel / WHM server then you have to edit your Mysql configuration file to change host name to local host IP.

Error:
#2002 Cannot log in to the MySQL server

Some how mysql login details are working fine still connection to phpadmin failed. Please try editing following file:

/usr/local/cpanel/base/3rdparty/phpMyAdmin/config.inc.php

And change following code in it:

Code:
$cfg[‘Servers’][$i][‘host’] = ‘localhost’;
to:
$cfg[‘Servers’][$i][‘host’] = ‘127.0.0.1’;

Thanks

12 Aug 2015

Improve your WordPress Security (Revised Techniques)

On average, 30,000 new websites are hacked each day. WordPress sites can be an easy target for attacks because of themes, plugins vulnerabilities, weak passwords and obsolete software.

Most WordPress admins don’t even know they’re vulnerable, but XoftMade Web Solutions is here to help you and guide you not to be a next victim. We have arranged a revised security updates for your WordPress website, follow them on urgent basis and be safe.
read more

20 Nov 2014

How to Enable unicode utf-8 characters in wordpress blog title

Unicode and WordPress

Sometime back… I was trying to put unicode characters(utf-8) in the title of a blog from wp-admin > settings > general. After saving it became like ?????????.

All pages had utf-8 in their meta tags so the issue was somewhere else. A working solution was found :

1. Go to phpmyadmin and select the database of this blog
2. Select table wp_options and then click operations. In table options box change collation to utf8_unicode_ci which is the last option.
3. Also change the collation of individual columns e.g.option_value to utf8_unicode_ci

Changing the table and column collation property made the thing work right.

20 Nov 2014

How to Display last modified date of posts in wordpress

There is a blue spot at the end of this post which mentions the “Updated” date. It is the date on which this particular post last modified or updated. Since I keep most of the old posts from time to time, thought it would be a good idea to display the date in the post well.Add the following code at the end of the current theme functions.php update.

function add_post_content($content) 
{
    return $content . '<div class="updated_on">Last Updated On : ' . get_the_modified_time('jS F Y') .'</div>';
}
add_filter('the_content', 'add_post_content' , 9);

The function get_the_modified_time gets the modified time of the current post in any given format. The same is added to the post content using the ‘add_filter’ api function.

The add_filter takes a second parameter called priority. Default is 10, giving anything lesser will mean a higher priority. So we specify 9 to make it higher in priority. Higher priority is needed since many plugins also modify the contents of the post so this function must be able to execute before any other code gets in.

20 Nov 2014

Adobe Acrobat Reader 9.5 installation on ubuntu 13.04

Adobe Acrobat Reader

Adobe Acrobat Reader is the most popular player on windows PDF files. On Linux, there are native applications like Okular and Evince (Document Viewer) that can read pdf files easily.

Adobe initially launched the native version of Acrobat Reader for Linux like the Windows version. However, development was later arrested and 9.5.5 is the latest version of Adobe Acrobat Reader for Linux.

There are two methods to install Acrobat Reader on ubuntu. The first is to download the Linux installation file directly from the Adobe website and the second method is to use the canonical repository.
read more

Blog

2002 Cannot log in to the MySQL server

Improve your WordPress Security (Revised Techniques)

How to Enable unicode utf-8 characters in wordpress blog title

Unicode and WordPress

How to Display last modified date of posts in wordpress

Adobe Acrobat Reader 9.5 installation on ubuntu 13.04

Adobe Acrobat Reader