How I resolved Mariadb first installation issues

How to do things, solutions, recipes, tutorials
Post Reply
Message
Author
kachro
Posts: 1
Joined: Sat 23 Nov 2013, 06:03

How I resolved Mariadb first installation issues

#1 Post by kachro »

Slacko Puppy 6.3

5.5.32-MariaDB-30.2

I was doing a first time install of Puppy and MariaDB

I had issues getting to a clean setup which others may hit so here is some info that could help. The information is available on various sites and I found resolutions by trial and error on options others had suggested.

I used Puppy Package Manager to install MariaDB

PATH variable was updated by the install and I did not have to change it

These are the directories used by MariaDB on Puppy installations:

/etc/my.cnf.d (config files)
/var/lib/mysql (logs....)
/var/run/mysql (mysql.sock....)
/usr/bin (execs and scripts - mysqld_safe; mysql_config...)
/usr/lib/mysql/plugin
/usr/share/mysql (examples, templates?)

Set Owner 'mysql' and Group 'root' on the directories. (May have security implications)

Copied an appropriate template /usr/share/mysql/my_xxxx.cnf to my.cnf in /etc/my.cnf.d

Used this option to start mysqld. It started, but with table errors reported in the log.
mysqld_safe --skip-grant-table

Initially tried to
mysql_upgrade
but that failed - 'FATAL ERROR: Upgrade failed'

Recreated mysql table with
mysql_install_db --user=mysql
which ran OK.

Reran
mysql_upgrade
which also ran OK

Started
mysqld_safe
with no errors


180617 11:47:31 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
180617 11:47:31 InnoDB: The InnoDB memory heap is disabled
180617 11:47:31 InnoDB: Mutexes and rw_locks use GCC atomic builtins
180617 11:47:31 InnoDB: Compressed tables use zlib 1.2.6
180617 11:47:31 InnoDB: Using Linux native AIO
180617 11:47:31 InnoDB: Initializing buffer pool, size = 256.0M
180617 11:47:31 InnoDB: Completed initialization of buffer pool
180617 11:47:31 InnoDB: highest supported file format is Barracuda.
180617 11:47:31 InnoDB: Waiting for the background threads to start
180617 11:47:32 Percona XtraDB (http://www.percona.com) 5.5.32-MariaDB-30.2 started; log sequence number 1597971
180617 11:47:32 [Note] Plugin 'FEEDBACK' is disabled.
180617 11:47:32 [Note] Server socket created on IP: '0.0.0.0'.
180617 11:47:32 [Note] Event Scheduler: Loaded 0 events
180617 11:47:32 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.32-MariaDB-log' socket: '/var/run/mysql/mysql.sock' port: 3306 MariaDB Server

Hope it helps!

User avatar
rockedge
Posts: 1864
Joined: Wed 11 Apr 2012, 13:32
Location: Connecticut, United States
Contact:

#2 Post by rockedge »

I have to add the user "mysql" before installation of mariadb and I need to create /var/run/mysqld and set the directory permissions to the user "mysql" this I did also for the mysql installation.

Code: Select all

#adduser mysql
I run Hiawatha 10.8.1 mariaDB PHP 7.2.5 on Tahr or Xenial and now Bionic.
This is for systems that will run ZoneMinder
I install Apache (if not using Hiawatha) and all the LAMP compnonts with the PPM except for Hiawatha which I download and install the Debian .deb version with petget

Post Reply