From: Boris Glawe <boris@xxxxxxxxxxxxxx>
Reply-To: For users of Fedora Core releases <fedora-list@xxxxxxxxxx>
To: For users of Fedora Core releases <fedora-list@xxxxxxxxxx>
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@xxxxxxxxxx
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
