Install LAMP Server (Apache, MySQL or MariaDB, PHP) On Ubuntu 14.10/14.04/13.10

LAMP is a combination of operating system and open-source software stack. The acronym LAMP comes from the first letters of Linux, Apache HTTP Server, MySQL or MariaDB database, and PHP/Perl/Python.

In this tutorial, we will see how to setup LAMP server on Ubuntu 14.10 system.

Fix "Message: mysqli::real_connect()" on Mariadb

Error Message: mysqli::real_connect(): Headers and client library minor version mismatch. Headers:50537 Library:100100

Fix :

# sudo agt-get remove php5-mysql
# sudo agt-get install php5-mysqlnd

Easy steps to reset mySQL root password:

First please try using

mysql -u root -p

and enter your password (if you remember) at the prompt to login as the sql-root user (note the switch -p is for password).

If you really have to reset your root password for mysql, here's an easy way - reconfigure the package withdpkg-reconfigure.

SQLyog.Ultimate.v11.1.1.0 with serial

What is SQLyog (32 bit + 64 bit)?

SQLyog is used to manage your sql database with GUI Interface. Sqlyog will provide u graphical user interface.SQLyog is the most powerful MySQL manager and admin tool, combining the features of MySQL Administrator, phpMyAdmin and other MySQL Front Ends and MySQL GUI tools.  

Download Here:  https://copy.com/ZBgtM9yz10xU