I have confirmed that this dump causes the problem. To reproduce:
1. apt-get install mysql-server-5.0
2. /etc/init.d/mysql reset-password
3. update the database to accept connections from anywhere for root:
mysql> update user set host='%' where user='root' and host='hostname here';
mysql> flush privileges;
('hostname here' should be substituted with what is found with 'select
host,user from user;'
4. now restore from the dump with:
mysql -u root -p < ./dump
5. trigger with:
$ mysql -u root -p
use information_schema;
select * from TABLES;
** Changed in: mysql-dfsg-5.0 (Ubuntu)
Status: Incomplete => Confirmed
--
problem afer upgrade to mysql 5.0.22-0ubuntu6.06.8
https://bugs.launchpad.net/bugs/209699
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu.
--
Ubuntu-server-bugs mailing list
Ubuntu-server-bugs@lists.ubuntu.com
Modify settings or unsubscribe at:
https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
