How to add mysql user manually

It may too easy for the mysql expert out there, it just a simple sharing to the Mysql Amateur user.

If you have SSH, just type “mysql” then you will be in mysql command screen

(1) First create user first

CREATE USER ‘dbuser‘@’localhost’ IDENTIFIED BY ‘password‘;

(2) Assign it to the database

GRANT ALL ON db.* TO ‘dbuser‘@’localhost’;

Note:
db: your database name
dbuser: your database username
password: the password

Disconnected: No supported authentication methods avilable

When you connect to SSH by putty, putty prompt out the message as below.

What is that???? erm, I research online, it seems that the SSH Password Authorization Tweak is disable on WHM. Follow the step as below to remedy it.

(1) GO to WHM

(2) GO to SSH Password Authorization Tweak

(3) Enable the Password Auth

Joomla Force SSL?

Joomla Force SSL, a good features or bad features? Only the user can determine it. But for me, it just another features that give trouble for user. Some Joomla amateur think once enable it, the site will auto have SSL. The truth is it bring lot of issue cause once you enable it in admin panel, you are unable to revert it back cause you are unable to access to admin panel.

So you need to go to configuration.php and edit it from

var $force_ssl = ‘1’;

to

var $force_ssl = ‘0’;

Then, you able to access again.

Thanks god, Joomla, please remove this features, we do not need that.

How To Add WP-PageNavi to Twenty Eleven WordPress Theme ?

PageNaviIs a WordPress Plugin that show page in your themes. It was a great plugin for me so far as I have many page on my blog. This post is all about how to add the WP-PageNavi to Twenty Eleven WordPress Theme. Easy and Straight forward.

(1) Open functions.php of twenty eleven

(2) Locate code as below

function twentyeleven_content_nav( $nav_id ) {
        global $wp_query;

        if ( $wp_query->max_num_pages > 1 ) : ?>
                <nav id="<?php echo $nav_id; ?>">
                        <h3 class="assistive-text"><?php _e( 'Post navigation', 'twentyeleven' ); ?></h3>
                        <div class="nav-previous"><?php next_posts_link( __( '<span class="meta-nav">←</span> Older posts', 'twentyeleven' ) ); ?></div>
                        <div class="nav-next"><?php previous_posts_link( __( 'Newer posts <span class="meta-nav">→</span>', 'twentyeleven' ) ); ?></div>
                </nav><!-- #nav-above -->

(3)after that line, replace div class=”nav-previous” and div class=”nav-next” with

<?php wp_pagenavi(); ?>

After edit, code will as below

function twentyeleven_content_nav( $nav_id ) {
        global $wp_query;

        if ( $wp_query->max_num_pages > 1 ) : ?>
                <nav id="<?php echo $nav_id; ?>">
                        <h3 class="assistive-text"><?php _e( 'Post navigation', 'twentyeleven' ); ?></h3>
                        <?php wp_pagenavi(); ?>
                </nav><!-- #nav-above -->