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 linux CentOS 6.3. This post assumed that PHP, apache and MySQL server has been setup properly. 1. Login as a root, go to document’ root […]

How to Configure MySQL Database Server on Ubuntu 11.10

MySQL

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 most popular open source database and the most demanding Web’s database especially for blogging and to run web applications. Assumed that MySQL database has been […]

How to Install Adminer on CentOS 6.2 Server

MySQL

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 MySQL, PostgreSQL, SQLite, MS SQL and Oracle. This post assumed that MySQL has been installed and configured as per documented guidelines below : How to […]

How to Backup and Restore MySQL Database on CentOS/RHEL

MySQL

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 Database Backup Program, Click for more info. The mysqldump client is a backup program originally written by Igor Romanenko. It can be used to dump […]

How to Secure MySQL Database Server

MySQL

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 the MySQL server from unauthorized or anonymous access. In This post, i will share with you on how to secure your database server with the […]

How to Delete Anonymous Users From MySQL on CentOS 6.2

MySQL

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 protect your data, the “root” user should be set with a password and the anonymous user should be delete. In this post, i will show […]

How to Fix MySQL Database error : Can’t create database ‘newdbname’ (errno: 28)

MySQL

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): Can’t create database ‘newdbname’ (errno: 28) Findings and Solutions : This error means that your mysql server does not have enough free space. You need […]