Starting Up MySQL daemon
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. :) |
All times are GMT -5. The time now is 07:04 AM. |