Updated If you want a blog with HTML Editor function properly and right from the start you install the blog script. I suggest you install boastMachine like what I used on this blog. Just a personal opinion, nothing else.

---

Integration tinyMCE into sBlog script.
Below is my mods based on previous modification by jdurand[at]alterheberg[dot]org
you can download here detailed instructions are below:

[ more.. ]

                                  
Chobits in japanese language is ちょびっツ

As you can see this blog script can display Japanese text correctly but other blog script can't because using bbcode as it's rendering text not html.. I'll try to find out how to change text rendering engine from bbcode into html.

                                  
VI editor rarely command I used

dG = delete all character from the current pointer until the end of document
[x]dd = delete [many] line[s] -- replace x with number

                                  
shell# vi /etc/my.cnf

add this line

[mysqld]
port=3307

you can have any port that you like as long as that port not inused by other application
and make sure you have allow that port on system firewall and selinux if available
in my case I'm disabled firewall and selinux because mybox is for trial purpose and on private area

                                  
First, use the mysql program to connect to the server as the MySQL root user:

shell> mysql --user=root mysql [-p]

-p is for your mysql's root if it require password
Then you can add new users by issuing GRANT statements:

mysql> GRANT ALL PRIVILEGES ON *.* TO monty@localhost
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON *.* TO monty@'%'
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
mysql> GRANT RELOAD,PROCESS ON *.* TO admin@localhost;
mysql> GRANT USAGE ON *.* TO dummy@localhost;

These GRANT statements set up three new users:

monty
A full superuser who can connect to the server from anywhere, but who must use a password 'some_pass' to do so. Note that we must issue GRANT statements for both monty@localhost and monty@"%". If we don't add the entry with localhost, the anonymous user entry for localhost that is created by mysql_install_db takes precedence when we connect from the local host, because it has a more specific Host field value and thus comes earlier in the user table sort order.

admin
A user who can connect from localhost without a password and who is granted the RELOAD and PROCESS administrative privileges. This allows the user to execute the mysqladmin reload, mysqladmin refresh, and mysqladmin flush-* commands, as well as mysqladmin processlist . No database-level privileges are granted. (They can be granted later by issuing additional GRANT statements.)

dummy
A user who can connect without a password, but only from the local host. No privileges are granted--the USAGE privilege type allows you to create a user with no privileges. It has the effect of setting all the global privileges to 'N'. It is assumed that you will grant specific privileges to the account later.

For myself I usually done option 1 and 2

                                  
You may find the need to change the root password for your MySQL server. Here’s how.

This is the ‘hands-on’ way of changing the root password for your MySQL server. Get to a command prompt on the MySQL server and enter the following commands:

# mysql -u root mysql
> UPDATE user SET password=password(’secret’) WHERE user=’root’;
> flush privileges;

This should reset the password for you and then you can log in and get some real work done.