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]