پاسخ : درخواست آموزش بروز رسانی MYSQL در cPanel
الان برات از سی پنل می پرسم
اگه جاییشو باید برات معنیکنم بگو
---------- Post added at 03:45 PM ---------- Previous post was at 03:20 PM ----------
woshka says:
December 20th, 2009 at 05:53 AM
one of my friends wants to upgrade its mysql to 5.1
he would go to software and update mysql and select mysql 51 and click next
but he encounteres 8 steps ahead of hm that all are containing various configration
could you please explain me each step to tell him which is right for hi to choose
thanks
Nicholas Foos says:
December 20th, 2009 at 06:08 AM
Hello,
2: MySQL has limited usernames to 16 characters for many years. In versions of MySQL prior to 5.1, when a login username longer that 16 characters was sent to the server it was silently truncated to the 16 characters limit. In MySQL 5.1, all characters submitted for the username are checked during authentication. This change means that any user submitting more than 16 characters as their login username will fail to authenticate once the server is upgraded. To correct this problem, only send the first 16 characters of the login username.
- You will need to make sure that any database users do not have a username longer than 16 characters. The following command should list any such users:
mysql -e 'select User,Host from user where Length(User) > 16;' mysql
Although in place upgrades of MySQL are generally safe, it is always recommended that you perform a full database backup before beginning the upgrade process.
- You must create backups of all databses prior to upgrading in case something bad happens.
Please note that downgrades to previous versions of MySQL are unsupported. Once your system has been upgraded to a newer version of MySQL it may be impossible to switch back.
- Once you upgrade to 5.1 you may not be able to go back to 5.0
3: The default selection should be fine which brings you to step 8 - the actual upgrade.
پاسخ با نقل قول