CellSpace/Manual (draft)
by CellWorks
Home
  
Table of Contents
  
Glossary
MariaDB
Database
on
Slackware
This section describes setting up the
MariaDB
database
for use with a
CellSpace
Server
using
Slackware
or a similar
Unix
.
  • It is assumed that the
    MariaDB
    database
    has been previously installed.
  • See
    go2linux.garron.me
     for help with the
    MariaDB
    Database
    installation.
  • See
    dev.mysql.com
     for the
    MariaDB
    commands.
  • First verify that
    MariaDB
    server is running.
  • Type: 
  • > ps -ef|grep mysql
  • You should get a response like: 
  •   ... /usr/libexec/mysqld ...
  • Insure that the following is commented out in /etc/rc.d/rc.mysqld. 
  •   SKIP="--skip-networking"
  • Network access to the
    MariaDB
    database
    will be disabled when the SKIP line is enabled.
  • Don't forget to restart the database server after changing the rc.mlsqld file. Use the command: 
  • > /etc/rc.d/rc.mysqld restart
  • Verify that the
    MariaDB
    command line tool is available.
  • Type: 
  • > which mysql
  • You should get a response like: 
  •  /usr/bin/mysql
  • Then login to
    MariaDB
    . 
  • > mysql -u root -p
  • Next create the
    CellSpace
    database catalog.
  • Replace [my_catalog] with an appropriate catalog name.
  • At the prompt: 
  • MariaDB [(none)]> CREATE DATABASE my_catalog;
  • Add the administrative database user, set the password and grant access. This user id will be used to create, index as well as access and update the
    CellSpace
    tables.
  • Replace [my_database_user], [my_database_password] and [some_host] with appropriate credentials and
    hostname
    .
  • At the prompt: 
  • MariaDB [(none)]> CREATE USER 'my_database_user'@'some_host';
MariaDB [(none)]> SET PASSWORD FOR 'my_database_user'@'some_host'=PASSWORD('my_database_password');
MariaDB [(none)]> GRANT CREATE, INDEX, SELECT, INSERT, UPDATE on my_catalog.* TO 'my_database_user'@'some_host';
  • At this point you can launch the
    CellSpace
    Server
    to complete the online installation.