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]
