Puppy Linux Discussion Forum

[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!

[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.