example code for mysql.

list.
root@debian:/home/stretch# [code]
ls /var/lib/mysql
mysql -u root --password=d;
SHOW DATABASES;
SELECT User,Host FROM mysql.user;
SHOW GRANTS FOR 'dotuser'@'localhost';
quit
exit
[code]

create table.
root@debian:/home/stretch# [code]
mysql -u root --password=d;
CREATE DATABASE IF NOT EXISTS testdb;
CREATE USER 'testuser'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON testdb.* TO testuser@localhost;
FLUSH PRIVILEGES;
USE testdb;
CREATE TABLE products (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255), price DECIMAL(6,2));
INSERT INTO products (name, price) VALUES ('MacBook Pro', 1600.0);
INSERT INTO products (name, price) VALUES ('Dell', 850.0);
INSERT INTO products (name, price) VALUES ('Acer', 775.0);
SELECT * FROM products;
quit
exit[/code]

Remove old items that might conflict with new install.	
[code]
mysql -u root --password=d;
REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'testuser'@'localhost';
DROP USER 'testuser'@'localhost';
DROP DATABASE IF EXISTS testdb;
quit;
exit
[/code]