|
MySQL error when booting linux
Hello,
I recently did an upgrade on my whole system. Everytime I boot linux I get the following msg on the screen, concerning MySQL:
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 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Got a failure from command:
cat /usr/share/mysql/mysql_fix_privilege_tables.sql | /usr/bin/mysql --no-defaults --force --user=root --host=localhost --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
freakbox:~# cat /usr/share/mysql/mysql_fix_privilege_tables.sql | /usr/bin/mysql --no-defaults --force --user=root --host=localhost --database=mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
When I type "mysql_fix_privilege_tables --password=blabla", it does work. What could be the problem that it is not doing it all automaticly and doesn't seem to have access with the root host, because I am able to login mysql with phpmyadmin and add databases, edit tables etc.
Help would be really appreciated, thanks in advance.
|
