LinuxQuestions.org
Go Job Hunting at the LQ Job Marketplace
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
Search this Thread
Old 08-05-2003, 06:36 AM   #1
tuka
Member
 
Registered: Jul 2003
Location: Lisbon, Portugal
Distribution: Red Hat 9.0
Posts: 30

Rep: Reputation: 15
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
 
Old 08-05-2003, 06:58 AM   #2
Cooner
Member
 
Registered: Jul 2003
Location: Hastings, MN. USA
Distribution: Ubuntu 10.xx
Posts: 109

Rep: Reputation: 15
Try changing the ownership and group of the /var/lib/mysql folder to mysql recursively
 
Old 08-06-2003, 11:45 AM   #3
tuka
Member
 
Registered: Jul 2003
Location: Lisbon, Portugal
Distribution: Red Hat 9.0
Posts: 30

Original Poster
Rep: Reputation: 15
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.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Starting MySQL OLD Error : imeout error occurred trying to start MySQL Daemon Fr33B5D Linux - Software 9 10-28-2006 06:23 AM
still cant get nmb daemon starting eroica Linux - Networking 1 12-02-2004 08:42 PM
Starting mysql daemon as user rather than root arubin Slackware 8 05-10-2004 04:03 PM
Starting FTP Daemon baunemann Linux - Networking 4 03-14-2004 10:07 AM
Starting daemon during boot up chuck77 Linux - General 3 03-27-2002 06:47 AM


All times are GMT -5. The time now is 03:43 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration