How to Setup WordPress Blog on CentOS 6.3
WordPress is an open-source blogging platform. It’s a free blogging tool and content management system (CMS) based on PHP and MySQL. This steps covers how to install the WordPress on…
How to Configure MySQL Database Server on Ubuntu 11.10
In this post, i will share with you on how to perform basic configuration on MySQL database server on Ubuntu 11.10 linux. As we know, MySQL Server is the world’s…
How to Install Adminer on CentOS 6.2 Server
Adminer is a full-featured database management tool written in PHP. Conversely to phpMyAdmin, Adminer consist of a single file ready to deploy to the target server. Adminer is available for…
How to Backup and Restore MySQL Database on CentOS/RHEL
In this post, i will share on how to backup and restore MySQL database on Linux server. I have tested this on my CentOS and RHEL servers. MySQLDump — A…
How to Install MySQL Server on RHEL 6
In this post i will show you on how to install MySQL server on Redhat Enterprise Linux 6 (RHEL 6). MySQL server is a popular choice of database server that…
How to Secure MySQL Database Server
A Default MySQL installation is completely vulnerable to attacks. MySQL installation should be made as secure as possible. This is to protect the data collections and the information maintained by…
How to Set MySQL root Password on CentOS 6.2
MySQL installation has a default “root” user with a blank password and an “anonymous” user, also with a blank password. This is very unsecured and not recommended. In order to…
How to Delete Anonymous Users From MySQL on CentOS 6.2
MySQL installation has a default “root” user with a blank password and an “anonymous” user, also with a blank password. This is very unsecured and not recommended. In order to…
How to Install MySQL Database Server on CentOS 6.2
In this post, i will show you on how to install MySQL server using yum command. Assume that you have installed minimal installation type CentOS 6.2 and has setup your…
How to Fix MySQL Database error : Can’t create database ‘newdbname’ (errno: 28)
Symptoms: When i run the command to create new database on mysql, it was returned with below error message. How to fix this? mysql> CREATE DATABASE newdbname; ERROR 1006 (HY000):…
How to Fix “missing the MySQL extension” on Linux
I believe most users who try to install WordPress on a Linux server encountered this problem. This problem occurs if Apache, PHP and MySQL server has been installed but without…
How to Restore MySQL database using PHPMyAdmin
Previously, i have teach you how to backup the MySQL database. Now, i will brief you the simple steps on how to restore MySQL database using phpmyadmin. This steps only…