Hello all,

I am a newbie at MySQL and am trying to start off mysqld with
safe_mysqld command and I get the following error (This was a suggestion I got from a book with a chapter on MySQL~.

Also I installed MySQL version 8.x that comes as an optional install with RH9 which i also just re-installed.

1) As root:
safe_mysqld --user=tuka &

Return:

030805 10:55:42 mysqld started
030805 10:55:42 Can't start server : Bind on unix socket: Permission denied
030805 10:55:42 Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
030805 10:55:42 Aborting

030805 10:55:42 /usr/libexec/mysqld: Shutdown Complete

030805 10:55:42 mysqld ended


For the above. I verified that mysql.sock exists although I dont know if it is in the right folder. I dont know what Bind on Unix Socket means either. Any Clues ?


2) As a second option I tried (again as root):

Command used:

[root@localhost root]# safe_mysqld &
[1] 1556
[root@localhost root]# Starting mysqld daemon with databases from /var/lib/mysql030805 11:08:05 mysqld ended



Output:

030805 11:07:53 mysqld started
030805 11:07:53 InnoDB: Out of memory in additional memory pool.
InnoDB: InnoDB will start allocating memory from the OS.
InnoDB: You may get better performance if you configure a bigger
InnoDB: value in the MySQL my.cnf file for
InnoDB: innodb_additional_mem_pool_size.
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
030805 11:07:53 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
030805 11:08:01 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
030805 11:08:03 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
030805 11:08:05 InnoDB: Started
030805 11:08:05 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
030805 11:08:05 mysqld ended



Again it says it cannot find the host.frm file that exists.

I am super grateful for any help on this

Tuka

Try changing the ownership and group of the /var/lib/mysql folder to mysql recursively

Your suggestion worked nicely. Thanks

PS: By the way, it was MySQL version 3.xx and not 8.xx but I am sure you caught that.