Different way to install MYSQL

Different way to install MYSQL
1. Install through MYSQL RPM
- Download and run rpm rpmfile.
- The program file will install into file predefine by rpm file
- Example : Red Hat Enterprise Linux 4 RPM (x86)

2. Compile mysql from MYSQL source and install
- We can compile feature we need.
- We can predefine target install folder as well.
- Example : Source

3. Install MYSQL binary version
- Download and copy the code into target folder
- Advantage : We can download into folder we specific
- Example : Linux (non RPM packages) or
Linux (non RPM, Intel C/C++ compiled, glibc-2.3)

4. Use Operating System MYSQL compile version
- Most Linux come with mysql compile version.
- MYSQL version and start and using

MYSQL download page http://dev.mysql.com/downloads/mysql/5.0.html

Install MYSQL gui Tool - Failed dependencies

Problem when install MYSQL administrator

[root@localhost src]#rpm -iv mysql-administrator-5.0r5-1fc5.i386.rpm
error: Failed dependencies:
libatkmm-1.6.so.1 is needed by mysql-administrator-5.0r5-1fc5.i386
libgdkmm-2.4.so.1 is needed by mysql-administrator-5.0r5-1fc5.i386
libglibmm-2.4.so.1 is needed by mysql-administrator-5.0r5-1fc5.i386
libgtkmm-2.4.so.1 is needed by mysql-administrator-5.0r5-1fc5.i386
libpangomm-1.4.so.1 is needed by mysql-administrator-5.0r5-1fc5.i386
libsigc-2.0.so.0 is needed by mysql-administrator-5.0r5-1fc5.i386

Problem when Install MYSQL Query Browser
[root@localhost src]# rpm -iv mysql-query-browser-5.0r5-1fc5.i386.rpm
error: Failed dependencies:
libatkmm-1.6.so.1 is needed by mysql-query-browser-5.0r5-1fc5.i386
libgdkmm-2.4.so.1 is needed by mysql-query-browser-5.0r5-1fc5.i386
libglibmm-2.4.so.1 is needed by mysql-query-browser-5.0r5-1fc5.i386
libgtkmm-2.4.so.1 is needed by mysql-query-browser-5.0r5-1fc5.i386
libpangomm-1.4.so.1 is needed by mysql-query-browser-5.0r5-1fc5.i386
libsigc-2.0.so.0 is needed by mysql-query-browser-5.0r5-1fc5.i386

how to solve?
yum install libatkmm-1.6.so.1

Result :
Successful Intall MYSQL Administrator and Browser

Post Installation MYSQL Testing

Test connection to mysql
1) connect to mysql
[root@localhost src]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.27-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>show databases
+-----------------------+
Database
+---------------------- +
information_schema
mysql
test
+-----------------------+
3 rows in set (0.02 sec)

2. ps aux grep mysql

3. mysqladmin -p ping
[root@localhost ~]# mysqladmin -p ping
Enter password :
mysql is alive

Install MYSQL Client

Install MySQL client

rpm -i MySQL-client-standard-5.0.27-0.rhel4.i386.rpm
Preparing... ###########################################
[100%]
1:MySQL-client-standard ###########################################
[100%]

Install MySQL rpm version

[root@localhost src]# rpm -i MySQL-server-standard-5.0.27.rhel4.i386.rpm
PLEASE REMEBER TO SET A PASSSWORD FOR THE MySQL root USER!
To do so, sert the server, then issue the follwing commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h locahost.localdomain password 'new-password'
See the manual for more instruction
Note: If you are upgrading from a MySQL <=3.22.10 you should runthe /usr/bin/mysql_fix_rilivege_tables. Otherwise you will not be able to use the new GRANT command! Please report any problems with the /usr/bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com
Starting MySQL [ok]