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 »
In order to be able to use a database, one needs to create: a new database, give access permission to the database server to a database user and finally grant all right to that specific database to this user. For the purpose of this tutorial, I will demonstrate how to create a database for a… Read More »
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 »
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 »
DATABASE ERROR: CONNECTION FAILED! Unable to connect to the database! Please contact your server-administrator. —————————————- Solution:
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 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 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!
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 »
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 »