"What are some issues that users may encounter when upgrading from MySQL 4.0 to MySQL 5.0?
"Scott Noyes: Here are a few common problems:
"MySQL service will not start.
"The service starts, but no programs can connect. Make sure that the user has permissions to connect to the server.
"Queries that worked in earlier versions no longer work. MySQL implemented a few syntax changes with version 5. Of particular note is the change in JOIN syntax..."