Re: Problem starting up mysql

[mathan]

 I installed mysql 4.0.14 binary distribution on RedHat
 8.0 following the instructions in the manual. But I
 can't get it to work. Please help. 
 
 When I start mysql using the command:
 
 shell bin/mysqld_safe --use=mysql 
 
 the following message shows: 
 Starting mysqld daemon with databases from
 /var/lib/mysql
 
 030910 01:29:23  mysqld ended
 
 I have no idea what is going on here.

Check the file permission for your data directory /var/lib/mysql
or change the file permission as

# chown -R mysql  /var/lib/mysql
# chmod 700  /var/lib/mysql

and then start the mysql daemon

thanks
--mathan


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.491 / Virus Database: 290 - Release Date: 6/18/2003


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Problem starting up mysql

[Claire Lee]

Hi all,

I installed mysql 4.0.14 binary distribution on RedHat
8.0 following the instructions in the manual. But I
can't get it to work. Please help. 

When I start mysql using the command:

shell bin/mysqld_safe --use=mysql 

the following message shows: 
Starting mysqld daemon with databases from
/var/lib/mysql

030910 01:29:23  mysqld ended

I have no idea what is going on here.

If I try to test it with:

shellcd sql-bench; perl run-all-tests

I get the following error message:

Got error: 'Can't connect to local MySQL server
through socket '/var/lib/mysql/m
ysql.sock' (2)' when connecting to
DBI:mysql:database=test;host=localhost with u
ser: '' password: '' 

And mysql log has the following message

030904 13:03:06  mysqld started
030904 13:03:07  InnoDB: Started
030904 13:03:07  Fatal error: Can't open privilege
tables: Can't find file: './mysql/host.frm' (errno:
13)
030904 13:03:07  Aborting

030904 13:03:07  InnoDB: Starting shutdown...
030904 13:03:09  InnoDB: Shutdown completed
030904 13:03:09  /usr/local/mysql/bin/mysqld: Shutdown
Complete

030904 13:03:09  mysqld ended 

Anyone can tell me what goes wrong here? Thanks a lot.

Claire


__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]