Mysql broken, apparently self-replaced by Mariadb

jvieille · May 24, 2021, 10:57am

Mysql suddenly stopped running this morning.
I got this error:
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2 “No such file or directory”)
Virtuamin mentions now Mariadb, I am pretty sure it was Mysql before
Looking at cnf files, a new mariadb.cnf dated of today was here, including mariadb.conf.d and conf.d, but not mysql.conf.d where my mysql configuration is.
Including my cnf file does not help, nor adding user = root as it was suggested for solving other errors I noticed.
service mysql status shows that mysql is running, but mariadb service does not exist.
mysql -V returns
mysql Ver 15.1 Distrib 10.1.48-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

Hows it possible that Mariadb (badly) replaces Mariadb without warning ?
How to get things back working with my existing databases ?
Thanks for help!

PS: content of mysql error.log during the period the problem occured. The log is silent since that.
2021-05-24T09:11:04.671272Z 0 [Note] Giving 1 client threads a chance to die gracefully
2021-05-24T09:11:04.671507Z 0 [Note] Shutting down slave threads
2021-05-24T09:11:06.671592Z 0 [Note] Forcefully disconnecting 0 remaining clients
2021-05-24T09:11:06.671636Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2021-05-24T09:11:06.672071Z 0 [Note] Binlog end
2021-05-24T09:11:06.678189Z 0 [Note] Shutting down plugin ‘auth_socket’
2021-05-24T09:11:06.678216Z 0 [Note] Shutting down plugin ‘ngram’
2021-05-24T09:11:06.678219Z 0 [Note] Shutting down plugin ‘partition’
2021-05-24T09:11:06.678222Z 0 [Note] Shutting down plugin ‘BLACKHOLE’
2021-05-24T09:11:06.678226Z 0 [Note] Shutting down plugin ‘ARCHIVE’
2021-05-24T09:11:06.678228Z 0 [Note] Shutting down plugin ‘PERFORMANCE_SCHEMA’
2021-05-24T09:11:06.678248Z 0 [Note] Shutting down plugin ‘MRG_MYISAM’
2021-05-24T09:11:06.678254Z 0 [Note] Shutting down plugin ‘MyISAM’
2021-05-24T09:11:06.678259Z 0 [Note] Shutting down plugin ‘INNODB_SYS_VIRTUAL’
2021-05-24T09:11:06.678262Z 0 [Note] Shutting down plugin ‘INNODB_SYS_DATAFILES’
2021-05-24T09:11:06.678265Z 0 [Note] Shutting down plugin ‘INNODB_SYS_TABLESPACES’
2021-05-24T09:11:06.678267Z 0 [Note] Shutting down plugin ‘INNODB_SYS_FOREIGN_COLS’
2021-05-24T09:11:06.678270Z 0 [Note] Shutting down plugin ‘INNODB_SYS_FOREIGN’
2021-05-24T09:11:06.678272Z 0 [Note] Shutting down plugin ‘INNODB_SYS_FIELDS’
2021-05-24T09:11:06.678275Z 0 [Note] Shutting down plugin ‘INNODB_SYS_COLUMNS’
2021-05-24T09:11:06.678277Z 0 [Note] Shutting down plugin ‘INNODB_SYS_INDEXES’
2021-05-24T09:11:06.678280Z 0 [Note] Shutting down plugin ‘INNODB_SYS_TABLESTATS’
2021-05-24T09:11:06.678282Z 0 [Note] Shutting down plugin ‘INNODB_SYS_TABLES’
2021-05-24T09:11:06.678285Z 0 [Note] Shutting down plugin ‘INNODB_FT_INDEX_TABLE’
2021-05-24T09:11:06.678287Z 0 [Note] Shutting down plugin ‘INNODB_FT_INDEX_CACHE’
2021-05-24T09:11:06.678289Z 0 [Note] Shutting down plugin ‘INNODB_FT_CONFIG’
2021-05-24T09:11:06.678292Z 0 [Note] Shutting down plugin ‘INNODB_FT_BEING_DELETED’
2021-05-24T09:11:06.678294Z 0 [Note] Shutting down plugin ‘INNODB_FT_DELETED’
2021-05-24T09:11:06.678297Z 0 [Note] Shutting down plugin ‘INNODB_FT_DEFAULT_STOPWORD’
2021-05-24T09:11:06.678299Z 0 [Note] Shutting down plugin ‘INNODB_METRICS’
2021-05-24T09:11:06.678301Z 0 [Note] Shutting down plugin ‘INNODB_TEMP_TABLE_INFO’
2021-05-24T09:11:06.678304Z 0 [Note] Shutting down plugin ‘INNODB_BUFFER_POOL_STATS’
2021-05-24T09:11:06.678306Z 0 [Note] Shutting down plugin ‘INNODB_BUFFER_PAGE_LRU’
2021-05-24T09:11:06.678308Z 0 [Note] Shutting down plugin ‘INNODB_BUFFER_PAGE’
2021-05-24T09:11:06.678311Z 0 [Note] Shutting down plugin ‘INNODB_CMP_PER_INDEX_RESET’
2021-05-24T09:11:06.678313Z 0 [Note] Shutting down plugin ‘INNODB_CMP_PER_INDEX’
2021-05-24T09:11:06.678316Z 0 [Note] Shutting down plugin ‘INNODB_CMPMEM_RESET’
2021-05-24T09:11:06.678318Z 0 [Note] Shutting down plugin ‘INNODB_CMPMEM’
2021-05-24T09:11:06.678321Z 0 [Note] Shutting down plugin ‘INNODB_CMP_RESET’
2021-05-24T09:11:06.678323Z 0 [Note] Shutting down plugin ‘INNODB_CMP’
2021-05-24T09:11:06.678325Z 0 [Note] Shutting down plugin ‘INNODB_LOCK_WAITS’
2021-05-24T09:11:06.678337Z 0 [Note] Shutting down plugin ‘INNODB_LOCKS’
2021-05-24T09:11:06.678340Z 0 [Note] Shutting down plugin ‘INNODB_TRX’
2021-05-24T09:11:06.678342Z 0 [Note] Shutting down plugin ‘InnoDB’
2021-05-24T09:11:06.679130Z 0 [Note] InnoDB: FTS optimize thread exiting.
2021-05-24T09:11:06.679247Z 0 [Note] InnoDB: Starting shutdown…
2021-05-24T09:11:06.779446Z 0 [Note] InnoDB: Dumping buffer pool(s) to /home/mysql/ib_buffer_pool
2021-05-24T09:11:06.795331Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 210524 11:11:06
2021-05-24T09:11:08.950531Z 0 [Note] InnoDB: Shutdown completed; log sequence number 470052395402
2021-05-24T09:11:08.950723Z 0 [Note] InnoDB: Removed temporary tablespace data file: “ibtmp1”
2021-05-24T09:11:08.950732Z 0 [Note] Shutting down plugin ‘MEMORY’
2021-05-24T09:11:08.950737Z 0 [Note] Shutting down plugin ‘CSV’
2021-05-24T09:11:08.950742Z 0 [Note] Shutting down plugin ‘sha256_password’
2021-05-24T09:11:08.950752Z 0 [Note] Shutting down plugin ‘mysql_native_password’
2021-05-24T09:11:08.951817Z 0 [Note] Shutting down plugin ‘binlog’
2021-05-24T09:11:08.959302Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2021-05-24T10:04:46.849618Z 0 [Warning] Ignoring user change to ‘mysql’ because the user was set to ‘root’ earlier on the command line

