I have done following as advised : [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 8295 pts/0 S 0:00 grep mysqld
No response for [EMAIL PROTECTED] root]# rpm -qa | grep mysql. I will prefer to uninstall mysql since it does not have any data. Thanks for support --- Victoria Reznichenko <[EMAIL PROTECTED]> wrote: > ads mysql <[EMAIL PROTECTED]> 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. > > > -- > For technical support contracts, goto > https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net > http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Victoria Reznichenko > / /|_/ / // /\ \/ /_/ / /__ > [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net > <___/ www.mysql.com > > > > > > -- > 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]
