Install LAMP on Linux

Once in a life you want to be a web developer or you have a dream to build your own website. Then you might come across many platforms, frameworks and CMSs. Some of them need web server that is apache, mysql which is database and php so that your browser …

Connect remotely to mysql server

If you are a web developer and working with mysql then once in while you have done this. Connect to remote mysql server mysql -u root -h ‘any ip address here’ -p Sometime you will get the following error. ERROR 1130 (00000): Host ”xxx.xx.xxx.xxx” is not allowed to connect to …

Remove mysql from linux

Some time we face issues related to mysql installation. But even after purging and reinstalling does not solve problem because some of the mysql configuration remains in the system. This post is related to remove mysql from linux and its configuration as well. Uninstall mysql package sudo apt-get remove mysql …

How to Recover a Lost MySQL Password

If you are using MySQL on Debian / Ubuntu Linux then use following command: sudo /etc/init.d/mysql stop sudo /usr/bin/mysqld_safe –skip-grant-tables & mysql -u root mysql UPDATE user SET password=PASSWORD(‘your_password’) WHERE user = ‘root’; FLUSH PRIVILEGES; quit; sudo pkill mysql_safe (or kill -9 pid) sudo /etc/init.d/mysql restart Cheers,