* [gentoo-user] mysql_upgrade access rights
@ 2012-05-11 23:20 99% Mick
0 siblings, 0 replies; 1+ results
From: Mick @ 2012-05-11 23:20 UTC (permalink / raw
To: Gentoo-User
After I update mysql I usually run:
$ mysqlcheck --all-databases --check-upgrade -u root -p
and it completes fine.
However, if I try 'mysql_upgrade -u root --password=XXXXXX' it fails
at the end like so:
$ mysql_upgrade -v -h localhost -u root --password=XXXXXX
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck' with connection arguments: '--port=3306'
'--socket=/var/run/mysqld/mysqld.sock' '--host=localhost'
Running 'mysqlcheck' with connection arguments: '--port=3306'
'--socket=/var/run/mysqld/mysqld.sock' '--host=localhost'
Krecipes.author_list OK
Krecipes.authors OK
Krecipes.categories OK
Krecipes.category_list OK
Krecipes.db_info OK
Krecipes.ingredient_groups OK
[snip ....]
Running 'mysql_fix_privilege_tables'...
OK
Could not create the upgrade info file
'/var/lib/mysql/mysql_upgrade_info' in the MySQL Servers datadir,
errno: 13
The strange thing is that running the mysql_fix_privilege_tables
command by hand succeeds!
$ mysql_fix_privilege_tables -v -u root --password=XXXXXX
This script updates all the mysql privilege tables to be usable by
the current version of MySQL
done
I'm not sure I understand why this happens. I even created the file
/var/lib/mysql/mysql_upgrade_info by hand and chowned it to
mysql:mysql, but still comes up with the same error. The file stays
empty:
ls -la /var/lib/mysql/mysql_upgrade_info
-rw-rw---- 1 mysql mysql 0 May 12 01:03 /var/lib/mysql/mysql_upgrade_info
Any ideas?
--
Regards,
Mick
^ permalink raw reply [relevance 99%]
Results 1-1 of 1 | reverse | options above
-- pct% links below jump to the message on this page, permalinks otherwise --
2012-05-11 23:20 99% [gentoo-user] mysql_upgrade access rights Mick
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox