mariadb 10.XX & centOS 8.XX Issue

darb

I have tried installing & compiling mariadb 10.X on centOS 8.X a couple of times and it won't run or start for some reason.

mariadb log:

2020-05-24 21:42:11 0 [Note] InnoDB: Using Linux native AIO
2020-05-24 21:42:11 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-05-24 21:42:11 0 [Note] InnoDB: Uses event mutexes
2020-05-24 21:42:11 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-05-24 21:42:11 0 [Note] InnoDB: Number of pools: 1
2020-05-24 21:42:11 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-05-24 21:42:11 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
2020-05-24 21:42:11 0 [Note] InnoDB: Initializing buffer pool, total size = 1G, instances = 8, chunk size = 128M
2020-05-24 21:42:11 0 [Note] InnoDB: Completed initialization of buffer pool
2020-05-24 21:42:11 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-05-24 21:42:11 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-05-24 21:42:11 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-05-24 21:42:11 0 [Note] InnoDB: Setting file '/www/server/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-05-24 21:42:11 0 [Note] InnoDB: File '/www/server/data/ibtmp1' size is now 12 MB.
2020-05-24 21:42:11 0 [Note] InnoDB: 10.4.13 started; log sequence number 60979; transaction id 21
2020-05-24 21:42:11 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool
2020-05-24 21:42:11 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-05-24 21:42:11 0 [Note] InnoDB: Buffer pool(s) load completed at 200524 21:42:11
2020-05-24 21:42:11 0 [Note] Server socket created on IP: '::'.
2020-05-24 21:42:11 0 [Note] Reading of all Master_info entries succeeded
2020-05-24 21:42:11 0 [Note] Added new Master_info '' to hash table
2020-05-24 21:42:11 0 [Note] /www/server/mysql/bin/mysqld: ready for connections.
Version: '10.4.13-MariaDB-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
2020-05-24 21:42:16 11 [Warning] Access denied for user 'root'@'localhost' (using password: NO)

Any suggestions?

aaPanel_Jose

Hello darb
Did you not see a log of startup errors in your logs, are there any other error logs?

darb

uninstalled and reinstalled; the execution log:

