Somebody has shutdown the cobalt server without shutdown of the mysql server. How is it possible to restart the Mysql server ?

Its better to configure Mysql to start with boot of your server. If you using webmin go to System > Bootup and Shutdown > mysqld
and select radio button Start at boot time? yes.

Originally posted by jsmit
Somebody has shutdown the cobalt server without shutdown of the mysql server. How is it possible to restart the Mysql server ?

The most common way on Cobalts is:

1. Log in as root.

2. Execute this command:

/etc/rc.d/init.d/mysql start

That should start up mysql.

It gives the following result:


[root users]# /etc/rc.d/init.d/mysql start [root users]# Starting mysqld daemon with databases from /var/lib/mysql mysqld daemon ended

[root users]#
[root users]# mysql
ERROR 2002: Can't connect to local MySQL server (146)

[root users]#

Originally posted by jsmit
It gives the following result:


[root users]# /etc/rc.d/init.d/mysql start [root users]# Starting mysqld daemon with databases from /var/lib/mysql mysqld daemon ended

[root users]#
[root users]# mysql
ERROR 2002: Can't connect to local MySQL server (146)

[root users]#

The "mysqld daemon ended" means that there is an error.

Check the MySQL logfile to see, what's wrong.

011024 5:55:09 Found old style password for user 'root'. Restart using --old-$mysqld ended on Wed Oct 24 05:55:09 CEST 2001

??????

Originally posted by jsmit
011024 5:55:09 Found old style password for user 'root'. Restart using --old-$mysqld ended on Wed Oct 24 05:55:09 CEST 2001

??????

You probably tried to set the root password on MySQL, and forgot to encrypt the password :-(

Try starting MySQL without using the grant tables, and then go in and change the MySQL root password.

I ran into the same problem on my cobalt. For the life of me, I couldn't get it back up. The skip grant tables never ever worked for me. Best to remove MySQL, and re-install. At least thats what I did.

This is the situation I am in...How would you remove and reinstall MySQL on a Cobalt 550 where it comes preinstalled ?
thanks,

Originally posted by Pingouin
This is the situation I am in...How would you remove and reinstall MySQL on a Cobalt 550 where it comes preinstalled ?
thanks,

Think this is how you do it, i think..Shell into your cobalt

cd /var/lib/cobalt/uninstallers

ls (list the files see whats there)

if MySQL3 it would be something like this

./MySQL.3-23.x-x.uninst

and it uninstalls MySQL

then reinstall

Thank you; in the meantime I did manage to bypass the priv table and get MySQL to its initial state.


thanks again;

check the mysql socket exists... otherwise you wont be able to connect