2021-05-24T10:04:46.849689Z 0 [Warning] ‘NO_ZERO_DATE’, ‘NO_ZERO_IN_DATE’ and ‘ERROR_FOR_DIVISION_BY_ZERO’ sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2021-05-24T10:04:46.850738Z 0 [Note] mysqld (mysqld 5.7.34-0ubuntu0.18.04.1-log) starting as process 26441 …
2021-05-24T10:04:46.876162Z 0 [Note] InnoDB: PUNCH HOLE support available
2021-05-24T10:04:46.876193Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-05-24T10:04:46.876197Z 0 [Note] InnoDB: Uses event mutexes
2021-05-24T10:04:46.876201Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2021-05-24T10:04:46.876205Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-05-24T10:04:46.876209Z 0 [Note] InnoDB: Using Linux native AIO
2021-05-24T10:04:46.876413Z 0 [Note] InnoDB: Number of pools: 1
2021-05-24T10:04:46.876493Z 0 [Note] InnoDB: Using CPU crc32 instructions
2021-05-24T10:04:46.877522Z 0 [Note] InnoDB: Initializing buffer pool, total size = 20G, instances = 8, chunk size = 128M
2021-05-24T10:04:47.717937Z 0 [Note] InnoDB: Completed initialization of buffer pool
2021-05-24T10:04:47.873790Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-05-24T10:04:47.880404Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2021-05-24T10:04:48.353977Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-05-24T10:04:48.354042Z 0 [Note] InnoDB: Setting file ‘./ibtmp1’ size to 12 MB. Physically writing the file full; Please wait …
2021-05-24T10:04:48.386972Z 0 [Note] InnoDB: File ‘./ibtmp1’ size is now 12 MB.
2021-05-24T10:04:48.387602Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2021-05-24T10:04:48.387610Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2021-05-24T10:04:48.387957Z 0 [Note] InnoDB: Waiting for purge to start
2021-05-24T10:04:48.438142Z 0 [Note] InnoDB: 5.7.34 started; log sequence number 470052395402
2021-05-24T10:04:48.438396Z 0 [Note] InnoDB: Loading buffer pool(s) from /home/mysql/ib_buffer_pool
2021-05-24T10:04:48.438678Z 0 [Note] Plugin ‘FEDERATED’ is disabled.
2021-05-24T10:04:48.442544Z 0 [ERROR] Can’t open shared library ‘/usr/lib/mysql/plugin/auth_socket.so’ (errno: 2 /usr/lib/mysql/plugin/auth_socket.so: cannot open shared object file: No such file or directory)
2021-05-24T10:04:48.442555Z 0 [Warning] Couldn’t load plugin named ‘auth_socket’ with soname ‘auth_socket.so’.
2021-05-24T10:04:48.445250Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2021-05-24T10:04:48.445696Z 0 [Note] Server hostname (bind-address): ‘127.0.0.1’; port: 3306
2021-05-24T10:04:48.445725Z 0 [Note] - ‘127.0.0.1’ resolves to ‘127.0.0.1’;
2021-05-24T10:04:48.445744Z 0 [Note] Server socket created on IP: ‘127.0.0.1’.
2021-05-24T10:04:48.445767Z 0 [ERROR] Could not create unix socket lock file /var/run/mysqld/mysqld.sock.lock.
2021-05-24T10:04:48.445771Z 0 [ERROR] Unable to setup unix socket lock file.
2021-05-24T10:04:48.445774Z 0 [ERROR] Aborting

