Feel free to use this page to experiment with the Text Formatting Rules. Just click the "Edit Page" link at the bottom of the page.
Mariadb Installation and Basic commands
MariaDB is a replacement for Oracle MySQL servers. It is a multithreaded SQL database with a command syntax very similar to mSQL. This page shows how to install MariaDB server on OpenBSD.
There are two packages
- mariadb-server – The MariaDB server.
- mariadb-client – The client side of MariaDB server including mysqlclient library and headers for the MariaDB client API.
We will only install and mariadb-server
$ doas pkg_add curl $ doas pkg_add mariabd-server
curl is a one of the dependency package for mariadb-server.
Now we need to configure mariadb to run.
open open /etc/my.cnf with your regular editor
$ vi open /etc/my.cnf
Uncommnet the bold lines
change the above line to
Run the following command
Initialize MariaDB data directory
The above command is for initialising You need to run mysql_install_db command. It initialises the MariaDB data directory and creates the system tables:
Now start mariadb
$ doas rcctl enable mysqld $ doas rcctl start mysqld mysqld(ok)
To check if you mariadb is running run following command
$ ps -aux | grep mysqld
you will see a line pops up as follow:
root 94120 0.0 0.2 1016 1040 p0 Sp 10:40AM 0:00.02 /bin/sh /usr/local/bin/mysqld_safe
We are good to go..its running
Mariadb database creation and user privileges commands
To connect to mariadb console
$ mysql -u root -p
Create a new database:
MariaDB> create database DATABASE_NAME;
Create a new user (only with local access) and grant privileges to this user on the new database:
MariaDB> grant all privileges on DATABASE_NAME.* TO 'USER_NAME'@'localhost' identified by 'PASSWORD';
Create a new user (with remote access) and grant privileges to this user on the new database:
MariaDB> grant all privileges on DATABASE_NAME.* TO 'USER_NAME'@'%' identified by 'PASSWORD';
After modifying the MariaDB grant tables, execute the following command in order to apply the changes:
MariaDB> flush privileges;
other commands add user : CREATE USER 'user1'@localhost IDENTIFIED BY 'password1'; database list: SHOW DATABASES; grant access : GRANT ALL PRIVILEGES ON 'yourDB'.* TO 'user1'@localhost;
No Error Happy days =)