Do I have to uninstall OS to reinstall mysql for my problem.? Please guide me. Thanks for support. ads mysql <[EMAIL PROTECTED]> wrote: 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 [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 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, > > -- > MikeBlezien > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= > 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 > 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!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- 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