2021-05-24T10:04:48.445779Z 0 [Note] Binlog end
2021-05-24T10:04:48.445814Z 0 [Note] Shutting down plugin ‘ngram’
2021-05-24T10:04:48.445819Z 0 [Note] Shutting down plugin ‘partition’
2021-05-24T10:04:48.445822Z 0 [Note] Shutting down plugin ‘BLACKHOLE’
2021-05-24T10:04:48.445825Z 0 [Note] Shutting down plugin ‘ARCHIVE’
2021-05-24T10:04:48.445828Z 0 [Note] Shutting down plugin ‘PERFORMANCE_SCHEMA’
2021-05-24T10:04:48.445852Z 0 [Note] Shutting down plugin ‘MRG_MYISAM’
2021-05-24T10:04:48.445855Z 0 [Note] Shutting down plugin ‘MyISAM’
2021-05-24T10:04:48.445869Z 0 [Note] Shutting down plugin ‘INNODB_SYS_VIRTUAL’
2021-05-24T10:04:48.445873Z 0 [Note] Shutting down plugin ‘INNODB_SYS_DATAFILES’
2021-05-24T10:04:48.445875Z 0 [Note] Shutting down plugin ‘INNODB_SYS_TABLESPACES’
2021-05-24T10:04:48.445878Z 0 [Note] Shutting down plugin ‘INNODB_SYS_FOREIGN_COLS’
2021-05-24T10:04:48.445880Z 0 [Note] Shutting down plugin ‘INNODB_SYS_FOREIGN’
2021-05-24T10:04:48.445883Z 0 [Note] Shutting down plugin ‘INNODB_SYS_FIELDS’
2021-05-24T10:04:48.445886Z 0 [Note] Shutting down plugin ‘INNODB_SYS_COLUMNS’
2021-05-24T10:04:48.445888Z 0 [Note] Shutting down plugin ‘INNODB_SYS_INDEXES’
2021-05-24T10:04:48.445891Z 0 [Note] Shutting down plugin ‘INNODB_SYS_TABLESTATS’
2021-05-24T10:04:48.445893Z 0 [Note] Shutting down plugin ‘INNODB_SYS_TABLES’
2021-05-24T10:04:48.445896Z 0 [Note] Shutting down plugin ‘INNODB_FT_INDEX_TABLE’
2021-05-24T10:04:48.445898Z 0 [Note] Shutting down plugin ‘INNODB_FT_INDEX_CACHE’
2021-05-24T10:04:48.445901Z 0 [Note] Shutting down plugin ‘INNODB_FT_CONFIG’
2021-05-24T10:04:48.445903Z 0 [Note] Shutting down plugin ‘INNODB_FT_BEING_DELETED’
2021-05-24T10:04:48.445906Z 0 [Note] Shutting down plugin ‘INNODB_FT_DELETED’
2021-05-24T10:04:48.445908Z 0 [Note] Shutting down plugin ‘INNODB_FT_DEFAULT_STOPWORD’
2021-05-24T10:04:48.445911Z 0 [Note] Shutting down plugin ‘INNODB_METRICS’
2021-05-24T10:04:48.445913Z 0 [Note] Shutting down plugin ‘INNODB_TEMP_TABLE_INFO’
2021-05-24T10:04:48.445916Z 0 [Note] Shutting down plugin ‘INNODB_BUFFER_POOL_STATS’
2021-05-24T10:04:48.445918Z 0 [Note] Shutting down plugin ‘INNODB_BUFFER_PAGE_LRU’
2021-05-24T10:04:48.445921Z 0 [Note] Shutting down plugin ‘INNODB_BUFFER_PAGE’
2021-05-24T10:04:48.445923Z 0 [Note] Shutting down plugin ‘INNODB_CMP_PER_INDEX_RESET’
2021-05-24T10:04:48.445926Z 0 [Note] Shutting down plugin ‘INNODB_CMP_PER_INDEX’
2021-05-24T10:04:48.445928Z 0 [Note] Shutting down plugin ‘INNODB_CMPMEM_RESET’
2021-05-24T10:04:48.445931Z 0 [Note] Shutting down plugin ‘INNODB_CMPMEM’
2021-05-24T10:04:48.445933Z 0 [Note] Shutting down plugin ‘INNODB_CMP_RESET’
2021-05-24T10:04:48.445936Z 0 [Note] Shutting down plugin ‘INNODB_CMP’
2021-05-24T10:04:48.445948Z 0 [Note] Shutting down plugin ‘INNODB_LOCK_WAITS’
2021-05-24T10:04:48.445950Z 0 [Note] Shutting down plugin ‘INNODB_LOCKS’
2021-05-24T10:04:48.445953Z 0 [Note] Shutting down plugin ‘INNODB_TRX’
2021-05-24T10:04:48.445956Z 0 [Note] Shutting down plugin ‘InnoDB’
2021-05-24T10:04:48.447668Z 0 [Note] InnoDB: FTS optimize thread exiting.
2021-05-24T10:04:48.447763Z 0 [Note] InnoDB: Starting shutdown…
2021-05-24T10:04:48.447816Z 0 [Note] InnoDB: Buffer pool(s) load completed at 210524 12:04:48 (/home/mysql/ib_buffer_pool was empty)
2021-05-24T10:04:48.447844Z 0 [Note] InnoDB: Dumping buffer pool(s) to /home/mysql/ib_buffer_pool
2021-05-24T10:04:48.448129Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 210524 12:04:48
2021-05-24T10:04:50.386896Z 0 [Note] InnoDB: Shutdown completed; log sequence number 470052395421
2021-05-24T10:04:50.388425Z 0 [Note] InnoDB: Removed temporary tablespace data file: “ibtmp1”
2021-05-24T10:04:50.388435Z 0 [Note] Shutting down plugin ‘MEMORY’
2021-05-24T10:04:50.388440Z 0 [Note] Shutting down plugin ‘CSV’
2021-05-24T10:04:50.388444Z 0 [Note] Shutting down plugin ‘sha256_password’
2021-05-24T10:04:50.388446Z 0 [Note] Shutting down plugin ‘mysql_native_password’
2021-05-24T10:04:50.388540Z 0 [Note] Shutting down plugin ‘binlog’
2021-05-24T10:04:50.392937Z 0 [Note] mysqld: Shutdown complete

2021-05-24T10:05:56.497512Z 0 [Warning] Ignoring user change to ‘mysql’ because the user was set to ‘root’ earlier on the command line

