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/
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
Not working on server OS It working on client OS?
I've tried updating to 10.5.3 version, but it hasn't worked. Someone help me, please!
upgraded successfully but, mysql service cannot be stopped !!
Thankyou! I did it
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
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
Why PhpMyadmin ask for a user and password? if i don't have it.
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.
Still helped me at this time! Thanks for this great video!
Thank you so much, I got it. You save my day my 48 hour, and help me a lot.
Thank you very much, I have successfully upgraded.
Thank you very much for your contribution.
Thanks for your detailed explanation, that made it easy to understand.
Greetings from the Republic of Ecuador …
I need to update mysql version from 5.0 to 5.6 how can I do this ?
Muchisimas Gracias :'')
Thank you man!!
Thank you.
THANK YOU THANK YOU THANK YOU
U ARE GOD
Nice tutorial. But this did not have to be a fucking 18 min video!
thank you for sharing this !