I have followed the steps from bellow to install mysql from src on my linux ( red hat 6 ) :
shell> groupadd mysql shell> useradd -r -g mysql mysql # Beginning of source-build specific instructions shell> tar zxvf mysql-VERSION.tar.gz shell> cd mysql-VERSION shell> cmake . shell> make shell> make install all these as root the point is that it did not install into /usr/local but into /usr/share these worked fine : # Postinstallation setup shell> cd /usr/local/mysql shell> chown -R mysql . shell> chgrp -R mysql . but I can not create the DB or start the server : 1. [root@ericomtx bin]# pwd /usr/bin [root@ericomtx bin]# ls -la mysql* -rwxr-xr-x. 1 root root 4984411 Nov 15 13:26 mysql -rwxr-xr-x. 1 root root 110776 Nov 15 13:24 mysqlaccess -rwxr-xr-x. 1 root root 1702 Apr 9 2010 mysqlaccess.conf -rwxr-xr-x. 1 root root 4290406 Nov 15 13:26 mysqladmin -rwxr-xr-x. 1 root root 4841390 Nov 15 13:26 mysqlbinlog -rwxr-xr-x. 1 root root 10349 Nov 15 13:24 mysqlbug -rwxr-xr-x. 1 root root 4281034 Nov 15 13:26 mysqlcheck -rwxr-xr-x. 1 root root 4994249 Nov 15 13:26 mysql_client_test -rwxr-xr-x. 1 root root 6456 Nov 15 13:24 mysql_config -rwxr-xr-x. 1 root root 4169 Nov 15 13:24 mysql_convert_table_format -rwxr-xr-x. 1 root root 22389 Nov 15 13:24 mysqld_multi -rwxr-xr-x. 1 root root 21432 Nov 15 13:24 mysqld_safe -rwxr-xr-x. 1 root root 4473050 Nov 15 13:26 mysqldump -rwxr-xr-x. 1 root root 6602 Nov 15 13:24 mysqldumpslow -rwxr-xr-x. 1 root root 3245 Nov 15 13:24 mysql_find_rows -rwxr-xr-x. 1 root root 483 Nov 15 13:24 mysql_fix_extensions -rwxr-xr-x. 1 root root 32209 Nov 15 13:24 mysqlhotcopy -rwxr-xr-x. 1 root root 4287853 Nov 15 13:26 mysqlimport -rwxr-xr-x. 1 root root 14472 Nov 15 13:24 mysql_install_db -rwxr-xr-x. 1 root root 7694 Nov 15 13:24 mysql_secure_installation -rwxr-xr-x. 1 root root 16689 Nov 15 13:24 mysql_setpermission -rwxr-xr-x. 1 root root 4278732 Nov 15 13:26 mysqlshow -rwxr-xr-x. 1 root root 4331143 Nov 15 13:26 mysqlslap -rwxr-xr-x. 1 root root 4845542 Nov 15 13:26 mysqltest -rwxr-xr-x. 1 root root 729588 Nov 15 13:26 mysql_tzinfo_to_sql -rwxr-xr-x. 1 root root 1017021 Nov 15 13:26 mysql_upgrade -rwxr-xr-x. 1 root root 888746 Nov 15 13:26 mysql_waitpid -rwxr-xr-x. 1 root root 3818 Nov 15 13:24 mysql_zap [root@ericomtx bin]# ./mysql_install_db --user =mysql 121116 14:50:18 [ERROR] Column count of mysql.proc is wrong. Expected 20, found 16. Created with MySQL 50080, now running 50504. Please use mysql_upgrade to fix this error. ERROR: 1558 Column count of mysql.proc is wrong. Expected 20, found 16. Created with MySQL 50080, now running 50504. Please use mysql_upgrade to fix this error. 121116 14:50:18 [ERROR] Aborting but I CAN NOT update MySQL ... it doesn allow me to : [root@ericomtx bin]# ./mysql_upgrade Looking for 'mysql' as: ./mysql Looking for 'mysqlcheck' as: ./mysqlcheck Running 'mysqlcheck with default connection arguments ./mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) when trying to connect FATAL ERROR: Upgrade failed [root@ericomtx bin]# .... also ... you may say to me so I need to create the DB from my install dir ... ok : [root@ericomtx mysql-5.5.4-m3]# scripts/mysql_install_db --user=mysql WARNING: The host '' could not be looked up with resolveip. This probably means that your libc libraries are not 100 % compatible with this binary MySQL version. The MySQL daemon, mysqld, should work normally with the exception that host name resolving will not work. This means that you should use IP addresses instead of hostnames when specifying MySQL privileges ! Installing MySQL system tables... 121116 14:53:47 [Note] Buffered information: Performance schema disabled (reason: start parameters). 121116 14:53:47 [ERROR] Column count of mysql.proc is wrong. Expected 20, found 16. Created with MySQL 50080, now running 50504. Please use mysql_upgrade to fix this error. ERROR: 1558 Column count of mysql.proc is wrong. Expected 20, found 16. Created with MySQL 50080, now running 50504. Please use mysql_upgrade to fix this error. 121116 14:53:47 [ERROR] Aborting 121116 14:53:47 [Note] /usr/sbin/mysqld: Shutdown complete Installation of system tables failed! Examine the logs in /var/lib/mysql for more information. You can try to start the mysqld daemon with: shell> /usr/sbin/mysqld --skip-grant & and use the command line tool /usr/bin/mysql to connect to the mysql database and look at the grant tables: shell> /usr/bin/mysql -u root mysql mysql> show tables Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in /var/lib/mysql that may be helpful. Please consult the MySQL manual section 'Problems running mysql_install_db', and the manual section that describes problems on your OS. Another information source are the MySQL email archives available at http://lists.mysql.com/. Please check all of the above before mailing us! And remember, if you do mail us, you MUST use the /usr/bin/mysqlbug script! Can anyone help me out on this ? this warning ==> WARNING: The host '' could not be looked up with resolveip. would this be a problem in my /etc/hosts : [root@ericomtx mysql-5.5.4-m3]# more /etc/hosts 127.0.0.1 localhost.localdomain localhost ericomtx.linux oc1118264555 #::1 localhost.localdomain localhost6 localhost ericomtx oc1118264555 ericomtx.linux localhost.localdomain localhost localhost ericomtx.linux oc1118264555 127.0.0.1 localhost.localdomain localhost ericomtx.linux oc1118264555 127.0.0.1 localhost.localdomain oc1118264555 localhost ericomtx.linux oc1118264555