2021-05-24T10:05:56.497583Z 0 [Warning] ‘NO_ZERO_DATE’, ‘NO_ZERO_IN_DATE’ and ‘ERROR_FOR_DIVISION_BY_ZERO’ sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2021-05-24T10:05:56.498633Z 0 [Note] mysqld (mysqld 5.7.34-0ubuntu0.18.04.1-log) starting as process 27362 …
2021-05-24T10:05:56.524119Z 0 [Note] InnoDB: PUNCH HOLE support available
2021-05-24T10:05:56.524148Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-05-24T10:05:56.524162Z 0 [Note] InnoDB: Uses event mutexes
2021-05-24T10:05:56.524166Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2021-05-24T10:05:56.524169Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-05-24T10:05:56.524173Z 0 [Note] InnoDB: Using Linux native AIO
2021-05-24T10:05:56.524373Z 0 [Note] InnoDB: Number of pools: 1
2021-05-24T10:05:56.524453Z 0 [Note] InnoDB: Using CPU crc32 instructions
2021-05-24T10:05:56.525482Z 0 [Note] InnoDB: Initializing buffer pool, total size = 20G, instances = 8, chunk size = 128M
2021-05-24T10:05:57.420089Z 0 [Note] InnoDB: Completed initialization of buffer pool
2021-05-24T10:05:57.574737Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-05-24T10:05:57.576184Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2021-05-24T10:05:58.009125Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-05-24T10:05:58.009194Z 0 [Note] InnoDB: Setting file ‘./ibtmp1’ size to 12 MB. Physically writing the file full; Please wait …
2021-05-24T10:05:58.043572Z 0 [Note] InnoDB: File ‘./ibtmp1’ size is now 12 MB.
2021-05-24T10:05:58.044383Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2021-05-24T10:05:58.044394Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2021-05-24T10:05:58.044667Z 0 [Note] InnoDB: Waiting for purge to start
2021-05-24T10:05:58.094862Z 0 [Note] InnoDB: 5.7.34 started; log sequence number 470052395421
2021-05-24T10:05:58.095109Z 0 [Note] InnoDB: Loading buffer pool(s) from /home/mysql/ib_buffer_pool
2021-05-24T10:05:58.095380Z 0 [Note] Plugin ‘FEDERATED’ is disabled.
2021-05-24T10:05:58.095569Z 0 [Note] InnoDB: Buffer pool(s) load completed at 210524 12:05:58
2021-05-24T10:05:58.097904Z 0 [ERROR] Can’t open shared library ‘/usr/lib/mysql/plugin/auth_socket.so’ (errno: 2 /usr/lib/mysql/plugin/auth_socket.so: cannot open shared object file: No such file or directory)
2021-05-24T10:05:58.097917Z 0 [Warning] Couldn’t load plugin named ‘auth_socket’ with soname ‘auth_socket.so’.
2021-05-24T10:05:58.099719Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2021-05-24T10:05:58.099827Z 0 [Note] Server hostname (bind-address): ‘127.0.0.1’; port: 3306
2021-05-24T10:05:58.099845Z 0 [Note] - ‘127.0.0.1’ resolves to ‘127.0.0.1’;
2021-05-24T10:05:58.099871Z 0 [Note] Server socket created on IP: ‘127.0.0.1’.
2021-05-24T10:05:58.099900Z 0 [ERROR] Could not create unix socket lock file /var/run/mysqld/mysqld.sock.lock.
2021-05-24T10:05:58.099906Z 0 [ERROR] Unable to setup unix socket lock file.
2021-05-24T10:05:58.099910Z 0 [ERROR] Aborting

2021-05-24T10:05:58.099917Z 0 [Note] Binlog end
2021-05-24T10:05:58.099963Z 0 [Note] Shutting down plugin ‘ngram’
2021-05-24T10:05:58.099970Z 0 [Note] Shutting down plugin ‘partition’
2021-05-24T10:05:58.099975Z 0 [Note] Shutting down plugin ‘BLACKHOLE’
2021-05-24T10:05:58.099979Z 0 [Note] Shutting down plugin ‘ARCHIVE’
2021-05-24T10:05:58.099983Z 0 [Note] Shutting down plugin ‘PERFORMANCE_SCHEMA’
2021-05-24T10:05:58.100018Z 0 [Note] Shutting down plugin ‘MRG_MYISAM’
2021-05-24T10:05:58.100022Z 0 [Note] Shutting down plugin ‘MyISAM’
2021-05-24T10:05:58.100033Z 0 [Note] Shutting down plugin ‘INNODB_SYS_VIRTUAL’
2021-05-24T10:05:58.100037Z 0 [Note] Shutting down plugin ‘INNODB_SYS_DATAFILES’
2021-05-24T10:05:58.100041Z 0 [Note] Shutting down plugin ‘INNODB_SYS_TABLESPACES’
2021-05-24T10:05:58.100045Z 0 [Note] Shutting down plugin ‘INNODB_SYS_FOREIGN_COLS’
2021-05-24T10:05:58.100048Z 0 [Note] Shutting down plugin ‘INNODB_SYS_FOREIGN’
2021-05-24T10:05:58.100052Z 0 [Note] Shutting down plugin ‘INNODB_SYS_FIELDS’
2021-05-24T10:05:58.100056Z 0 [Note] Shutting down plugin ‘INNODB_SYS_COLUMNS’
2021-05-24T10:05:58.100059Z 0 [Note] Shutting down plugin ‘INNODB_SYS_INDEXES’
2021-05-24T10:05:58.100063Z 0 [Note] Shutting down plugin ‘INNODB_SYS_TABLESTATS’
2021-05-24T10:05:58.100076Z 0 [Note] Shutting down plugin ‘INNODB_SYS_TABLES’
2021-05-24T10:05:58.100081Z 0 [Note] Shutting down plugin ‘INNODB_FT_INDEX_TABLE’
2021-05-24T10:05:58.100084Z 0 [Note] Shutting down plugin ‘INNODB_FT_INDEX_CACHE’
2021-05-24T10:05:58.100088Z 0 [Note] Shutting down plugin ‘INNODB_FT_CONFIG’
2021-05-24T10:05:58.100092Z 0 [Note] Shutting down plugin ‘INNODB_FT_BEING_DELETED’
2021-05-24T10:05:58.100095Z 0 [Note] Shutting down plugin ‘INNODB_FT_DELETED’
2021-05-24T10:05:58.100099Z 0 [Note] Shutting down plugin ‘INNODB_FT_DEFAULT_STOPWORD’
2021-05-24T10:05:58.100102Z 0 [Note] Shutting down plugin ‘INNODB_METRICS’
2021-05-24T10:05:58.100106Z 0 [Note] Shutting down plugin ‘INNODB_TEMP_TABLE_INFO’
2021-05-24T10:05:58.100110Z 0 [Note] Shutting down plugin ‘INNODB_BUFFER_POOL_STATS’
2021-05-24T10:05:58.100113Z 0 [Note] Shutting down plugin ‘INNODB_BUFFER_PAGE_LRU’
2021-05-24T10:05:58.100117Z 0 [Note] Shutting down plugin ‘INNODB_BUFFER_PAGE’
2021-05-24T10:05:58.100121Z 0 [Note] Shutting down plugin ‘INNODB_CMP_PER_INDEX_RESET’
2021-05-24T10:05:58.100124Z 0 [Note] Shutting down plugin ‘INNODB_CMP_PER_INDEX’
2021-05-24T10:05:58.100128Z 0 [Note] Shutting down plugin ‘INNODB_CMPMEM_RESET’
2021-05-24T10:05:58.100131Z 0 [Note] Shutting down plugin ‘INNODB_CMPMEM’
2021-05-24T10:05:58.100135Z 0 [Note] Shutting down plugin ‘INNODB_CMP_RESET’
2021-05-24T10:05:58.100139Z 0 [Note] Shutting down plugin ‘INNODB_CMP’
2021-05-24T10:05:58.100142Z 0 [Note] Shutting down plugin ‘INNODB_LOCK_WAITS’
2021-05-24T10:05:58.100146Z 0 [Note] Shutting down plugin ‘INNODB_LOCKS’
2021-05-24T10:05:58.100149Z 0 [Note] Shutting down plugin ‘INNODB_TRX’
2021-05-24T10:05:58.100153Z 0 [Note] Shutting down plugin ‘InnoDB’
2021-05-24T10:05:58.100450Z 0 [Note] InnoDB: FTS optimize thread exiting.
2021-05-24T10:05:58.100636Z 0 [Note] InnoDB: Starting shutdown…
2021-05-24T10:05:58.200864Z 0 [Note] InnoDB: Dumping buffer pool(s) to /home/mysql/ib_buffer_pool
2021-05-24T10:05:58.201154Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 210524 12:05:58
2021-05-24T10:06:00.023299Z 0 [Note] InnoDB: Shutdown completed; log sequence number 470052395440
2021-05-24T10:06:00.024823Z 0 [Note] InnoDB: Removed temporary tablespace data file: “ibtmp1”
2021-05-24T10:06:00.024833Z 0 [Note] Shutting down plugin ‘MEMORY’
2021-05-24T10:06:00.024837Z 0 [Note] Shutting down plugin ‘CSV’
2021-05-24T10:06:00.024841Z 0 [Note] Shutting down plugin ‘sha256_password’
2021-05-24T10:06:00.024844Z 0 [Note] Shutting down plugin ‘mysql_native_password’
2021-05-24T10:06:00.024938Z 0 [Note] Shutting down plugin ‘binlog’
2021-05-24T10:06:00.030095Z 0 [Note] mysqld: Shutdown complete

