I have followed the steps from bellow to install mysql from src on my linux ( red hat 6 ) : <br><br>shell> groupadd mysql<br>shell> useradd -r -g mysql mysql<br># Beginning of source-build specific instructions<br>shell> tar zxvf mysql-VERSION.tar.gz<br>
shell> cd mysql-VERSION<br>shell> cmake .<br>shell> make<br>shell> make install<br><br>all these as root <br><br>the point is that it did not install into /usr/local but into /usr/share <br><br><br>these worked fine : <br>
# Postinstallation setup<br>shell> cd /usr/local/mysql<br>shell> chown -R mysql .<br>shell> chgrp -R mysql .<br><br><br>but I can not create the DB or start the server : <br><br><br>1. [root@ericomtx bin]# pwd<br>
/usr/bin<br>[root@ericomtx bin]# ls -la mysql*<br>-rwxr-xr-x. 1 root root 4984411 Nov 15 13:26 mysql<br>-rwxr-xr-x. 1 root root 110776 Nov 15 13:24 mysqlaccess<br>-rwxr-xr-x. 1 root root 1702 Apr 9 2010 mysqlaccess.conf<br>
-rwxr-xr-x. 1 root root 4290406 Nov 15 13:26 mysqladmin<br>-rwxr-xr-x. 1 root root 4841390 Nov 15 13:26 mysqlbinlog<br>-rwxr-xr-x. 1 root root 10349 Nov 15 13:24 mysqlbug<br>-rwxr-xr-x. 1 root root 4281034 Nov 15 13:26 mysqlcheck<br>
-rwxr-xr-x. 1 root root 4994249 Nov 15 13:26 mysql_client_test<br>-rwxr-xr-x. 1 root root 6456 Nov 15 13:24 mysql_config<br>-rwxr-xr-x. 1 root root 4169 Nov 15 13:24 mysql_convert_table_format<br>-rwxr-xr-x. 1 root root 22389 Nov 15 13:24 mysqld_multi<br>
-rwxr-xr-x. 1 root root 21432 Nov 15 13:24 mysqld_safe<br>-rwxr-xr-x. 1 root root 4473050 Nov 15 13:26 mysqldump<br>-rwxr-xr-x. 1 root root 6602 Nov 15 13:24 mysqldumpslow<br>-rwxr-xr-x. 1 root root 3245 Nov 15 13:24 mysql_find_rows<br>
-rwxr-xr-x. 1 root root 483 Nov 15 13:24 mysql_fix_extensions<br>-rwxr-xr-x. 1 root root 32209 Nov 15 13:24 mysqlhotcopy<br>-rwxr-xr-x. 1 root root 4287853 Nov 15 13:26 mysqlimport<br>-rwxr-xr-x. 1 root root 14472 Nov 15 13:24 mysql_install_db<br>
-rwxr-xr-x. 1 root root 7694 Nov 15 13:24 mysql_secure_installation<br>-rwxr-xr-x. 1 root root 16689 Nov 15 13:24 mysql_setpermission<br>-rwxr-xr-x. 1 root root 4278732 Nov 15 13:26 mysqlshow<br>-rwxr-xr-x. 1 root root 4331143 Nov 15 13:26 mysqlslap<br>
-rwxr-xr-x. 1 root root 4845542 Nov 15 13:26 mysqltest<br>-rwxr-xr-x. 1 root root 729588 Nov 15 13:26 mysql_tzinfo_to_sql<br>-rwxr-xr-x. 1 root root 1017021 Nov 15 13:26 mysql_upgrade<br>-rwxr-xr-x. 1 root root 888746 Nov 15 13:26 mysql_waitpid<br>
-rwxr-xr-x. 1 root root 3818 Nov 15 13:24 mysql_zap<br><br><br>[root@ericomtx bin]# ./mysql_install_db --user =mysql<br><br><br>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.<br>
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.<br>121116 14:50:18 [ERROR] Aborting<br><br>but I CAN NOT update MySQL ... it doesn allow me to : <br>
<br><br>[root@ericomtx bin]# ./mysql_upgrade <br>Looking for 'mysql' as: ./mysql<br>Looking for 'mysqlcheck' as: ./mysqlcheck<br>Running 'mysqlcheck with default connection arguments<br>./mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) when trying to connect<br>
FATAL ERROR: Upgrade failed<br>[root@ericomtx bin]#<br><br><br>.... also ... you may say to me so I need to create the DB from my install dir ... ok : <br><br>[root@ericomtx mysql-5.5.4-m3]# scripts/mysql_install_db --user=mysql<br>
WARNING: The host '' could not be looked up with resolveip.<br>This probably means that your libc libraries are not 100 % compatible<br>with this binary MySQL version. The MySQL daemon, mysqld, should work<br>normally with the exception that host name resolving will not work.<br>
This means that you should use IP addresses instead of hostnames<br>when specifying MySQL privileges !<br>Installing MySQL system tables...<br>121116 14:53:47 [Note] Buffered information: Performance schema disabled (reason: start parameters).<br>
<br>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.<br>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.<br>
121116 14:53:47 [ERROR] Aborting<br><br>121116 14:53:47 [Note] /usr/sbin/mysqld: Shutdown complete<br><br><br>Installation of system tables failed! Examine the logs in<br>/var/lib/mysql for more information.<br><br>You can try to start the mysqld daemon with:<br>
<br> shell> /usr/sbin/mysqld --skip-grant &<br><br>and use the command line tool /usr/bin/mysql<br>to connect to the mysql database and look at the grant tables:<br><br> shell> /usr/bin/mysql -u root mysql<br>
mysql> show tables<br><br>Try 'mysqld --help' if you have problems with paths. Using --log<br>gives you a log in /var/lib/mysql that may be helpful.<br><br>Please consult the MySQL manual section<br>'Problems running mysql_install_db', and the manual section that<br>
describes problems on your OS. Another information source are the<br>MySQL email archives available at <a href="http://lists.mysql.com/">http://lists.mysql.com/</a>.<br><br>Please check all of the above before mailing us! And remember, if<br>
you do mail us, you MUST use the /usr/bin/mysqlbug script!<br><br>......<br><br>I wanted to uninstall it ... and install it back with the correct source flags now .... <br><br>How can I run cmake to unistall this ... ? I still have the uncompressed dir from the the installation : <br>
<br>[root@ericomtx mysql-5.5.4-m3]# ls <br>aclocal.m4 CMakeCache.txt config.guess <a href="http://configure.in">configure.in</a> depcomp install-sh libservices man pstack sql-common vio<br>
BUILD CMakeFiles config.h.cmake COPYING Docs INSTALL-SOURCE ltmain.sh missing README storage win<br>BUILD-CMAKE cmake_install.cmake config.sub CPackConfig.cmake EXCEPTIONS-CLIENT INSTALL-WIN-SOURCE make_dist.cmake mysql-test regex strings ylwrap<br>
ChangeLog CMakeLists.txt configure CPackSourceConfig.cmake extra libmysql Makefile mysys scripts support-files zlib<br>client cmd-line-utils <a href="http://configure.am">configure.am</a> CTestTestfile.cmake include libmysqld Makefile.am netware sql tests<br>
cmake config configure.cmake dbug install_manifest.txt libmysql_r Makefile.in plugin sql-bench unittest<br><br><br><br><br>