Fwd: Updating from MySQL 4.0.12 to 5.0.67 Community

2008-12-02 Thread Bai Shen
sage -- From: Bai Shen <[EMAIL PROTECTED]> Date: Tue, Dec 2, 2008 at 10:25 AM Subject: Re: Updating from MySQL 4.0.12 to 5.0.67 Community To: mysql@lists.mysql.com But I didn't create any privileges in the old system. That's where I'm confused. When I install 4, I

Re: Updating from MySQL 4.0.12 to 5.0.67 Community

2008-12-01 Thread Chandru
Hi Bai, In case you want the privileges of the old system, please take a backup of the mysql database as inserts and reimport the same in the upgraded server. If you want a new admin user to be created, then please check the below page for the syntax: http://dev.mysql.com/doc/refman/5.0/en/grant.h

Re: Updating from MySQL 4.0.12 to 5.0.67 Community

2008-12-01 Thread Claudio Nanni
Hi Bai, I think the best option is to read carefully the installation guide, there are some post installation steps to set up initial privileges, and everything is explained quite well. After that if you still have problems please provide more informations on platform and other points like the s

Updating from MySQL 4.0.12 to 5.0.67 Community

2008-12-01 Thread Bai Shen
I currently have an application that runs on MySQL 4.0.12. I'd like to update it to the newest version of MySQL so I can have multiple applications using the one database. However, I'm running into some permissions problems. When I install MySQL 4.0.12 I set up an administrator user. Then I run