MariaDB

After MySQL / MariaDB successfully installed, may be you want to give remote access to the server. Lets say the database server’s IP is 192.168.10.105, and you have web server at 192.168.10.100 so what you must to do is, open the terminal and: vi /etc/my.cnf.d/server.cnf uncomment #bind-address and fill it with your MySQL server’s IP bind-address=192.168.10.105 save … Read more

Create User: create user ‘user’@’localhost’ identified by ‘password’; Create Database: create database monitoring; Assign user to database monitoring: grant all privileges on monitoring . * to ‘user’@’localhost’; monitoring adalah: nama databasenya, * berarti semua table nya Terakhir: flush privileges; Notes: GRANT [type of permission] ON [database name].[table name] TO ‘[username]’@’localhost’; REVOKE [type of permission] ON … Read more