Tuesday, November 17, 2009

Editing mySQL Databases through terminal in Xampp in Linux

You have put an effort to view this page because you might be desparate to find out the solution for editing mySQL databases through terminal in Xampp in linux, esp. Ubuntu & its clone. I was doing the same before i knew how to do so :). Okay!
For the command line way, i considered the following steps;
Presuming you have installed lampp in /opt directory, start the XAMPP server
sudo /opt/lampp/lampp start

Then login from console into mySQL using
/opt/lampp/bin/mysql -u root -p;

You will be prompted for the password then. Don't panic just because you don't know it. By default, no password is set for the user "root" in mysql. So press the return key.
Now you are finally on the track. Play around with sql queries!!! Have fun :)

0 comments:

Post a Comment