Recent Changes - Search:
Main /

WikiSandbox

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

  1. mariadb-server – The MariaDB server.
  2. 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

[client-server]

socket=/var/run/mysql/mysql.sock

change the above line to

socket=/var/www/var/run/mysql/mysql.sock

port=3306

bind-address=0.0.0.0

data=/var/mysql

save

Run the following command 

$ mysql_install_db

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: 

$ mysql_install_db

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 =)