[CMake] unistall a mysql src with CMake

Érico ericomtx at gmail.com
Fri Nov 16 11:58:57 EST 2012 

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 at ericomtx bin]# pwd
/usr/bin
[root at 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 at 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 at 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 at ericomtx bin]#


.... also ... you may say to me so I need to create the DB from my install
dir ... ok :

[root at 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!

......

I wanted to uninstall it ... and install it back with the correct source
flags now ....

How can I run cmake to unistall this ... ? I still have the uncompressed
dir from the the installation :

[root at ericomtx mysql-5.5.4-m3]# ls
aclocal.m4   CMakeCache.txt       config.guess     configure.in
depcomp               install-sh          libservices      man
pstack     sql-common     vio
BUILD        CMakeFiles           config.h.cmake   COPYING
Docs                  INSTALL-SOURCE      ltmain.sh        missing
README     storage        win
BUILD-CMAKE  cmake_install.cmake  config.sub       CPackConfig.cmake
EXCEPTIONS-CLIENT     INSTALL-WIN-SOURCE  make_dist.cmake  mysql-test
regex      strings        ylwrap
ChangeLog    CMakeLists.txt       configure        CPackSourceConfig.cmake
extra                 libmysql            Makefile         mysys
scripts    support-files  zlib
client       cmd-line-utils       configure.am     CTestTestfile.cmake
include               libmysqld           Makefile.am      netware
sql        tests
cmake        config               configure.cmake  dbug
install_manifest.txt  libmysql_r          Makefile.in      plugin
sql-bench  unittest
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.cmake.org/pipermail/cmake/attachments/20121116/94ac06f8/attachment.htm>

More information about the CMake mailing list