Category Archives: MYSQL Database

Installing PowerDNS (With MySQL Backend) on Debian

PowerDNS is a DNS server, written in C++ and licensed under the GPL. It runs on most Unix derivatives. PowerDNS features a large number of different backends ranging from simple BIND style zonefiles to relational databases and load balancing/failover algorithms. A DNS recursor is provided as a separate program. Installation of the PowerDNS Authoritative server… Read More »

Improve the Security of your MySQL installation.

Improve MySQL Installation Security – mysql_secure_installation This program enables you to improve the security of your MySQL installation in the following ways: You can set a password for root accounts. You can remove root accounts that are accessible from outside the local host. You can remove anonymous-user accounts. You can remove the test database (which… Read More »

How to Install MySQL on ubuntu Server

MySQL Installation on ubuntu Server – Learn more about MySQL and master how to use it. What is MySQL? MySQL is a freely available open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL). SQL is the most popular language for adding, accessing and managing content in a database. It is most… Read More »

How to create mysql database, using mysqladmin

What is MySQLAdmin? mysqladmin is a client for performing administrative operations. You can use it to check the server’s configuration and current status, to create and drop databases, and more. Howto? gen@en-01# mysqladmin -u sibanda -p create sibdb Enter password: It is recommended that If you create a new database it’s good to create user… Read More »

mysqldump: Got errno 28 on write

mysqldump: Got errno 28 on write ERROR: mysqldump command did not succeed. You are backing up your MYSQL database using mysqldump command line tool and you encounter the above error message. In my case I was outputting my mysql backup database file to an external usb drive. The issue here was that my external usb… Read More »

How to backup MySQL Database in command line

How to backup MySQL Database in command line enemy@en-01:/mnt/usbstick# mysqldump -u enemy -p sibanda > sibanda.sql Enter password: ******* enemy@en-01:/mnt/usbstick# ls -l sibanda.sql -rwxr-xr-x 1 enemy enemy 499973 2014-01-24 20:13 sibanda.sql There you have it!

The mcrypt extension is missing. Please check your PHP configuration.

After logging on to phpmyadmin, I ecountered the following error message at the foot of the page: The mcrypt extension is missing. Please check your PHP configuration. Solution that worked for me was to action the following: en-01# apt-get install php5-mcrypt en-01# ln -s /etc/php5/conf.d/mcrypt.ini /etc/php5/mods-available/mcrypt.ini en-01# php5enmod mcrypt en-01# service nginx reload en-01# service… Read More »

The mcrypt extension is missing. Please check your PHP configuration.

After logging in to phpmyadmin, I ecountered the following error message at the foot of the page: The mcrypt extension is missing. Please check your PHP configuration. Solution that worked for me was to action the following: gs2# apt-get install php5-mcrypt gs2# ln -s /etc/php5/conf.d/mcrypt.ini /etc/php5/mods-available/mcrypt.ini gs2# php5enmod mcrypt gs2# service nginx reload gs2# service… Read More »