Project

General

Profile

Support #379

Install MariaDB Database Server On FreeBSD

Added by Daniel Curtis over 6 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Database Server
Target version:
Start date:
04/26/2014
Due date:
% Done:

100%

Estimated time:
1.50 h
Spent time:

Description

Install MariaDB

Install MariaDB from pkg

Install MariaDB:

pkg install mariadb55-{server,client}

Build MariaDB from Source

  • Install MariaDB, this will also build the MariaDB client:
    cd /usr/ports/databases/mariadb55-server/
    make config ; make install clean
    rehash
    

Configure MariaDB

  • Edit rc.conf to start MariaDB at boot:
    vi /etc/rc.conf
    
  • Add mysql_enable

mysql_enable="YES"

  • Manually start MariaDB:
    service mysql-server start
    

Setup grant tables, make sure to have the MariaDB server running since mysql_install_db assumes its running from here:

cd /usr/local/
mysql_install_db --user=mysql

  • Configure the MariaDB server root password:
    mysql_secure_installation
    
    1. (Optional) Configure MariaDB server root password manually:
      mysqladmin -u root password 'appleton'
      mysqladmin -u root -p -h firefly.scc.local password 'appleton'
      
    2. (Optional) Grant root permission to connect remotely:
      mysql -u root -p
      mysql> grant all privileges on *.* to 'root'@'%' identified by 'appleton' with grant option;
      mysql> exit;
      

Configure MariaDB Server

Use the provided my-medium.cnf config file and edit for using InnoDB tables:

The output from “my_print_defaults –help” implies my-medium.cnf should copied to /etc/my.cnf, but I’ll use the MySQL convention I’ve learned until I know different.

cp /usr/local/share/mysql/my-medium.cnf /var/db/mysql/my.cnf
vi /var/db/mysql/my.cnf

#! Uncomment the following if you are using InnoDB tables
innodb_data_home_dir = /var/db/mysql
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /var/db/mysql
#! You can set .._buffer_pool_size up to 50 - 80 %
#! of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 16M
innodb_additional_mem_pool_size = 2M
#! Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50

  • Restart MariaDB:
  1. service mysql-server restart
  • And finally do a basic test to confirm things are basically working:
    mysql -u root -p
    

MariaDB [(none)]> show databases;
MariaDB [(none)]> exit;
Bye

History

#1 Updated by Daniel Curtis over 6 years ago

  • Description updated (diff)

#2 Updated by Daniel Curtis over 6 years ago

  • Status changed from Resolved to Closed

#3 Updated by Daniel Curtis over 5 years ago

  • Project changed from 82 to FreeBSD Administration
  • Category set to Database Server
  • Target version set to FreeBSD 9

Also available in: Atom PDF