Replace MariaDB With MySQL In XAMPP - Tutorial In Bangla

-----------------------------------------
MySQL INI File Content:
-----------------------------------------
[mysqld]
# Set basedir to your installation path
basedir=c:/xampp/mysql

# Set datadir to the location of your data directory
datadir=c:/xampp/mysql/data

# Default: 128 MB
# New: 1024 MB
innodb_buffer_pool_size = 1024M

# Default since MySQL 8: caching_sha2_password
default_authentication_plugin=mysql_native_password

[client]
ssl-mode=DISABLED

------------------------------------------------------
MySQL Initialization Command:
------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------
MySQL Change Root Password And Authentication Type Commands:
-------------------------------------------------------------------------------------------------------------------
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'YourPasswordHere';
FLUSH PRIVILEGES;
EXIT;

[subhajitsarkar]

getting error after changing all the files. it's showing 'stopped unexpectedly'

[MyPoetryCafe]

i don't understand Bangal, 😪😪 but if I had followed every step and fixed it, thank you.

[ahmadmuhadi]

--initialize-insecure --basedir=c:\xampp\mysql
'mysqld.exe' is not recognized as an internal or external command,
operable program or batch file.

how to fix it?

[shaghayeghizadpanah]

thank you so much. I replace MariaDB with mysql8 successfully, but one question: when I stop my mysql and close the xampp, after starting again, I got the access denied error. why?

[Mitnickjr]

Thank you so much bro. You are a life saver

[shrutianpat]

But we're this MySQL ini file is located

[byakushiki]

You lost me at 8:00, I thought I was following correctly until I don't know what is that

[abdullaalmamun]

after initial cmd command __
Error: MySQL shutdown unexpectedly.
7:55:13 PM [mysql] This may be due to a blocked port, missing dependencies,
7:55:13 PM [mysql] improper privileges, a crash, or a shutdown by another method.
7:55:13 PM [mysql] Press the Logs button to view error logs and check
7:55:14 PM [mysql] the Windows Event Viewer for more clues
7:55:14 PM [mysql] If you need more help, copy and post this
7:55:14 PM [mysql] entire log window on the forums