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!
How I resolved Mariadb first installation issues
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.
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
Code: Select all
#adduser mysql
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