# how can we directly upgrade mysql from 5.5.x to 5.7.x

**URL:** <https://forums.percona.com/t/how-can-we-directly-upgrade-mysql-from-5-5-x-to-5-7-x/5483>\
**Category:** Other MySQL® Questions\
**Created:** [March 14, 2017, 12:38pm UTC](https://forums.percona.com/t/how-can-we-directly-upgrade-mysql-from-5-5-x-to-5-7-x/5483 "2017-03-14T12:38:18Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mail2virtusolabs](https://avatars.discourse-cdn.com/v4/letter/m/b5e925/32.png) [@mail2virtusolabs](https://forums.percona.com/u/mail2virtusolabs)\
**Post date:** [March 14, 2017, 12:38pm UTC](https://forums.percona.com/t/how-can-we-directly-upgrade-mysql-from-5-5-x-to-5-7-x/5483/1 "2017-03-14T12:38:18Z")

</div>

I heard that MYSQL can be upgraded like 5.5.x to 5.6.x to 5.7.x but not direct upgrade to higher version  
But I am thinking of doing dump and load of all the user database and extract users and update the same in new version databases

What is the best practice. Can any one help me on providing complete steps (if soemone have them handy)

Thanks in advance for your help. being new to MySQL trying to learn more

---

<div class="post-metadata">

**Author:** ![przemek](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/przemek/32/3_2.png) [@przemek](https://forums.percona.com/u/przemek)\
**Post date:** [April 2, 2017, 12:25pm UTC](https://forums.percona.com/t/how-can-we-directly-upgrade-mysql-from-5-5-x-to-5-7-x/5483/2 "2017-04-02T12:25:09Z")

</div>

Officially, it is unsupported to upgrade by skipping one or more major versions. However, in case of logical (SQL dump and restore) method, it should work. You may also use pt-show-grants for dumping users instead of importing non-compatible mysql database.  
More details: [url][MySQL :: MySQL 5.7 Reference Manual :: 2.11 Upgrading MySQL](https://dev.mysql.com/doc/refman/5.7/en/upgrading.html#upgrade-paths%5B/url%5D)