MySQL upgrade

[Jim Douglas]

>From: Boris Glawe <boris at boris-glawe.de>
>Reply-To: For users of Fedora Core releases <fedora-list at redhat.com>
>To: For users of Fedora Core releases <fedora-list at redhat.com>
>Subject: Re: MySQL upgrade
>Date: Wed, 08 Mar 2006 18:22:06 +0100
>
>
>>
>>
>>I was following those instruction and it said..
>>
>>user mysql does not exist, using root
>>
>>Is this a security problem ?  Should I cread a mysql user and rebuild -bb?
>>
>>Thanks,
>>Jim
>>
>>
>no, it's no problem.
>
>The instructions on the specified link are very complicated.
>
>Simply download the MySQL...src.rpm and build it with
>
>rpmbuil --rebuild MSQL....src.rpm
>
>greets Boris
>
>--
>fedora-list mailing list
>fedora-list at redhat.com
>To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list

When I run,

mysql_fix_privilege_tables --password=XXXXXXX

I get this,

This script updates all the mysql privilege tables to be usable by
MySQL 4.0 and above.

This is needed if you want to use the new GRANT functions,
CREATE AGGREGATE FUNCTION, stored procedures, or
more secure passwords in 4.1

You can safely ignore all 'Duplicate column' and 'Unknown column' errors
because these just mean that your tables are already up to date.
This script is safe to run even if your tables are already up to date!

ERROR 2002 (HY000): Can't connect to local MySQL server through socket 
'car/lib/mysql/mysql.sock' (111)
Got a failure from command:
cat /usr/share/mysql/mysql_fix_privilege_tables.sql | /usr/bin/mysql 
--no-defaults --force --user=root --host=localhost --password=mypassword 
--database=mysql
Please check the above output and try again.

If you get an 'Access denied' error, you should run this script again and
give the MySQL root user password as an argument with the --password= option


I tried,
mysql_fix_privilege_tables --password=XXXXXXX
mysql_fix_privilege_tables --password='XXXXXXX
mysql_fix_privilege_tables --password="XXXXXXX"'

When does this socket get created?

Jim