MySql Administrator for Get GUI

Download
Mysql administrator http://dev.mysql.com/downloads/gui-tools/5.0.html
1 > Generic x86 Linux TAR (bundled dependencies) this one
2> tar zxvf mysql-gui-tools-5.0r12-linux-i386.tar.gz
3> cd mysql-gui-tools-5.0r11b-linux-i386
4> ./mysql-administrator --update-paths
5> ./mysql-administrator
6> open that folder there you see mysql desktop icon click that icon and you get mysql administrator GUI mode.

2nd option

1> aptitude install libpcre3-dev libmysqlclient15-dev libglib2.0-dev libxml2-dev

libglade2-dev libgtkmm-2.4-dev g++

2> cd mysql-gui-common
3> ./configure
4> make
5> make install
6> cd ../mysql-administrator
7> ./configure
8> make
9> make install
Goto that folder and click to mysql administrator desktop icon.

Do that and you get mysql administrator GUI .

Magento Installation

Megento installation is so easy and you run it so easy .

Down load Magento form http://www.magentocommerce.com/download/noregister
down load
magento-1.3.2.1.tar.gz
magento-sample-data-1.1.2.tar.gz

download that 2 tar files.
Install some software
apt-get install apach2 mysql-server php5 php5-mysql php5-curl php5-gd php5-mcrypt php5-cgi

After install
open
vim /etc/php5/apache2/php.ini
and find
memory_limit = 256M
save that file

open
vim /etc/hosts
127.0.0.1 www.example.com

$ cp -rf magento -1.3.2.1.tar.gz magento-sample-data-1.1.2.tar.gz /var/www
$ cd /var/www
$ tar -xfv magento-1.3.2.1.tar.gz
$ tar -xvf magento-sample-data-1.1.2.tar.gz

mv magento-sample-data-1.1.2/media/* magento/media/
mv magento-sample-data-1.1.2/magento_sample_data_for_1.1.2.sql magento/data.sql
chmod o+w var var/.htaccess app/etc
chmod -R o+w media

open mysql
mysql -u root -p
password=

mysql>create datebase magento;

mysql -h DBHOST -u DBUSER -pDBPASS DBNAME <>

mysql -h localhost -u user name -p user password data base name < style="font-style: italic;">
./pear mage-setup .

./pear install magento-core/Mage_All_Latest-stable

It will take some time and magento works
open firefox and other broser
type there
www.example.com/magento
after that it is ask
agree check it
ask mysql user name and password
country name and country money.
then you get two option
Frant hand and back hand
if you click back hand then
user name = admin
password =123123

ok

Thanks
jiten jha

How to get GUI in mysql

Easy to get mysql GUI.

go to terminal > login to super user "su" > apt-get install phpmyadmin

then it is asking to select option to select.
apache2
apache
and two more

select all that and finish it

you have to install apache2 also
apt-get install apache2

open firefox or other browser
type there
http://localhost
when u press enter then it is tell "IT'S WORKS"
that mean apache is working
then
open firefox and other browser

http://localhost/phpmyadmin
then u get user name and password screen
there you have to put mysql user and password
you get GUI mysql

Case sensitive problem in Mysql table

if you want to remove case sensitive option in mysql table then go to /etc/mysql/my.cnf
vim my.cnf
open that file and find that line
[mysqld]
Write there
lower_case_table_names=1
then table in mysql if your mysql not loading table then you put "2" in place of "1".
Then it is work.

Thank
jiten jha