Problem solve
Get help with specific problems with your technologies, process and projects.
Upgrade issues in MySQL 5.0
MySQL expert Scott Noyes describes several possible upgrade issues that may be preventing MySQL 5.0 from working properly.
I have upgraded to MySQL 5.0 on my Linux server. It was working fine with MySQL 4.0, but now it doesn't work at all. Could you please help me figure out what is wrong?
"Not working" can mean many things. 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.
See also the upgrade guide.
Dig Deeper on Linux servers
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our Data Center experts
View all Data Center questions and answers
Start the conversation
0 comments