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 Securing MySQL Database Server on CentOS 5.8

MySQL

In this post, i will show the quick steps to securing MySQL database server on linux CentOS 5.8. On fresh MySQL server installation, MySQL root password does not set and anonymous user also allowed to enter your database. This is very insecure and danger for sensitive data. To start securing your MySQL, simply run this […]

How to Install MySQL Server on CentOS 5.8

MySQL

In this post, i will show on how to install MySQL database server on linux CentOS 5.8 server. MySQL server is a database server that can stores and retrieves data for the blog, websites and applications. It is one of the most popular most used in the internet especially for content management and blogging site. […]

How to Configure MySQL Database Server on Fedora 16

MySQL

On previous post (Install MySQL) i already shows how to install MySQL server on Fedora 16. MySQL server is a popular choice of database server that can stores and retrieves data for the blog, websites and applications. MySQL is a Relational Database Management System (RDBMS) that runs as a server providing multi-user access to a […]

How to Install MySQL Database Server on Fedora 16

MySQL

MySQL server is a popular choice of database server that can stores and retrieves data for the blog, websites and applications. MySQL is a Relational Database Management System (RDBMS) that runs as a server providing multi-user access to a number of databases. For more information on MySQL, you can visit their website at www.mysql.com. In […]

How to Install phpMyAdmin on CentOS 5.7 using RPMforge Repository

phpmyadmin

phpMyAdmin is a free software tool written in PHP intended to handle the administration of MySQL over the World Wide Web. It can manage a whole MySQL server (needs a super-user) as well as a single database. phpMyAdmin supports a wide range of operations with MySQL. The most frequently used operations are supported by the […]

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 […]