Author Topic: MYSQID setup fails  (Read 78 times)

Offline roger2

  • Newbie
  • *
  • Posts: 6
MYSQID setup fails
« on: May 04, 2021, 09:41:18 AM »
I have fedora 34 running
And can't get started.  MYSQLD fails with automatic script.

Some data  .....................

-----------------------------------------------------------------------
from script ..from screen (std out)
-----------------------------------------------------------------------
sh  ./shellroundcube.sh
-----------------------------------------------------------------------
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)


-----------------------------------------------------------------------

from    ....    /var/log/mariadb/mariadb.log
-----------------------------------------------------------------------
 Aborting
 Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
 Can't start server: can't create PID file: Permission denied
 Could not open mysql.plugin table: "Table 'mysql.plugin' doesn't exist". Some plugins may be not loaded
 Failed to initialize plugins.
 InnoDB: The innodb_system data file 'ibdata1' must be writable
 mariadbd: Can't create/write to file '/run/mariadb/mariadb.pid' (Errcode: 13 "Permission denied")
 mariadbd: File '/var/lib/mysql/aria_log_control' not found (Errcode: 13 "Permission denied")
 mariadbd: Got error 'Can't open file' when trying to use aria control file '/var/lib/mysql/aria_log_control'
 mysqld: Can't create/write to file '/run/mariadb/mariadb.pid' (Errcode: 13 "Permission denied")
 Plugin 'Aria' init function returned error.
 Plugin 'Aria' registration as a STORAGE ENGINE failed.
 Plugin 'InnoDB' init function returned error.
 Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
 Fatal error: Can't open and lock privilege tables: Table 'mysql.db' doesn't exist



-----------------------------------------------------------------------

cli command

-----------------------------------------------------------------------

# ls -ld  /var/lib/mysql/mysql.sock
srwxrwxrwx. 1 rog rog 0 May  4 21:09 /var/lib/mysql/mysql.sock



The problem seems to me to be mysqld  related..... But how knows ....I'm not an expert.....
Any help greatly appreciated

Thx Roger

Offline roger2

  • Newbie
  • *
  • Posts: 6
Re: MYSQID setup fails
« Reply #1 on: May 04, 2021, 10:25:57 AM »
Found the problem .....

the following code is the FIX for fedora 34

sed -i  "s/mysql /mysqld /"   ./shellroundcube.sh


notice the "d"