creating build/lib/pymysql/constants
copying pymysql/constants/CLIENT.py -> build/lib/pymysql/constants
copying pymysql/constants/COMMAND.py -> build/lib/pymysql/constants
copying pymysql/constants/CR.py -> build/lib/pymysql/constants
copying pymysql/constants/ER.py -> build/lib/pymysql/constants
copying pymysql/constants/FIELD_TYPE.py -> build/lib/pymysql/constants
copying pymysql/constants/FLAG.py -> build/lib/pymysql/constants
copying pymysql/constants/SERVER_STATUS.py -> build/lib/pymysql/constants
copying pymysql/constants/__init__.py -> build/lib/pymysql/constants
creating build/bdist.linux-x86_64
creating build/bdist.linux-x86_64/egg
creating build/bdist.linux-x86_64/egg/pymysql
copying build/lib/pymysql/__init__.py -> build/bdist.linux-x86_64/egg/pymysql
copying build/lib/pymysql/_auth.py -> build/bdist.linux-x86_64/egg/pymysql
copying build/lib/pymysql/_compat.py -> build/bdist.linux-x86_64/egg/pymysql
copying build/lib/pymysql/_socketio.py -> build/bdist.linux-x86_64/egg/pymysql
copying build/lib/pymysql/charset.py -> build/bdist.linux-x86_64/egg/pymysql
copying build/lib/pymysql/connections.py -> build/bdist.linux-x86_64/egg/pymysql
copying build/lib/pymysql/converters.py -> build/bdist.linux-x86_64/egg/pymysql
copying build/lib/pymysql/cursors.py -> build/bdist.linux-x86_64/egg/pymysql
copying build/lib/pymysql/err.py -> build/bdist.linux-x86_64/egg/pymysql
copying build/lib/pymysql/optionfile.py -> build/bdist.linux-x86_64/egg/pymysql
copying build/lib/pymysql/protocol.py -> build/bdist.linux-x86_64/egg/pymysql
copying build/lib/pymysql/times.py -> build/bdist.linux-x86_64/egg/pymysql
copying build/lib/pymysql/util.py -> build/bdist.linux-x86_64/egg/pymysql
creating build/bdist.linux-x86_64/egg/pymysql/constants
copying build/lib/pymysql/constants/CLIENT.py -> build/bdist.linux-x86_64/egg/pymysql/constants
copying build/lib/pymysql/constants/COMMAND.py -> build/bdist.linux-x86_64/egg/pymysql/constants
copying build/lib/pymysql/constants/CR.py -> build/bdist.linux-x86_64/egg/pymysql/constants
copying build/lib/pymysql/constants/ER.py -> build/bdist.linux-x86_64/egg/pymysql/constants
copying build/lib/pymysql/constants/FIELD_TYPE.py -> build/bdist.linux-x86_64/egg/pymysql/constants
copying build/lib/pymysql/constants/FLAG.py -> build/bdist.linux-x86_64/egg/pymysql/constants
copying build/lib/pymysql/constants/SERVER_STATUS.py -> build/bdist.linux-x86_64/egg/pymysql/constants
copying build/lib/pymysql/constants/__init__.py -> build/bdist.linux-x86_64/egg/pymysql/constants
byte-compiling build/bdist.linux-x86_64/egg/pymysql/__init__.py to __init__.cpython-37.pyc
byte-compiling build/bdist.linux-x86_64/egg/pymysql/_auth.py to _auth.cpython-37.pyc
byte-compiling build/bdist.linux-x86_64/egg/pymysql/_compat.py to _compat.cpython-37.pyc
byte-compiling build/bdist.linux-x86_64/egg/pymysql/_socketio.py to _socketio.cpython-37.pyc
byte-compiling build/bdist.linux-x86_64/egg/pymysql/charset.py to charset.cpython-37.pyc
byte-compiling build/bdist.linux-x86_64/egg/pymysql/connections.py to connections.cpython-37.pyc
byte-compiling build/bdist.linux-x86_64/egg/pymysql/converters.py to converters.cpython-37.pyc
byte-compiling build/bdist.linux-x86_64/egg/pymysql/cursors.py to cursors.cpython-37.pyc
byte-compiling build/bdist.linux-x86_64/egg/pymysql/err.py to err.cpython-37.pyc
byte-compiling build/bdist.linux-x86_64/egg/pymysql/optionfile.py to optionfile.cpython-37.pyc
byte-compiling build/bdist.linux-x86_64/egg/pymysql/protocol.py to protocol.cpython-37.pyc
byte-compiling build/bdist.linux-x86_64/egg/pymysql/times.py to times.cpython-37.pyc
byte-compiling build/bdist.linux-x86_64/egg/pymysql/util.py to util.cpython-37.pyc
byte-compiling build/bdist.linux-x86_64/egg/pymysql/constants/CLIENT.py to CLIENT.cpython-37.pyc
byte-compiling build/bdist.linux-x86_64/egg/pymysql/constants/COMMAND.py to COMMAND.cpython-37.pyc
byte-compiling build/bdist.linux-x86_64/egg/pymysql/constants/CR.py to CR.cpython-37.pyc
byte-compiling build/bdist.linux-x86_64/egg/pymysql/constants/ER.py to ER.cpython-37.pyc
byte-compiling build/bdist.linux-x86_64/egg/pymysql/constants/FIELD_TYPE.py to FIELD_TYPE.cpython-37.pyc
byte-compiling build/bdist.linux-x86_64/egg/pymysql/constants/FLAG.py to FLAG.cpython-37.pyc
byte-compiling build/bdist.linux-x86_64/egg/pymysql/constants/SERVER_STATUS.py to SERVER_STATUS.cpython-37.pyc
byte-compiling build/bdist.linux-x86_64/egg/pymysql/constants/__init__.py to __init__.cpython-37.pyc
creating build/bdist.linux-x86_64/egg/EGG-INFO
copying PyMySQL.egg-info/PKG-INFO -> build/bdist.linux-x86_64/egg/EGG-INFO
copying PyMySQL.egg-info/SOURCES.txt -> build/bdist.linux-x86_64/egg/EGG-INFO
copying PyMySQL.egg-info/dependency_links.txt -> build/bdist.linux-x86_64/egg/EGG-INFO
copying PyMySQL.egg-info/requires.txt -> build/bdist.linux-x86_64/egg/EGG-INFO
copying PyMySQL.egg-info/top_level.txt -> build/bdist.linux-x86_64/egg/EGG-INFO
zip_safe flag not set; analyzing archive contents...
creating dist
creating 'dist/PyMySQL-0.9.3-py3.7.egg' and adding 'build/bdist.linux-x86_64/egg' to it
removing 'build/bdist.linux-x86_64/egg' (and everything under it)
Processing PyMySQL-0.9.3-py3.7.egg
Copying PyMySQL-0.9.3-py3.7.egg to /www/server/panel/pyenv/lib/python3.7/site-packages
Adding PyMySQL 0.9.3 to easy-install.pth file

Installed /www/server/panel/pyenv/lib/python3.7/site-packages/PyMySQL-0.9.3-py3.7.egg
Processing dependencies for PyMySQL==0.9.3
Finished processing dependencies for PyMySQL==0.9.3
Reload Bt-Panel..	[32mdone[0m
Stopping mysqld (via systemctl):  [  OK  ]
Changing password...
200601 00:17:36 mysqld_safe Logging to '/www/server/data/localhost.localdomain.err'.
200601 00:17:36 mysqld_safe Starting mysqld daemon with databases from /www/server/data
ERROR 1348 (HY000) at line 1: Column 'authentication_string' is not updatable
1
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
mysql_root.sh: line 26: 24015 Killed                  mysqld_safe --skip-grant-tables
Starting mysqld (via systemctl):  [  OK  ]
===========================================
The root password set 9e8e1bbb68ca2236  successuful
1
Stopping mysqld (via systemctl):  [  OK  ]
Starting mysqld (via systemctl):  [  OK  ]
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)
--2020-06-01 00:17:48--  http://128.1.164.196/tools/check.sh
Connecting to 128.1.164.196:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 565 [application/octet-stream]
Saving to: ‘/www/server/panel/install/check.sh’

     0K                                                       100% 33.3M=0s

2020-06-01 00:17:48 (33.3 MB/s) - ‘/www/server/panel/install/check.sh’ saved [565/565]