Re: [cobalt-users] mySQL nightmare

["Steve Werby" <steve-lists@xxxxxxxxxxxx>]

"Paul Brown" <paulb@xxxxxxxxxxxx> wrote:
> Since my co-locator installed mySQL I have had nightmares
> with it. Now in the end I either have the wrong root
> password

For instructions on accessing MySQL without the root user password in order
to change it see my post at
http://marc.theaimsgroup.com/?l=cobalt-users&m=99343077721320&w=2.

> or I cannot connect from any host.

After you get into the mysql commandline inspect the user and and db tables
in the mysql database:

SELECT * FROM mysql.users; SELECT * FROM mysql.db;

and consult the MySQL manual at www.mysql.com to see whether your privileges
are setup properly.

> or advise me on how to uninstall mySQL without the mySQL password.

If it was installed from an RPM you can do rpm -e [rpm_name] to uninstall
it.  If it was installed from source you'd have to manually locate all the
files and delete them.  In any case if you want to reinstall MySQL I suggest
doing so from the source tarball and you don't need to remove the old files
first.  I recommend installing the latest stable version, though if you must
install an older version make sure it's at least version 3.23.x.

--
Steve Werby
President, Befriend Internet Services LLC
http://www.befriend.com/