• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Should i upgrade to Mysql 5.1???

Umit

Active member
#1
Hi, should i upgrade to mysql 5.1?

my provider says
There are a couple of concerns with MySQL 5.1, user names over 16 characters will be truncated, and downgrades are not possible.
So, is it worth to upgrade? my current version is
Client API version 5.0.91
 

Walter

Well-known member
#2
I use MySQL 5.1 on all my servers without any problem. 5.1 now is more than 2 years old.

Regarding the username issue: MySQL has long had a limitation of 16 chars for the username. In older versions the server would accept longer names during login, but with 5.1 the server will truncate the user name and reject login. The solution is simple: rename longer names. But this shouldn't be an issue at all because the 16 char limit was in place for a long time. See http://dev.mysql.com/doc/refman/5.1/en/user-names.html