Configuring MYSQL QUERY Browser for XAMMP installed in Ubuntu.

Generally, You can connect  MYSQL Query Browser to MYSQL server which is installed seperatly, just  with its  username and password. But,  things go slighty weird when you try to connect the MYSQL Query Browser with MYSQL  server which comes with XAMPP. Because , the path of the mysql server which comes with xamp is different from the normal one.

Just follow my lead to solve it :(Am Assuming that U have installed both XAMPP and Mysql query browser).

PHPMYAdmin Vs Mysql Query Browser

Hey guys! You might be wondering at a stage when you are about to use stored procedures , triggers , functions and routines in PHPMYadmin because it doesn’t supports it. If the user in good in using  in MYSQL in terminal then he would face no problem. But, if he is bad, then I got a solution for him. He can download the MYSQL Query Browser(Note: this is available only fro linux users not for windows users)

MYSQL Query Browser is an open source project just like phpmyadmin, but unlike phpmyadmin it can create, display and even edit the stored procedures and other stuffs. In PHPMYadmin, all You can do is just  create stored procedures. And a hint, if you wanna  view it, you have to manually do that by querying the  information_schema  Database which the default DB for PHPMyadmin, and table is Routines which stores the routines like Stored Procedures, functions and general routines. And To view Triggers use the tale named Triggers.

You can download mysql query browser here… download(based on your linux version and distributor)

Windows XP Tips and Tricks

In this post am gonna tell you some pro ways of hiding a folder in your Windows XP

How to make a folder invisible even if the show hidden folders options is enabled?

How to make Google analytics track an Ecommerce website?

To make an Ecommerce website basically  a CRE loaded website get tracked by google analytics is very easy to do that all you should have these things,

• You should have the admin access for that site.
• Your Google analytics code should be installed in your site and also you should have enabled the Ecommerce  option in your profile setting.
• Then get the following zip file from this GA2.21