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 […]
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 the following database details: Database Name : wp1db Database User : wp1user Database Password : wp1password Go to the terminal or ssh to MySQL Database […]
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: 1. How to Login MySQL DB as a root: [root@server ~]# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with […]
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 internet [root@myserver tmp]# yum install mysql-server Loaded plugins: fastestmirror Loading mirror speeds from cached hostfile * addons: ftp.oss.eznetsols.org * base: ftp.oss.eznetsols.org * epel: bali.idrepo.or.id * […]
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 […]
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 this tutorial, i will guide you how to install the fresh wamp server. 1. Go to this url to download http://www.wampserver.com/en/download.php 2. Download the latest […]
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 such as LAMP server, Wamp server and XAMPP server. Most of the students or for the development peoples has using this phpmyadmin to administer their […]