2021-05-24T10:23:48.817589Z 0 [Warning] Ignoring user change to ‘mysql’ because the user was set to ‘root’ earlier on the command line

2021-05-24T10:23:48.817661Z 0 [Warning] ‘NO_ZERO_DATE’, ‘NO_ZERO_IN_DATE’ and ‘ERROR_FOR_DIVISION_BY_ZERO’ sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2021-05-24T10:23:48.818713Z 0 [Note] mysqld (mysqld 5.7.34-0ubuntu0.18.04.1-log) starting as process 11824 …
2021-05-24T10:23:48.844119Z 0 [Note] InnoDB: PUNCH HOLE support available
2021-05-24T10:23:48.844150Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-05-24T10:23:48.844155Z 0 [Note] InnoDB: Uses event mutexes
2021-05-24T10:23:48.844159Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2021-05-24T10:23:48.844163Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-05-24T10:23:48.844167Z 0 [Note] InnoDB: Using Linux native AIO
2021-05-24T10:23:48.844368Z 0 [Note] InnoDB: Number of pools: 1
2021-05-24T10:23:48.844447Z 0 [Note] InnoDB: Using CPU crc32 instructions
2021-05-24T10:23:48.845476Z 0 [Note] InnoDB: Initializing buffer pool, total size = 20G, instances = 8, chunk size = 128M
2021-05-24T10:23:49.778391Z 0 [Note] InnoDB: Completed initialization of buffer pool
2021-05-24T10:23:49.934016Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-05-24T10:23:49.935334Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2021-05-24T10:23:50.358105Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-05-24T10:23:50.358172Z 0 [Note] InnoDB: Setting file ‘./ibtmp1’ size to 12 MB. Physically writing the file full; Please wait …
2021-05-24T10:23:50.394674Z 0 [Note] InnoDB: File ‘./ibtmp1’ size is now 12 MB.
2021-05-24T10:23:50.395332Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2021-05-24T10:23:50.395340Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2021-05-24T10:23:50.395863Z 0 [Note] InnoDB: Waiting for purge to start
2021-05-24T10:23:50.446067Z 0 [Note] InnoDB: 5.7.34 started; log sequence number 470052395440
2021-05-24T10:23:50.446315Z 0 [Note] InnoDB: Loading buffer pool(s) from /home/mysql/ib_buffer_pool
2021-05-24T10:23:50.446580Z 0 [Note] Plugin ‘FEDERATED’ is disabled.
2021-05-24T10:23:50.447061Z 0 [Note] InnoDB: Buffer pool(s) load completed at 210524 12:23:50
2021-05-24T10:23:50.451791Z 0 [ERROR] Can’t open shared library ‘/usr/lib/mysql/plugin/auth_socket.so’ (errno: 2 /usr/lib/mysql/plugin/auth_socket.so: cannot open shared object file: No such file or directory)
2021-05-24T10:23:50.451813Z 0 [Warning] Couldn’t load plugin named ‘auth_socket’ with soname ‘auth_socket.so’.
2021-05-24T10:23:50.454670Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2021-05-24T10:23:50.454831Z 0 [Note] Server hostname (bind-address): ‘127.0.0.1’; port: 3306
2021-05-24T10:23:50.454850Z 0 [Note] - ‘127.0.0.1’ resolves to ‘127.0.0.1’;
2021-05-24T10:23:50.454887Z 0 [Note] Server socket created on IP: ‘127.0.0.1’.
2021-05-24T10:23:50.454926Z 0 [ERROR] Could not create unix socket lock file /var/run/mysqld/mysqld.sock.lock.
2021-05-24T10:23:50.454934Z 0 [ERROR] Unable to setup unix socket lock file.
2021-05-24T10:23:50.454941Z 0 [ERROR] Aborting

