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 Show the Tables in a MySQL Database Server
In this guide i will guide you the simple step to show the table on the database server. Assume that the wordpress blog has been installed and running fine with…
How to Grant Privileges in MySQL Database Server
In this tutorial, i will guide you how to grant privileges in MySQL database server. You must connect to the MySQL Server as a root user and perform below task:…
How to Install MySQL Database in Linux Using Yum
I will show you how to install MySQL database server in Linux CentOS using yum command. It very straight forward and easy as long as your server connected directly to…
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…
How to Install WAMP Server on Windows XP or Windows
WAMP SERVER(WampServer) is a great package for PHP developers or maybe students or maybe the newbie system administrators or webmasters. Generally, Wamp Server consist of Apache, MySQL and PHP. In…
How to backup MySQL database using PHPMyAdmin
The are a few way to backup the MySQL database. One of the easiest way is using the phpmyadmin. This only applicable for the database that was installed with phpmyadmin…