How to Update MySQL (MariaDB) in XAMPP Local Server



Learn with me How to Update Your MySQL (Upgrade MariaDB) in XAMPP. This is the Easiest and Secure Way for Update XAMPP in any Windows Version

Step by Step XAMPP Tutorials for Beginners Installation, Upgrade and Apache error Solution (for Windows 7/8/10).

Step №1. First for Security Backup Your MySQL Database. MariaDB upgrading Process Will Secure 100%

Step №2. Download Mariadb Latest Version (zip file). Choose File with Your PC ability 32 or 64 bit

Step №3. Stop Apache and MySQL in XAMPP Control Panel ( Stop All Services)

Step №4. Rename MySQL Folder Name in c Drive Like This Folder Path C:xamppmysql_OLD

Step №5. Extract downloaded mariadb.zip file in to XAMPP Folder and rearrange the folder path

Step №6. Open xampp & xampp_OLD folder side by side

Step №7. Rename this data folder as you like. I’ll rename it like this: data_New_for-DEL

Step №8. From left side Copy “data” folder(C:xamppmysql_OLDdata) to right side in (C:xamppmysql)

Step №9. From left side Copy “backup” folder(C:xamppmysql_OLDbackup) to right side in
(C:xamppmysql)

Step №10. From left side Copy “scripts” folder (C:xamppmysql_OLDbackup) to right side in (C:xamppmysql)

Step №11. From left side Copy this 2 files (mysql_installservice.bat and mysql_uninstallservice.bat ) to right side in (C:xamppmysql)

Step №12. From left side Copy my.ini file(C:xamppmysql_OLDbin) to right side in (C:xamppmysqlbin)

Step №13. In right side make some change in “my.ini” file,
(C:xamppmysqlbin) Make sure you have “#” sing before “skip-federated”

Step №14. In right side Again edit “my.ini” file, Put this line of code “skip-grant-tables” anywhere and save

Step №15. In right side Find “mysql.upgrade.exe” file (inC:xamppmysqlbin) and double click on it. it will update automatically. don’t close black widow

Step №16. In right side Again go to “my.ini” file, delete this line of code “innodb_additional_mem_pool_size = 2M” and save

Step №17. In right side Now delete this folder “data_New_for-DEL”

Step №18. In left side Now delete this folder “mysql_OLD”

Congratulation! You Successfully Updated MySQL – MariaDB
==============================================
MariaDB Download Link

=============================================
Easily Update Your XAMPP Local Server for Windows 7 8 10 [Full Series ] There are Other XAMPP Tutorials Available Below:
…………………………………………………………………………..
How to Update phpMyAdmin in XAMPP (№1)

How to Update PHP Version in XAMPP (№2)

How to Install XAMPP for Windows 7/8/10 and Configuration with Tomcat, Mercury and Filezilla (Full) [Update Nov. 2018]

==============================================

Follow Me with Your Favourite Social Media
…………………………………………..

#UpdateMySQL #UpgradeMySQL #XAMPPMySQL

Nguồn: https://dwaynewadejersey.net/

Xem thêm bài viết khác: https://dwaynewadejersey.net/giai-tri/


Article Categories:
Giải Trí

Comments

  • I was unable to run migration in my Laravel project as there was 'JSON' type data type in the migration file.
    This video help me to upgrade mysql version in xampp and now it's working. Thanks

    Arman Ul Alam July 22, 2020 8:09 pm Reply
  • Not working on server OS It working on client OS?

    Nishit Kawane July 22, 2020 8:09 pm Reply
  • I've tried updating to 10.5.3 version, but it hasn't worked. Someone help me, please!

    Roberto Hebert de Souza Vinha July 22, 2020 8:09 pm Reply
  • upgraded successfully but, mysql service cannot be stopped !!

    MOHIT July 22, 2020 8:09 pm Reply
  • Thankyou! I did it

    SP July 22, 2020 8:09 pm Reply
  • On the start i was like yeah this is gonna okay i guess, then he shows everything very well. Then i had a problem but he solved it later on , great tutorial still works in 30-3-2020

    Tao Olocan July 22, 2020 8:09 pm Reply
  • please help me
    Mysql.proc is wrong and it tell me to upgrade it but i don't know how to do it.
    I search a lot but dont see any really solve my problem.
    I currently use Lampp (Xampp) on Ubuntu.. Please help

    BlankHat July 22, 2020 8:09 pm Reply
  • Why PhpMyadmin ask for a user and password? if i don't have it.

    Ernesto Ascencio July 22, 2020 8:09 pm Reply
  • Thanks for sharing. But im got a problem on that. I cant stop the mysql connection. Only can start, and cant stop. Somebody please help me.

    Wan Azmi July 22, 2020 8:09 pm Reply
  • Still helped me at this time! Thanks for this great video!

    Naaman Numansen July 22, 2020 8:09 pm Reply
  • Thank you so much, I got it. You save my day my 48 hour, and help me a lot.

    Hein Htet Aung July 22, 2020 8:09 pm Reply
  • Thank you very much, I have successfully upgraded.

    Keerthi Kamarthi July 22, 2020 8:09 pm Reply
  • Thank you very much for your contribution.

    Thanks for your detailed explanation, that made it easy to understand.

    Greetings from the Republic of Ecuador …

    Javier Gonzalez July 22, 2020 8:09 pm Reply
  • I need to update mysql version from 5.0 to 5.6 how can I do this ?

    JSP Brasil TI July 22, 2020 8:09 pm Reply
  • Muchisimas Gracias :'')

    Mario Luis July 22, 2020 8:09 pm Reply
  • Thank you man!!

    Desarrollo Rehobot July 22, 2020 8:09 pm Reply
  • Thank you.

    254Rent July 22, 2020 8:09 pm Reply
  • THANK YOU THANK YOU THANK YOU

    Ham Tezat July 22, 2020 8:09 pm Reply
  • U ARE GOD

    Nikhil N July 22, 2020 8:09 pm Reply
  • Nice tutorial. But this did not have to be a fucking 18 min video!

    anZter11 July 22, 2020 8:09 pm Reply
  • thank you for sharing this !

    Duy Lai July 22, 2020 8:09 pm Reply

Leave a Comment

Your email address will not be published. Required fields are marked *