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 […]
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 […]
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 […]
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 […]
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 can stores and retrieves data for the blog, websites and applications. This post assumed that you have set up local yum repository using your DVDROM. […]
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 […]
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 […]
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 […]
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 own local yum repository. You can use internet CentOS yum repository instead if you have direct internet connection to your server. How to Setup Local […]
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 […]
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 or missing the MySQL extension. Follow the steps below to resolve this issue : Problem : I’m installing WordPress blog system under CentOS Linux or […]
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 applicable for the database that was installed with phpmyadmin such as LAMP server, Wamp server and XAMPP server. Most of the students or for the […]