GRANT ALL PRIVILEGES ON *.* TO WITH GRANT OPTION CREATE USER IDENTIFIED BY " mysecretpassword" Once you’ve logged in, we create our new Administrative user via MySQL/MariaDB cli, take note of the bold words, don’t forget to use unique values if copy and pasting. Log into MariaDB and create our Database Administrative user. Service apache2 restart Install PHPMyAdmin apt install phpmyadmin -y apt install php php-common php-mysql php-gd php-cli -y We are using this server strictly for MariaDB, to make things simple, we can install our OS’s native PHP version, in Debian 11’s case that would be PHP 7.4. Reload privilege tables now? (Answer: y) Install Apache2 apt install apache2 -y Install PHP Remove test database and access to it? (Answer: y) Remove anonymous users? (Answer: y)ĭisallow root login remotely? (Answer: n) When prompted… Switch to unix_socket authentication (Answer: n)Ĭhange the root password? (Answer: n) Then apt install mariadb-server mariadb-client -y Installing MariaDB 10.5 apt update apt upgrade -yĪpt -y install curl software-properties-common gnupg2īash mariadb_repo_setup -mariadb-server-version=10.5
0 Comments
Leave a Reply. |