sql/Mysql programming on Ubuntu 10.04

[bijay_ps]

Hey guys! I am new to linux. And I have installed Ubuntu 10.04. Now I want to do database programing like creating tables, joins,etc
so can anyone tell me how to do that in Ubuntu 10.04??

 

[krishnandu.sarkar]

Install LAMP and PhpMyAdmin.

Check *help.ubuntu.com/community/ApacheMySQLPHP

Just run..

sudo tasksel install lamp-server
sudo apt-get install phpmyadmin

And you'll be ready for your development.

 

[bijay_ps]

okay i did as you said... now how to start it and do programs??

 

[krishnandu.sarkar]

You mean you want to write SQL Scrips right??

For that go to *localhost/phpmyadmin and login using your MySQL Username and Password that you set while installing MySQL and PHPMyAdmin.

And voila, you are on MySQL. Now you can try out SQL Scripts that you want to