2021-05-24T10:23:50.454951Z 0 [Note] Binlog end
2021-05-24T10:23:50.455015Z 0 [Note] Shutting down plugin ‘ngram’
2021-05-24T10:23:50.455026Z 0 [Note] Shutting down plugin ‘partition’
2021-05-24T10:23:50.455032Z 0 [Note] Shutting down plugin ‘BLACKHOLE’
2021-05-24T10:23:50.455038Z 0 [Note] Shutting down plugin ‘ARCHIVE’
2021-05-24T10:23:50.455044Z 0 [Note] Shutting down plugin ‘PERFORMANCE_SCHEMA’
2021-05-24T10:23:50.455096Z 0 [Note] Shutting down plugin ‘MRG_MYISAM’
2021-05-24T10:23:50.455103Z 0 [Note] Shutting down plugin ‘MyISAM’
2021-05-24T10:23:50.455117Z 0 [Note] Shutting down plugin ‘INNODB_SYS_VIRTUAL’
2021-05-24T10:23:50.455124Z 0 [Note] Shutting down plugin ‘INNODB_SYS_DATAFILES’
2021-05-24T10:23:50.455130Z 0 [Note] Shutting down plugin ‘INNODB_SYS_TABLESPACES’
2021-05-24T10:23:50.455136Z 0 [Note] Shutting down plugin ‘INNODB_SYS_FOREIGN_COLS’
2021-05-24T10:23:50.455141Z 0 [Note] Shutting down plugin ‘INNODB_SYS_FOREIGN’
2021-05-24T10:23:50.455147Z 0 [Note] Shutting down plugin ‘INNODB_SYS_FIELDS’
2021-05-24T10:23:50.455152Z 0 [Note] Shutting down plugin ‘INNODB_SYS_COLUMNS’
2021-05-24T10:23:50.455158Z 0 [Note] Shutting down plugin ‘INNODB_SYS_INDEXES’
2021-05-24T10:23:50.455163Z 0 [Note] Shutting down plugin ‘INNODB_SYS_TABLESTATS’
2021-05-24T10:23:50.455169Z 0 [Note] Shutting down plugin ‘INNODB_SYS_TABLES’
2021-05-24T10:23:50.455174Z 0 [Note] Shutting down plugin ‘INNODB_FT_INDEX_TABLE’
2021-05-24T10:23:50.455180Z 0 [Note] Shutting down plugin ‘INNODB_FT_INDEX_CACHE’
2021-05-24T10:23:50.455185Z 0 [Note] Shutting down plugin ‘INNODB_FT_CONFIG’
2021-05-24T10:23:50.455190Z 0 [Note] Shutting down plugin ‘INNODB_FT_BEING_DELETED’
2021-05-24T10:23:50.455196Z 0 [Note] Shutting down plugin ‘INNODB_FT_DELETED’
2021-05-24T10:23:50.455201Z 0 [Note] Shutting down plugin ‘INNODB_FT_DEFAULT_STOPWORD’
2021-05-24T10:23:50.455207Z 0 [Note] Shutting down plugin ‘INNODB_METRICS’
2021-05-24T10:23:50.455212Z 0 [Note] Shutting down plugin ‘INNODB_TEMP_TABLE_INFO’
2021-05-24T10:23:50.455218Z 0 [Note] Shutting down plugin ‘INNODB_BUFFER_POOL_STATS’
2021-05-24T10:23:50.455223Z 0 [Note] Shutting down plugin ‘INNODB_BUFFER_PAGE_LRU’
2021-05-24T10:23:50.455241Z 0 [Note] Shutting down plugin ‘INNODB_BUFFER_PAGE’
2021-05-24T10:23:50.455248Z 0 [Note] Shutting down plugin ‘INNODB_CMP_PER_INDEX_RESET’
2021-05-24T10:23:50.455253Z 0 [Note] Shutting down plugin ‘INNODB_CMP_PER_INDEX’
2021-05-24T10:23:50.455259Z 0 [Note] Shutting down plugin ‘INNODB_CMPMEM_RESET’
2021-05-24T10:23:50.455264Z 0 [Note] Shutting down plugin ‘INNODB_CMPMEM’
2021-05-24T10:23:50.455270Z 0 [Note] Shutting down plugin ‘INNODB_CMP_RESET’
2021-05-24T10:23:50.455275Z 0 [Note] Shutting down plugin ‘INNODB_CMP’
2021-05-24T10:23:50.455281Z 0 [Note] Shutting down plugin ‘INNODB_LOCK_WAITS’
2021-05-24T10:23:50.455286Z 0 [Note] Shutting down plugin ‘INNODB_LOCKS’
2021-05-24T10:23:50.455292Z 0 [Note] Shutting down plugin ‘INNODB_TRX’
2021-05-24T10:23:50.455297Z 0 [Note] Shutting down plugin ‘InnoDB’
2021-05-24T10:23:50.455560Z 0 [Note] InnoDB: FTS optimize thread exiting.
2021-05-24T10:23:50.455661Z 0 [Note] InnoDB: Starting shutdown…
2021-05-24T10:23:50.555891Z 0 [Note] InnoDB: Dumping buffer pool(s) to /home/mysql/ib_buffer_pool
2021-05-24T10:23:50.556218Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 210524 12:23:50
2021-05-24T10:23:52.383499Z 0 [Note] InnoDB: Shutdown completed; log sequence number 470052395459
2021-05-24T10:23:52.385027Z 0 [Note] InnoDB: Removed temporary tablespace data file: “ibtmp1”
2021-05-24T10:23:52.385037Z 0 [Note] Shutting down plugin ‘MEMORY’
2021-05-24T10:23:52.385042Z 0 [Note] Shutting down plugin ‘CSV’
2021-05-24T10:23:52.385046Z 0 [Note] Shutting down plugin ‘sha256_password’
2021-05-24T10:23:52.385049Z 0 [Note] Shutting down plugin ‘mysql_native_password’
2021-05-24T10:23:52.385145Z 0 [Note] Shutting down plugin ‘binlog’
2021-05-24T10:23:52.389202Z 0 [Note] mysqld: Shutdown complete

