[NTLUG:Discuss] SOLVED: Re: Still NO Mysql - Is there at least a MySQL Mailing list?

[Stephen Davidson]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

There is probably a better solution, but I was unable to find one.

NOTE: This will blow away all local users and Datatables, but will leave
you a running instance.  Do not attempt this mechanism unless you have
backed up any data that you want to keep.

Solution:
1) Remove ALL Mysql packages from system.  (Possible corruption from
earlier attempts and upgrades).
(NOTE: This ONLY removes Binaries, not data, config, or other files).
2) Delete ALL Data files.  By default, this would be the files in
/var/lib/mysql (for good measure, delete the directory as well).  In my
installation, I could not find any other data files for MySQL.
3) Create an /etc/my.cnf file, with the following contents;
[mysqld]
tmpdir          = /tmp/mysql
[mysql.server]
tmpdir          = /tmp/mysql
[safe_mysqld]
tmpdir          = /tmp/mysql

4) Install from scratch.
5) (Optional, but recommended)
/usr/bin/mysql_secure_installation (Sets a password for the root mysql
user, among other things)

Last step, reload from the backups made prior to the delete.  Make sure
that if one had set any file links for data directories, etc., that they
are recreated as needed.

Apparently, the initial upgrade from 5.0 - 5.1 using rpm -U resulted in
corrupt mysql config & security files.

It does appear that mysql dumps from MySQL 5.0 are not necessarily
compatible with 5.1 though, so still working on actually restoring data.

Regards,
Steve

Stephen Davidson wrote:
> Greetings.
> 
> I am now on Day 5 of trying to get a usable MySQL 5.1 install.  I could
> REALLY use some Mysql help right now.  All that Googling has been doing
> is listing a bunch of "me too" posts, but no solutions.  (The offer to
> pay somebody to get this working for me is STILL open!)
> 
> Specifically, MySQL is still not usuable.  I eventually figured out the
> last problem was several things;
> 1) No /tmp/mysql directory
> 2) No my.cnf file created installed anywhere
> 3) Attempts to write to /tmp/root by the mysql user, which did not have
> any privileges.
> 
> So, I can now start it (I think, at least there is a running process)
> using /etc/init.d, but I can't log on using ANY user whatsover;
> steve at sda64:~> mysql -u mysql
> ERROR 1045 (28000): Access denied for user 'mysql'@'localhost' (using
> password: NO)
> 
> Using user ROOT, steve, or anything else also fails with similar error
> messages.
> 
> MySQL reference documentation suggests that the Root user password
> should be modified, and gives instructions for starting mysql from the
> command line, followed by additional instructions to change the password.
> 
> The first command, after shutting down the server;
> sda64:~ # su -c "/usr/sbin/mysqld --skip-grant" mysql &
> [1] 21513
> sda64:~ #
> [1]+  Exit 1                  su -c "/usr/sbin/mysqld --skip-grant" mysql
> sda64:~ #
> 
> There are no messages logged.
> 
> I don't even know where to start looking for this one.
> 
> Any suggestions/help would be welcome. If you know of anyone that might
> have some ideas, it would be appreciated if you could forward this email
> to them.  After 5 days of beating my head against the wall on this with
> no end in sight, I would be happy to pay somebody for help.
> 
> Regards,
> Steve

_______________________________________________
http://www.ntlug.org/mailman/listinfo/discuss

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.4-svn0 (GNU/Linux)
Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org

iD8DBQFJoeN5SphIUSiVzgYRAnDXAJ98f2bpkWAfG6KVuaU7SOpMw9Ue9ACfeDNG
/Cqks6z/Uj9/Y72Ar0UDQBg=
=S7cA
-----END PGP SIGNATURE-----