# MySQL / MariaDB ## New User ```sql CREATE USER 'ladmin'@'localhost' IDENTIFIED BY 'fed0f644-99aa-11eb-87bd-000c292cee00'; GRANT ALL PRIVILEGES ON *.* TO 'ladmin'@'localhost'; flush privileges; ``` ```bash sed -i 's/utf8mb4_0900_ai_ci/utf8mb4_unicode_ci/g' all.sql ```# Fix Broken ```bash sudo systemctl stop mysql sudo rm -rf /var/lib/mysql/* sudo mysql_install_db sudo systemctl start ``` ```bash sudo /usr/bin/mysqld_safe --user=mysql --skip-grant-tables sudo mysql_upgrade --force ``` # MySQL / MariaDB ## New User ```sql CREATE USER 'ladmin'@'localhost' IDENTIFIED BY 'fed0f644-99aa-11eb-87bd-000c292cee00'; GRANT ALL PRIVILEGES ON *.* TO 'ladmin'@'localhost'; flush privileges; ``` ```bash sed -i 's/utf8mb4_0900_ai_ci/utf8mb4_unicode_ci/g' all.sql ```