MySQL root Password Default di EasyEngine Installer

Setelah sebelumnya setiap pindah Server VPS dari cPanel atau dari VPS lain selalu menggunakan beberapa baris Command Line untuk setup server dan beralih ke EasyEngine yang lumayan simple akhirnya saya menemukan salah satu masalah klasik.

Sebenarnya bukan 100% masalah tapi kalau nggak ditelaah one by one akan susah menemukan atau lewat jalur belakang dengan reset password. Masalah yang saya temui ini berkaitan dengan MySQL default root password di EasyEngine. Continue reading “MySQL root Password Default di EasyEngine Installer”

Top 5 Must Have SEO Plugins For WordPress This Year

WordPress is a free and open source blogging tool and publishing platform powered by PHP and MySQL. It is often customized into a content management system (CMS). And in 2011 WordPress has dominated the landscape of blogging. There are a number of reasons why WordPress is so good quality coding, highly customizable, works well for SEO, friendly user interface, and a lot more.

Wordpress Plugins
Wordpress Plugins

Media is also incorporated artistically and effortlessly by thousands of different WordPress themes around the internet, and SEO comes just as easily. One very popular feature of WordPress is its rich plugin architecture which allows users and developers to extend its functionality beyond the features that come as part of the base install. Let’s take a look at the top 5 best SEO plugins for WordPress this year. Continue reading “Top 5 Must Have SEO Plugins For WordPress This Year”

Can’t Connet To MySQL Server

I just finished to install an Ubuntu Server for office work. It will act as intranet web server and information system database. I used Apache (of course plus PHP) for web server and MySQL as database server.

Installation run well and I could browse MySQL database from phpMyAdmin. I added user who can connect remotely (anyhost) but I didn’t test it. The next day he complained me because he can not connect to MySQL due to an error (Error code: 2003).

If you can not connet to MySQL server as non root users either locally or remotely, it can be solved by editing MySQL configuration file (my.cnf) and comment out the following command:

skip_networking

bind-address = 127.0.0.1

* comment out means that you need to add # before commands.

Restart MySQL server to make it work.

That’s all.