Skip to navigation
Set a root password to a running mariadb database
06.06.18
1. install mariadb apt-get install mariadb 2. setup mariadb with root password a. stop mariadb: /etc/init.d/mysql stop b. start safe-mode: mysqld_safe --skip-grant-tables & c. login: mysql d. switch to mysql database: use mysql e. set a root password: UPDATE user SET password=PASSWORD("my-password") WHERE User='root'; d. prevent non password root login: update user set plugin='' where User='root'; f. activate and exit: FLUSH PRIVILEGES; quit;
Reply
Anonymous
Information Epoch 1732668092
Use lower case and keep it short.
Home
Notebook
Contact us