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]

Reply via email to