| Home |
Linux KBs |
Windows 10 KBs |
Contact Page |
Install MariaDB
sudo apt update
#update system
sudo apt install mariadb-server
#installs mariadb
sudo mysql_secure_installation
#interactively securing installation of mysql
sudo systemctl start mariadb.service
#uses system control to start mariadb
sudo mysql_secure_installation
#redundant
sudo mariadb
#opens mariadb
GRANT ALL ON *.* TO 'admin' IDENTIFIED BY 'testing' WITH GRANT OPTION;
#grants permissions
FLUSH PRIVILEGES;
#flushes
exit
#goodbye
sudo systemctl status mariadb
#checks status of mariadb
sudo mysqladmin version
#check verison of mysql
mysqladmin -u admin -p version
#redundant
sudo su
#makes current user super user (needs privileges)
nano /etc/mysql/my.cnf
#opens text editor to edit config file mysql
add a line; bind-address = 0.0.0.0
ctl+x to exit
y to save
#adds the line and saves
ss -ltpn
#checks to see if 3306 is listening
