Notes: MariaDb Sequence

1. Create a sequence

CREATE SEQUENCE [Name of Sequence]

2. Get next sequence id

nextval([Name of Sequence])

Reference

https://mariadb.com/kb/en/create-sequence/

Notes: MariaDb setup

MariaDb Setup

/etc/mysql/maria.conf.d/50-server.cnf

comment out:

bind-address = 127.0.0.1



Check Configurations

On db server, open shell (mysql -u root -p)

Run query, SELECT User, Host FROM mysql.user

Google Cloud Setup

VPC Network
Firewall Rules

Direction: Ingress
Source Filters: IP Address of device accessing db server
Applicable to instances: permission to users