Hi! ini catatan saja, biar ndak lupa, bagaimana cara menginstall MariaDB dan PHPMyAdmin.
sudo apt install mariadb-server
Untuk custom lokasi database, hapus semua file di dalam directory berikut
cd /var/lib/mysql
sudo rm -r *
Lakukan instalasi/setup mariadb dengan configurasi baru
sudo mysql_install_db --basedir=/usr --datadir=/home/zed/Development/mariadb
Resultnya gini
2024-01-26 14:18:57 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
OK
To start mariadbd at boot time you have to copy
support-files/mariadb.service to the right place for your system
Two all-privilege accounts were created.
One is root@localhost, it has no password, but you need to
be system 'root' user to connect. Use, for example, sudo mysql
The second is root@localhost, it has no password either, but
you need to be the system 'root' user to connect.
After connecting you can set the password, if you would need to be
able to connect as any of these users with a password and without sudo
See the MariaDB Knowledgebase at https://mariadb.com/kb
You can start the MariaDB daemon with:
cd '/usr' ; /usr/bin/mariadb-safe --datadir='/home/zed/Development/mariadb'
You can test the MariaDB daemon with mysql-test-run.pl
cd '/usr/share/mysql/mysql-test' ; perl mariadb-test-run.pl
Please report any problems at https://mariadb.org/jira
The latest information about MariaDB is available at https://mariadb.org/.
Consider joining MariaDB's strong and vibrant community:
https://mariadb.org/get-involved/
Jalankan mariadb dan servicenya
sudo systemctl start mysqld
sudo systemctl start mysql.service
sudo systemctl start mariadb.service
Lihat statusnya, apakah sudah aktif apakah tidak?
sudo systemctl status mariadb.service
Lanjutkan dengan setup awal akses
sudo mysql_secure_installation
Jangan lupa setting priviliges di mysql
GRANT ALL ON *.* TO 'admin'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION
Instal phpmyadmin
sudo apt install phpmyadmin