[Bug 209699] Re: problem afer upgrade to mysql 5.0.22-0ubuntu6.06.8

[Jamie Strandboge]

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.