Abhijit Sandhan

Loves Open Source, Blogging, Traveling, Hiking and sharing Knowledge!

[How To] Install phpMyAdmin from source code

php logo

phpMyAdmin provides Graphical User Interface (GUI) to manage MySQL database and users. In this post, I am going to discuss steps to install phpMyAdmin using source code. Steps: 1) Download source code file from here on the server and copy it to document root folder of the Apache. 2) Extract the archive and rename the extracted folder to phpmyadmin. It should …

Read More »

[How To] Reset MySQL root password

mysql logo

MySQL root password is important if you want to access phpMyAdmin, secure MySQL command prompt access, etc. In case one forgets the MySQL root password or wants to set root password, following steps should help to achieve the same. 1) Stop the MySQL Server: /etc/init.d/mysql stop/etc/init.d/mysql stop or /etc/init.d/mysqld stop/etc/init.d/mysqld stop 2) Start the MySQL configuration: mysqld --skip-grant-tables &mysqld --skip-grant-tables …

Read More »

[How To] Get 50GB Dropbox free storage space

The mobile companies like Samsung, HTC are providing 50GB dropbox storage space for some specific mobile handsets. Dropbox is really useful in many terms. When you register at Dropbox, it initially provided 2GB of storage space. This is the moment when you feel cheated as the commitment was of 50GB. There is nothing to worry as you can avail 50GB …

Read More »

php5-xxx 5.x.x-1ubuntux.x is to be installed [Solved]

While installing PHP modules using apt-get utility on Ubuntu system, you may end up with following error: php5-common 5.3.2-1ubuntu4 but 5.3.2-1ubuntu4.2 is to be installed The above error occurs because the package php5 (5.3.2-1ubuntu4.2) is present on your system bu apt-get utitlity is either trying to install module of higher or lower version. Solution: To resolve the issue, download the PHP …

Read More »

MySQL replication problem: ‘show master status’ shows ‘Empty set (0.00 sec)’

mysql logo

In MySQL replication, you setup master and slave MySQL server. On master server, while checking the master status, you might end up with following error message: 1 2 3 4 mysql> SHOW MASTER STATUS; Empty set (0.00 sec) mysql> show binary logs; ERROR 1381 (HY000): You are not using binary loggingmysql> SHOW MASTER STATUS; Empty set (0.00 sec) mysql> show …

Read More »