jvieille · May 24, 2021, 12:50pm

Related packages

root@ns383323:~# dpkg -l mysql*
Desired=Unknown/Install | Status=Not/Inst/Conf- |/ Err?=(none)/Reinst-required ||/ Name ++±=================== un mysql-client-5.5 un mysql-client-5.6 un mysql-client-5.7 un mysql-client-core-5.5 un mysql-client-core-5.6 un mysql-client-core-5.7 ii mysql-common un mysql-common-5.6 un mysql-server-5.5 un mysql-server-5.6 rc mysql-server-5.7 un mysql-server-core-5.5 un mysql-server-core-5.6 ii mysql-server-core-5.7 root@ns383323:~# dpkg -l mariadb*
Desired=Unknown/Install | Status=Not/Inst/Conf- |/ Err?=(none)/Reinst-required ||/ Name ++±=================== ii mariadb-client un mariadb-client-10.0 ii mariadb-client-10.1 un mariadb-client-5.5 un mariadb-client-core-10.0 ii mariadb-client-core-10.1 un mariadb-client-core-5.5 ii mariadb-common un mariadb-server un mariadb-server-10.0 un mariadb-server-5.5 r /Remove/Purge/Hold
files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend
(Status,Err: uppercase=bad)
Version Architecture Description
==================================-===============================-===============================-===============================================================================================================
(no description available)
(no description available)
(no description available)
(no description available)
(no description available)
(no description available)
5.8+1.0.4 all MySQL database common files, e.g. /etc/mysql/my.cnf
(no description available)
(no description available)
(no description available)
5.7.34-0ubuntu0.18.04.1 amd64 MySQL database server binaries and system database setup
(no description available)
(no description available)
5.7.34-0ubuntu0.18.04.1 amd64 MySQL database server binaries
/Remove/Purge/Hold
files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend
(Status,Err: uppercase=bad)
Version Architecture Description
==================================-===============================-===============================-===============================================================================================================
1:10.1.48-0ubuntu0.18.04.1 all MariaDB database client (metapackage depending on the latest version)
(no description available)
1:10.1.48-0ubuntu0.18.04.1 amd64 MariaDB database client binaries
(no description available)
(no description available)
1:10.1.48-0ubuntu0.18.04.1 amd64 MariaDB database core client binaries
(no description available)
1:10.1.48-0ubuntu0.18.04.1 all MariaDB common metapackage
(no description available)
(no description available)
(no description available)

jvieille · May 24, 2021, 1:33pm

No Mariadb file existed one day ago:
root@ns383323:/# find . -name “mariadb” -ctime +1 -print
(nothing)

but Mysql was there 5 days ago:
root@ns383323:/# find . -name “mysql” -atime +5 -print
./var/lib/mysql/mysql
./var/webmin/modules/mysql
./etc/apparmor.d/abstractions/mysql
./etc/usermin/mysql
./etc/init.d/mysql
./usr/lib/x86_64-linux-gnu/perl5/5.26/DBD/mysql
./usr/lib/x86_64-linux-gnu/perl5/5.26/auto/DBD/mysql
./usr/share/php7.3-mysql/mysql
./usr/share/php8.0-mysql/mysql
./usr/share/webmin/authentic-theme/images/modules/mysql
./usr/share/webmin/gray-theme/mysql
./usr/share/webmin/mysql
./usr/share/usermin/authentic-theme/images/modules/mysql
./usr/share/usermin/gray-theme/mysql
./usr/share/usermin/mysql
./usr/share/dbconfig-common/scripts/phpmyadmin/upgrade/mysql
./usr/share/dbconfig-common/internal/mysql
./usr/share/dbconfig-common/data/phpmyadmin/upgrade/mysql
./usr/share/dbconfig-common/data/phpmyadmin/install/mysql
./usr/share/php7.4-mysql/mysql
./usr/share/php7.2-mysql/mysql
./usr/share/bash-completion/completions/mysql

Can I safely purge Mariadb and run
apt-get install --reinstall mysql-server ?

perler · May 24, 2021, 3:04pm

jesus, what did you do again? last time you broke php and told me (kind of rightfully) to disable auto-remove from the unattended-upgrade config. I did. now this is my apt history. you REMOVED the mysql server somehow. can you please establish a minimal test regime before pushing out your apt updates?!

Start-Date: 2021-05-24 06:02:27
Commandline: /usr/bin/unattended-upgrade
Upgrade: virtualmin-lamp-stack:amd64 (6.1.1+ubuntu-20.04, 6.1.2+ubuntu-20.04)
End-Date: 2021-05-24 06:02:27

Start-Date: 2021-05-24 06:02:31
Commandline: /usr/bin/unattended-upgrade
Remove: mysql-server:amd64 (5.7.34-0ubuntu0.18.04.1)
End-Date: 2021-05-24 06:02:31

Start-Date: 2021-05-24 06:02:34
Commandline: /usr/bin/unattended-upgrade
Remove: mysql-client-5.7:amd64 (5.7.34-0ubuntu0.18.04.1), mysql-server-5.7:amd64 (5.7.34-0ubuntu0.18.04.1), mysql-client:amd64 (5.7.34-0ubu
ntu0.18.04.1), mysql-client-core-5.7:amd64 (5.7.34-0ubuntu0.18.04.1)
End-Date: 2021-05-24 06:02:48

Start-Date: 2021-05-24 06:02:51
Commandline: /usr/bin/unattended-upgrade
Remove: libhtml-template-perl:amd64 (2.97-1)
End-Date: 2021-05-24 06:02:51

Start-Date: 2021-05-24 06:02:54
Commandline: /usr/bin/unattended-upgrade
Remove: libevent-core-2.1-6:amd64 (2.1.8-stable-4build1)
End-Date: 2021-05-24 06:02:54

