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
[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
[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.
Thanks for support.
Victoria Reznichenko <[EMAIL PROTECTED]> wrote:
ads mysql wrote:
>
> I have intstalled mysql rpm.
> By mistake user table entries are deleted. Therefore I could not access mysql.
>
> I want uninstall the same and reinstall it.
>
If you want to re-create privilege tables you should move directory 'mysql' to another
place and then run mysql_install_db script:
http://www.mysql.com/doc/en/mysql_install_db.html
--
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!?
New Yahoo! Photos - easier uploading and sharing
