Data Bases

Solutions related to data bases such as mysql, oracle, MSSQL and PostgreSQL

03Jul 2013

If you use our LAMP installer script and want to add a new domain afterwards, we’ve created a simple script to ease up the process. This script creates a new user, adds the domain settings for Apache, adds a new MySQL Database and user, restarts necessary services. Simply get our script from here or on […]

25Nov 2012

In this post, i’m gonna explain how to connect to a LDAP server via using PHP. First i wanna talk about some definitions; LDAP means Lightweight Directory Access Protocol. As you can understand from it’s name, it is a database which uses directory-tree based structure. It’s used by OpenLDAP, Sun Directory Server, Microsoft Active Directory […]

17Nov 2012

It is not uncommon for you to need the MySQL root password of a server, especially when you’re dealing with hundreds of different servers. Here’s the quickest way to reset it. (Don’t forget that you need to login to your server as root in order to achieve this) 1) Start MySQL in safe mode. 2) […]

12Nov 2012

This is kind of a common problem and may have several reasons. Sometimes when we simply want to restart the MySQL Server, we can get such an error: ERROR! MySQL server PID file could not be found! First of all, always check if the /tmp partition is full. This can happen when MySQL can’t write […]

26Jun 2012

Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PHP installation properly. If you’re getting this error when starting phpMyAdmin, there are a few possibilities of what the problem may be. For starters, be sure that it is a server side problem. If this only […]

20Jun 2012

Version Info: V0.2 21/06/2012 DO you ever wanted to set-up a testing server with – Apache virtual config, logs, paths setted, – MySQL server with password set, – FTP Server (Vsftpd), – PHP and PhpMyAdmin installed & configured on your server or VPS in seconds? If you answer “yes” to the question, you are in […]

14Jun 2012

This article is only applicable to H-Sphere control panel where old mysql passwords are stored as clear text. With the latest update, php 53 comes with mysqlnd module which doesn’t allow old_passwords to be used. In /etc/my.cnf comment old_passwords if any, Backup your MySQL database and restart mysql server and execute the following code: Create […]

25Apr 2012

You’ve designed a database with MyISAM and suddenly realized that you need ACID (atomicity, consistency, isolation, durability) compliant features and transactions. Right, you should use InnoDB. But how to change storage engine for your previous tables ? As far as i know, changing the storage engine for tables is easy by alter command. But there’s one flaw. You should […]

15Apr 2012

Before changing MySQL root password you may try to recover default installation password. DirectAdmin MySQL root password is set within the installation process and written down to setup.txt. If you didn’t change this password you can find the default one in the setup.txt, use the command below to see the contents of /usr/local/directadmin/scripts/setup.txt: your password […]