MySql

------

Install and Configure MySQL Server

#  sudo apt-get install mysql-server mysql-client -y

sudo apt update && sudo apt install mysql-server

systemctl start mysql

systemctl enable mysql

 # mysql_secure_installation

   Enter current password for root (enter for none):     Set root password? [Y/n]: y     Remove anonymous users? [Y/n]: Y     Disallow root login remotely? [Y/n]: Y     Remove test database and access to it? [Y/n]:  Y     Reload privilege tables now? [Y/n]:  Y

mysql -u root -p

Install MariaDB 10.3 on Ubuntu 18.04

sudo apt-get install software-properties-common

sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8

sudo add-apt-repository 'deb [arch=amd64] http://mirror.zol.co.zw/mariadb/repo/10.3/ubuntu bionic main'

sudo apt update

sudo apt -y install mariadb-server mariadb-client

$ sudo systemctl status mysql

#  mysql -u root -p

MariaDB [(none)]> select version();

                             SELECT User,Host FROM mysql.user;

MariaDB [(none)]> exit

sudo systemctl stop mariadb.service      

sudo systemctl start mariadb.service     

sudo systemctl restart mariadb.service 

sudo systemctl status mariadb.service

# mysql -V

                -----------------------------

sudo mysql -u root -p

Create a database called “nextclouddb”

create database nextclouddb;

Grant “nextclouduser” to access the “nextclouddb” database on localhost with a password “password“.

grant all on nextclouddb.* to 'nextclouduser'@'localhost' identified by 'password';

Exit from the MariaDB prompt.

quit

                    --------------------------------------

Change User Passwd

SET PASSWORD FOR 'phpmyadmin'@'localhost' = PASSWORD('xxxxx');

FLUSH PRIVILEGES;

exit

Remove/Delete the user 

mariadb> DROP USER 'phpmyadmin'@'localhost';

mariadb> DROP USER phpmyadmin;

sudo systemctl daemon-reload

sudo systemctl restart mysql

sudo systemctl status mariadb

------