Tag Archives: mysql

How to install and configure LAMP ( Linux, Apache, MySQL and PHP ) in Ubuntu 14....

Index Introduction Requirements Installation Apache2 Installation MySQL Installation PHP Installation 1. Introduction Short for Linux, Apache, MySQL and PHP, an open-source Web development platform, also called a Web stack, that uses Linux as the operating system, Apache as the Web

Read more ›

How to install and configure Linux,Apache,Mysql(Mariadb) and PHP (a.k.a LAMP) i...

Index Introduction Requirements Install Apache Install MySQL (MariaDB) Install PHP 1.Introduction LAMP (Linux, Apache, Mysql & PHP ) is an open source web development platform that uses Linux as the operating system, Apache as the Web server, MySQL as the

Read more ›

How to Safely Change the Location of MySQL Data Directory on cPanel/WHM Servers

I had seen many cPanel servers running out of disk space due to MySQL data directory on “/var” partition.To solve this issue you need to move your MySQL data directory to a new location.There are also other situations like moving

Read more ›

How to install Percona Server in cPanel/WHM servers

What is Percona Server ? Percona Server is based on the original MySQL code, but functions as a drop-in that replaces MySQL .Like MySQL, Percona Server is open-source, so it is free and it benefits from additions from the community.

Read more ›

Got error: 130: Incorrect file format ‘some_table’ – mysql issue fix

Hello, There is  a solution for this type mysql error. This error appear due to a corrupted table format in a myisam table. The myISAM folder will have  an frm file which contains the schema  of that table. You can

Read more ›

How to install DBD::mysql in directadmin

To install DBI and DBD:mysql from source, run the following: wget http://www.cpan.org/modules/by-module/DBD/DBI-1.608.tar.gz tar xvzf DBI-1.608.tar.gz cd DBI-1.608 unset LANG; perl Makefile.PL make make install cd .. wget http://www.cpan.org/modules/by-module/DBD/DBD-mysql-3.0002.tar.gz tar xvzf DBD-mysql-3.0002.tar.gz cd DBD-mysql-3.0002 unset LANG; perl Makefile.PL make make install

Read more ›

How to rest mysql root password in directadmin

When connecting to the MySQL screens in DirectAdmin, if this error appears, that would indicated that the “da_admin” user has not been setup correctly.  Also you are reset the mysql root password too. To resolve this do the following. /etc/init.d/mysqld

Read more ›