Cutsom install mariaDB

Cutsom install for mariaDB on Ubuntu server or desktop

Custom tutorial for MariaDB on Ubuntu.

Before we begin we need to update our apt packages with
```
sudo apt updates
```
After we updates our packages we can install mariadb-server
```
sudo apt install mariadb-server
```
Now MariaDB server is installed we can check if it’s running
```
sudo systemctl status mariadb
```

Now we need to secure our MariaDB so type
```
sudo mysql_secure_installation
```
It will start with asking for root password for mariadb, just press enter

Use start for starting the server
```
sudo systemctl start mariadb
```
Use stop For stopping the server
```
sudo systemctl stop mariadb
```
Use restart For restarting the server
```
sudo systemctl restart mariadb
```
Use status For checking te status of server
```
sudo systemctl status mariadb
```

Now we going to configure the mariadb server and securing it by the following steps

sudo mysql_secure_installation

BE NOTED THIS WILL BE FIXED SOME TIME… BUT NOW NOW

Only localhost is allowd to connect…

CREATE USER 'local_user'@'localhost' IDENTIFIED BY 'password';

Now you can login from any IP to your

CREATE USER 'local_user'@'%' IDENTIFIED BY 'password';

This will allow you only to login from specific IP

CREATE USER 'local_user'@'192.168.1.1' IDENTIFIED BY 'password';

Replace syslogine with your own enw created used and replace localhost if want.

GRANT ALL PRIVILEGES ON *.* TO 'syslogine'@'localhost' WITH GRANT OPTION;

cd /etc/mysql



LOLLLLLLLLLLLL

Last modified February 21, 2024: ... (784391f)