[opensuse] MySQL from scratch
Suse 11.0 Somehow the MySQL db has gotten completely hosed - thankfully I no active db's How do I re-install MySQL to get usage of the DB - including setting the root password ? Thanks, Duaine -- Duaine Hechler Piano, Player Piano, Pump Organ Tuning, Servicing & Rebuilding Reed Organ Society Member Florissant, MO 63034 (314) 838-5587 dahechler@att.net www.hechlerpianoandorgan.com -- Home & Business user of Linux - 10 years -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Duaine & Laura Hechler wrote:
Suse 11.0
Somehow the MySQL db has gotten completely hosed - thankfully I no active db's
How do I re-install MySQL to get usage of the DB - including setting the root password ?
Reinstall the mysql packages, then use mysqladmin to set the password. -- Per Jessen, Zürich (1.6°C) -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Per Jessen wrote:
Duaine & Laura Hechler wrote:
Suse 11.0
Somehow the MySQL db has gotten completely hosed - thankfully I no active db's
How do I re-install MySQL to get usage of the DB - including setting the root password ?
Reinstall the mysql packages, then use mysqladmin to set the password.
Installed packages, rebooted and: hechler:~ # /usr/bin/mysqladmin -u root password 'root' /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! Duaine -- Duaine Hechler Piano, Player Piano, Pump Organ Tuning, Servicing & Rebuilding Reed Organ Society Member Florissant, MO 63034 (314) 838-5587 dahechler@att.net www.hechlerpianoandorgan.com -- Home & Business user of Linux - 10 years -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Per Jessen wrote:
Duaine & Laura Hechler wrote:
Suse 11.0
Somehow the MySQL db has gotten completely hosed - thankfully I no active db's
How do I re-install MySQL to get usage of the DB - including setting the root password ?
Reinstall the mysql packages, then use mysqladmin to set the password.
Installed packages, rebooted and: hechler:~ # /usr/bin/mysqladmin -u root password 'root' /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! Duaine hechler:~ # ls /var/lib/mysql -al total 1 drwxr-xr-x 4 mysql mysql 144 Mar 5 03:09 . drwxr-xr-x 42 root root 1104 Mar 5 03:09 .. drwx------ 2 mysql mysql 48 Sep 19 10:25 .protected -rw-r--r-- 1 mysql mysql 0 Mar 5 03:09 .run-mysql_upgrade drwxr-xr-x 2 mysql mysql 48 Sep 19 10:25 .tmp -- Duaine Hechler Piano, Player Piano, Pump Organ Tuning, Servicing & Rebuilding Reed Organ Society Member Florissant, MO 63034 (314) 838-5587 dahechler@att.net www.hechlerpianoandorgan.com -- Home & Business user of Linux - 10 years -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Thursday, 2009-03-05 at 08:39 +0100, Per Jessen wrote:
Duaine & Laura Hechler wrote:
Suse 11.0
Somehow the MySQL db has gotten completely hosed - thankfully I no active db's
How do I re-install MySQL to get usage of the DB - including setting the root password ?
Reinstall the mysql packages, then use mysqladmin to set the password.
To get a clean install, I think you need to remove the database files before reinstallation - assuming there is nothing there, of course. - -- Cheers, Carlos E. R. -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.9 (GNU/Linux) iEYEARECAAYFAkmvpqgACgkQtTMYHG2NR9UKhwCeMm5c7ceMIbBHWOmohYLZJ0jV tWMAn0eSh0l8ixal8js6NTXKlFRp2a3E =mD3w -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
participants (3)
-
Carlos E. R.
-
Duaine & Laura Hechler
-
Per Jessen