Tag: Mysql

Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP-AUTH, Quota, SpamAssassin, ClamAV) – Part 3

7 Install Amavisd-new, SpamAssassin And ClamAV To install amavisd-new, spamassassin and clamav, run the following command: apt-get install amavisd-new spamassassin clamav clamav-daemon zoo unzip unarj bzip2 You will be asked a few questions: Virus database update method: <– daemon Local database mirror site: <– db.de.clamav.net (Germany; select the mirror that […]

EasyApache Custom Modules

Custom Apache and PHP modules add features to the EasyApache system, and are accessible from both the command line and graphical WHM interfaces. These modules are compiled into Apache and/or PHP just like the modules provided with EasyApache. Before you begin You can find documentation for creating custom modules your […]

Enable MySQL Query Log File

MySQL has built-in functionality that allows you to log SQL queries to a file , You can enable the full SQL queries logs to a file or only slow running queries log.  It is easy for us to troubleshoot/ debug the sql statement if SQL queries log enable , The […]

mysqldump: Got error: 1045: Access denied for user

Today working on a client project, a shell script which uses MySQL to dump the database, has got me into this error mysqldump: Got error: 1045: Access denied for user   I was typically amazed getting this error because all my configurations were correct. I have created proper users to […]

List of Basic MySQL Commands

This is a list of handy MySQL commands that I use time and time again. At the bottom are statements, clauses, and functions you can use in MySQL. Below that are PHP and Perl API functions you can use to interface with MySQL. To use those you will need to […]

configure: error: Cannot find libmysqlclient under /usr

Recently I was configuring PHP with Mysql manually and it was really annoying to see the “Cannot find libmysqlclient under /usr” error message. The configure line I used to install PHP was ./configure –with-mysql  –with-libdir=/usr/lib and the error that I received was checking for MySQL UNIX socket location… /var/lib/mysql/mysql.sock configure: […]

Installing MySQL Administrator Tool To Connect To Remote Databases

This tutorial provides step-by-step instructions on how to install MySQL Admin tool on an Ubuntu 11.04 system and how to connect to a remote host with it. This should also work on most Debian based operating systems. I do not issue any guarantee that this will work for you!   Installing […]