Start-Date: 2021-05-24 06:02:57
Commandline: /usr/bin/unattended-upgrade
Remove: libaio1:amd64 (0.3.110-5ubuntu0.1), mysql-server-core-5.7:amd64 (5.7.34-0ubuntu0.18.04.1)
End-Date: 2021-05-24 06:02:58

Start-Date: 2021-05-24 06:03:01
Commandline: /usr/bin/unattended-upgrade
Remove: libdbd-mysql-perl:amd64 (4.046-1)
End-Date: 2021-05-24 06:03:01

Joe · May 24, 2021, 3:13pm

No. Do not purge mariadb.

Just install mysql again. Do not purge anything (purge removes data, which is the last thing you want to happen).

There was briefly a problem with virtualmin-lamp-stack/virtualmin-lemp-stack where it depended on mariadb instead of mysql. Reinstalling mysql should resolve the problem. The current version resolves that.

Ilia · May 24, 2021, 8:15pm

This change was never meant to be released for Virtualmin 6. This is partially my fault – accept my apologies please.

We created a separate branch for Virtualmin 6 lamp stack packages, as Virtualmin 7 will install by default MariaDB for Ubuntu 20.04 instead of MySQL.

perler · May 25, 2021, 6:24am

ok, and did you fix it? is it safe to re-enable auto-upgrade?

jvieille · May 25, 2021, 6:29am

After many attempts, I end up with mariadb installed instead of Mysql. I had tons of problems, lost everything. Mariadb definitely not upgrades smoothly from Mysql, I am not sure evryhting is ok. One of the big issue was about apparmor, not sure it will not be back on next reboot.
Everything is working now with Mariadb.
Should I stick with it or go back to mysql?

Joe · May 25, 2021, 6:46am

It is safe to keep mariadb, but you’ll need to make sure you don’t switch again by upgrading virtualmin-*-stack again (because that package depends on mysql, again, as it was always supposed to).

jvieille · May 25, 2021, 7:08am

What shall I exactly do ? what means upgrading virtualmin-*-stack, how to?
Thanks!

Ilia · May 25, 2021, 9:14am

This is never neither recommended nor safe way to go. System packages upgrades must be done under supervision on production systems.

Everything is working now with MariaDB. Should I stick with it or go back to MySQL?

After Joe re-released new virtualmin-*-stack package, it will make sure that MySQL will not be replaced with MariaDB on Virtualmin 6 installs. The problem is, if you already upgraded to MariaDB, installing patched version of mentioned package, will again try to switch packages but this time from MariaDB to MySQL for Virtualmin 6.

The work-arounds could be:

Putting this package on hold, like apt-mark hold virtualmin-lamp-stack (however this will prevent running upgrades from UI as Webmin Software Packages Updates module uses -y param with package name individually to upgrade a package, however, when package that is on hold is getting changed, upgrade will not work automatically (thankfully) unless additional param --allow-change-held-packages is passed). In other words future package upgrades could only be done using console by running apt-get upgrade command;
Manually downloading virtualmin-lamp-stack package and forcefully re-install it using dpkg ignoring all dependencies. The downside is that any future package virtualmin-lamp-stack upgrades would again try to revert to MySQL on Virtualmin 6 systems;
Install the update and later revert /var/lib/mysql to the previous state from a backup.

jvieille · May 25, 2021, 10:29am

No way to tell Webmin/Virtualmin to use Mariadb instead of Mysql, meaning virtualmin-lamp-stack only works with Mysql ? (as the “M” in LAMP means)
If it is so, wouldn’t be simpler to uninstall Mariadb and reinstall Mysql ?

Ilia · May 25, 2021, 11:18am

In the case of what happened on your side, yes, this is what I would do.

No way to tell Webmin/Virtualmin to use Mariadb instead of Mysql, meaning virtualmin-lamp-stack only works with Mysql ? (as the “M” in LAMP means)

@Joe, what do you think about creating two types of stack packages to accommodate support for different databases upon installation process, and let an admin do install.sh --database MySQL to force MySQL and if no param passed use MariaDB by default?

Joe · May 25, 2021, 3:57pm

I don’t love this idea. We already have so many install options to test and support, and for the vast majority of users it doesn’t even matter…MySQL or MariaDB are functionally identical in like 99% of cases.

But, and this is a huge but, I always wanted databases to be optional and selectable by the user without running into conflicts in the package or having the package try to change the database. It’s already a Recommends:, which should allow that.

So…probably this dependency needs to become mariadb | mysql instead. (Where the first one will be installed if neither is.)

jvieille · May 26, 2021, 7:37am

Could you help me moving back to MySQL? My plan:

stop Mariadb
Copy the database data directory for backup (not in var/lib/mysql in mycase, but in /home/mysql (which was problematic for Mariadb that prevent access to this directory by default)
backup my custom my.cnf
remove Mariadb
apt-get purge mariadb-*
install Mysql
stop it, move my data back at /home/mysql, make my.cnf aware of the right location and make sure it includes my custom cnf (Mariadb replacement did not do that)
start Mysql
Celebrate

Regarding 4, what is the right way

install normally
sudo apt install mysql-server
sudo mysql_secure_installation
or let webmin/virtualmin make it, how?

Thanks

jvieille · May 28, 2021, 11:53am

Is that OK, which alternative '4) ?

WNYmathGuy · May 28, 2021, 1:56pm

YES !

I found that problem long ago with Apparmor. I shut it off to purposfully install MariaDB because of many reasons. Turned Apparmor back on after MariaDB was on and never had another problem.

Maria has better licence agreements than My. Oracle will eventually take the free part away from My.

Due to other issues I ran into I’m thinking of getting seperate metal servers to spin up MySQL alone, MariaDB alone and have my Virtualmin based webserver call to them for which ever one the particular application needs.

Their’s minor SQL differences between My & Maria that I have found out about but most people treat database programs as dumb storage so wouldn’t ever notice the differences.

system · June 5, 2021, 1:57pm

This topic was automatically closed 8 days after the last reply. New replies are no longer allowed.