Am Saturday 20 December 2003 17:21 schrieb ads mysql: > Yes I could uninstall mysql with > > rpm -qa | grep MySQL > ("MYSQL" should be in Uppercase. I tried same with > lower case earlier) Therefore has not worked. > Anyway Thanks lot. > > I once again tried to install myssql with > > [EMAIL PROTECTED] root]# rpm -i > MySQL-server-4.0.16-0.i386.rpm > > [EMAIL PROTECTED] root]# rpm -i > MySQL-client-4.0.16-0.i386.rpm > warning: MySQL-client-4.0.16-0.i386.rpm: V3 DSA > signature: NOKEY, key ID 5072e1f5
At this point, you need to start the sever. Did you do this? (/etc/init.d/mysql start) > [EMAIL PROTECTED] root]# /usr/bin/mysqladmin -u root > password 'adsh1956' > /usr/bin/mysqladmin: connect to server at 'localhost' > failed > error: 'Can't connect to local MySQL server through > socket '/var/lib/mysql/mysql.sock' (2)' > Check that mysqld is running and that the socket: > '/var/lib/mysql/mysql.sock' exists! > > Some more help is needed. > Thanks for support. > > --- Mike Blezien <[EMAIL PROTECTED]> wrote: > > This is what we did. > > > > root [~] #rpm -qa | grep MySQL > > MySQL-client-4.0.15-0 > > MySQL-embedded-4.0.15-0 > > MySQL-devel-4.0.15-0 > > MySQL-shared-compat-4.0.15-0 > > MySQL-shared-4.0.15-0 > > MySQL-server-4.0.15-0 > > > > # Now remove the RPM's > > rpm -e --nodeps MySQL-server-4.0.15-0 > > rpm -e --nodeps MySQL-embedded-4.0.15-0 > > rpm -e --nodeps MySQL-devel-4.0.15-0 > > rpm -e --nodeps MySQL-shared-4.0.15-0 > > rpm -e --nodeps MySQL-shared-compat-4.0.15-0 > > rpm -e --nodeps MySQL-client-4.0.15-0 > > > > this should remove MySQL without any problems. > > > > hope it helps, > > > > -- > > Mike<mickalo>Blezien > > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= > > Thunder Rain Internet Publishing > > Providing Internet Solutions that work! > > http://www.thunder-rain.com > > Quality Web Hosting > > http://www.justlightening.net > > MSN: [EMAIL PROTECTED] > > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= > > > > ads mysql wrote: > > > Hi, > > > I tried as you advised. But no luck. > > > [EMAIL PROTECTED] root]# rpm -qa | grep mysql > > > [EMAIL PROTECTED] root]# rpm -qa | grep mysql > > > [EMAIL PROTECTED] root]# ps ax | grep mysqld > > > 854 ? S 0:00 /bin/sh > > > > /usr/bin/mysqld_safe --datadir=/var/lib/mysql > > > > > 884 ? S 0:00 /usr/sbin/mysqld > > > > --basedir=/ --datadir=/var/lib/mysql > > > > > 8406 pts/0 S 0:00 grep mysqld > > > > > > I want to unistall mysql since thre is no data > > > > into it. > > > > > Please guide me to do so in this situation.. > > > Thanks for support. > > > > > > > > > > > > Victoria Reznichenko > > > > <[EMAIL PROTECTED]> wrote: > > > ads mysql wrote: > > >>I tried as advised as follows : > > >>I tried to uninstall mysql rpm as > > >>rpm -e /var/lib/mysql > > >>It gives following. > > >>[EMAIL PROTECTED] root]# rpm -e /var/lib/mysql > > >>error: package /var/lib/mysql is not installed > > > > > > /var/lib/mysql is not a package, it's MySQL data > > > > dir. > > > > >>[EMAIL PROTECTED] root]# rpm -e > > > > MySQL-server-4.0.16-0.i386.rpm > > > > >>error: package MySQL-server-4.0.16-0.i386.rpm is > > > > not installed > > > > >>[EMAIL PROTECTED] root]# rpm -e > > > > MySQL-client-4.0.16-0.i386.rpm > > > > >>error: package MySQL-client-4.0.16-0.i386.rpm is > > > > not installed > > > > >>[EMAIL PROTECTED] root]# rpm -i > > > > MySQL-server-4.0.16-0.i386.rpm > > > > >>warning: MySQL-server-4.0.16-0.i386.rpm: V3 DSA > > > > signature: NOKEY, key ID 5072e1f5 > > > > >>package MySQL-server-4.0.16-0 is already installed > > >>[EMAIL PROTECTED] root]# rpm -i > > > > MySQL-client-4.0.16-0.i386.rpm > > > > >>warning: MySQL-client-4.0.16-0.i386.rpm: V3 DSA > > > > signature: NOKEY, key ID 5072e1f5 > > > > >>package MySQL-client-4.0.16-0 is already installed > > > > > > You can see which packages are installed with: > > > rpm -qa | grep mysql > > > > > >>[EMAIL PROTECTED] root]# /etc/init.d/mysql restart > > >>No mysqld pid file found. Looked for > > > > /var/lib/mysql/shastrihallweb.pid. > > > > >>[EMAIL PROTECTED] root]# Starting mysqld daemon with > > > > databases from /var/lib/mysql > > > > >>031219 22:38:14 mysqld ended > > >> > > >>Since I could not Uninstall and tried to > > > > reinstall. But didn't worked out. > > > > >>Then tried as follows : > > >> > > >>First I moved mysql by mv /var/lib/mysql > > > > /var/lib/mysql_old > > > > >>Then tried "mysql_install_db" > > >> > > >>[EMAIL PROTECTED] root]# mysql_install_db > > >>Installing all prepared tables > > >>031219 22:40:56 /usr/sbin/mysqld: Shutdown > > > > Complete > > > > >>To start mysqld at boot time you have to copy > > > > support-files/mysql.server > > > > >>to the right place for your system > > >>PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL > > > > root USER ! > > > > >>This is done with: > > >>/usr/bin/mysqladmin -u root password > > > > 'new-password' > > > > >>/usr/bin/mysqladmin -u root -h shastrihallweb > > > > password 'new-password' > > > > >>See the manual for more instructions. > > >>NOTE: If you are upgrading from a MySQL <= 3.22.10 > > > > you should run > > > > >>the /usr/bin/mysql_fix_privilege_tables. Otherwise > > > > you will not be > > > > >>able to use the new GRANT command! > > >>You can start the MySQL daemon with: > > >>cd / ; /usr/bin/mysqld_safe & > > >>You can test the MySQL daemon with the benchmarks > > > > in the 'sql-bench' directory: > > >>cd sql-bench ; perl run-all-tests > > >>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 > > > > https://order.mysql.com > > > > >>[EMAIL PROTECTED] root]# mysql > > >>ERROR 2002: Can't connect to local MySQL server > > > > through socket '/var/lib/mysql/mysql.sock' (2) > > > > >>[EMAIL PROTECTED] root]# mysqld > > >>031219 22:41:58 Can't start server: Bind on TCP/IP > > > > port: Address already in use > > > > >>031219 22:41:58 Do you already have another mysqld > > > > server running on port: 3306 ? > > > > >>031219 22:41:58 Aborting > > >>031219 22:41:58 mysqld: Shutdown Complete > > >> > > >>I tried to stop running mysql as follows: > > >>[EMAIL PROTECTED] root]# /var/lib/mysql stop > > >>ERROR 2002: Can't connect to local MySQL server > > > > through socket '/var/lib/mysql/mysql.sock' (2) > > > > >>I tried to restart as follows ; > > >>[EMAIL PROTECTED] mysql]# mysql restart > > >>ERROR 2002: Can't connect to local MySQL server > > > > through socket '/var/lib/mysql/mysql.sock' (2) > > > > >>It's confusing for me. > > >>Please guide me step by step to use mysql in this > > > > case. I tried to go through documentation but bit > > difficult to understand for newbe like me. > > > > > Check if MySQL server is running: > > > ps ax | grep mysqld > > > > > > If so, find where mysql.sock is located. > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > __________________________________ > Do you Yahoo!? > New Yahoo! Photos - easier uploading and sharing. > http://photos.yahoo.com/ -- Stefan Kuhn M. A. Cologne University BioInformatics Center (http://www.cubic.uni-koeln.de) Zülpicher Str. 47, 50674 Cologne Tel: +49(0)221-470-7428 Fax: +49 (0) 221-470-7786 My public PGP key is available at http://pgp.mit.edu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]