READ8-mariadb.md

General MariaDB Help and HowTo's

---> Back to the README file with the Table of Contents.

Initiation of Database for Dabar

• Fix login of initial database, mariadb:

  • The my.cnf file must actually by mariadb.cnf, in the folder /etc/mysql, on the docker instance.

  • add bind_address=0.0.0.0 to mariadb.cnf,

  • If using image bianjp/mariadb-alpine, then add this to ansible env: MYSQL_ALLOW_EMPTY_PASSWORD=yes

    • After 1st startup this can be changed:

  • To setup root password, 1st time - Login to DB server:

    • if on Docker docker exec -it dbr_mariadb_1 sh,
    • mysql -uroot
    • SELECT User, Host FROM mysql.user WHERE Host <> 'localhost'; (to see if root is available)
    • GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'rootpassword' WITH GRANT OPTION;
    • flush privileges;

  • To check GRANTS: show grants for 'root'@'%' ;

  • Check if port 3306 is running: from db command line: SHOW GLOBAL VARIABLES LIKE 'PORT'; or from Linux: netstat -tlnp

  • with Node-RED connected to the mariadb via a 'link', the host field on Node-RED is the container name dbr_mariadb_1

HowTo's

• Checking the version, log into the client, or just do an SQL call. SELECT VERSION() ;
• Which my.cnf is my mariadb using?: mysqld --verbose --help | grep -A 1 "Default options"
• Create a mysql backup read-only user blog bencane

User Mgt from Command Line

• Display users: SELECT User,Host FROM mysql.user;
• Delete a user: DROP USER 'root'@'localhost';
• Create a user: CREATE USER 'root'@'%' IDENTIFIED BY '-password-';
• Grant all privileges: GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';
• Clean up: FLUSH PRIVILEGES;

MariaDB from docker

• Problems with stopping the container

  docker stop --time=30 mariadbtest docker kill mariadbtest

---> Back to the README file with the Table of Contents.