Le Monday 26 June 2006 00:13, Christian Hammers(Christian Hammers <[EMAIL PROTECTED]>) a écrit: > tags 375373 + moreinfo upstream > stop > > Hello
Hi,
> Before I report this to MySQL I would like to verify it but
> currently it seems to work with sql_mode=ansi in /etc/mysql/my.cnf
> "[mysqld]" block.
> Can you give me more information on what exactly failed and which
> error message you got?
I wasn't able to figure out what went wrong. But the bug was
reproducible :
- Do a fresh install of mysql with "apt-get install
mysql-server=4.0.24-10sarge1"
- Backup the mysql database !
- Edit /etc/mysql/my.cnf and and "sql-mode='ANSI" to the [mysqld]
section.
- Upgrade mysql-server to 5.0.22-3 (I didn't tired with the Etch
release...)
- Login to mysql and try to do a grant. I get 'ERROR 1045 (28000):
Access denied for user 'glenny'@'localhost' (using password: YES)'.
- drop the mysql database and restore previous backup.
- Edit /usr/share/mysql/mysql_fix_privilege_tables.sql and add "set
@@session.sql_mode='MYSQL40' ;" at top of the file.
- delete mysql_upgrade.info (the default location
is /var/lib/mysql/)
- Restart the server. The grant works correctly.
I was unable figure error. Commenting "sql-mode='ANSI'" and
restarting the server or sourcing the
script 'mysql_fix_privilege_tables.sql' didn't fix the problem.
I think there is something wird
in /usr/share/mysql/mysql_fix_privilege_tables.sql.
Maybe I'm wrong and missed something, but if you can confirm this
bug, this means upgrade from Sarge to Etch may be quite hard...
Hope this helps !
--
Glennie
"D'abord ils vous ignorent, ensuite ils vous raillent, ensuite ils
vous combattent et, enfin, vous gagnez"
pgpzk4Zodnr3n.pgp
Description: PGP signature
