Re: MYSQL startup error

[Supote Leelasupphakorn]

 --- Gareth Bailey [EMAIL PROTECTED] wrote:  I am running
5.2 Release, and have recently installed
 mysql-4.0.18 server. I
 first made a default install by issuing the following commands
 in the port:
 
 $ make
 # make install
 $ cd /var/db/mysql  mysql_db_install
 
 Worked perfectly when i started up with:
 $ mysqld_safe 
 
 Then i decided i wanted to reinstall with DB_DIR=/usr/db/mysql
 I made deinstall and clean in the port. I removed the /var/db
 directory
 manually. I then did the following in an attempt to install
 the DB_DIR in
 /usr/db/mysql:
 
 # mkdir /usr/db/mysql
 # chown -R mysql /usr/db
 #chgrp -R mysql /usr/db
 $ make DB_DIR=/usr/db/mysql
 # make DB_DIR=/usr/db/mysql install
 
 I encountered the following two problems:
 
 1. Crontab complained with the following message:
 
 mkdir: /var/db/entropy: Permission denied
 /usr/libexec/save-entropy[45954]: The entropy directory
 /var/db/entropy does
 not exist, and cannot be created. Therefore no entropy can be
 saved.
 
 I solved this by creating /var/db/entropy and chowned and
 chgrped to mysql
 (don't know if that was right.)
 
 2. I can't start mysqld_safe using command 'mysqld_safe '. I
 get the
 following errors...
 
  when i try as normal user:
 /usr/local/bin/mysqld_safe: cannot create
 /usr/db/mysql/server.err:
 Permission denied
 
 when i try from  root:
 server# Starting mysqld daemon with databases from
 /usr/db/mysql
 040318 09:51:58  mysqld ended
 
 I had a look at server.err in /usr/db/mysql and i found the
 following line:
 
 040318  9:51:56  Fatal error: Can't open privilege tables:
 Can't find file:
 './mysql/host.frm' (errno: 13)
 
 Please advise. Any assistance will be very much appreciated.
 Thank you
 Gareth

After you re-install, have you run the script: mysql_db_install 
again ? That script is for prepare core database in data 
directory (in this case is /usr/db/mysql) and then don't forget
to chown and chgrp /usr/db/mysql as well.






Yahoo! Messenger - Communicate instantly...Ping 
your friends today! Download Messenger Now 
http://uk.messenger.yahoo.com/download/index.html
___
[EMAIL PROTECTED] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]

MYSQL startup error

[Gareth Bailey]

I am running 5.2 Release, and have recently installed mysql-4.0.18 server. I
first made a default install by issuing the following commands in the port:

$ make
# make install
$ cd /var/db/mysql  mysql_db_install

Worked perfectly when i started up with:
$ mysqld_safe 

Then i decided i wanted to reinstall with DB_DIR=/usr/db/mysql
I made deinstall and clean in the port. I removed the /var/db directory
manually. I then did the following in an attempt to install the DB_DIR in
/usr/db/mysql:

# mkdir /usr/db/mysql
# chown -R mysql /usr/db
#chgrp -R mysql /usr/db
$ make DB_DIR=/usr/db/mysql
# make DB_DIR=/usr/db/mysql install

I encountered the following two problems:

1. Crontab complained with the following message:

mkdir: /var/db/entropy: Permission denied
/usr/libexec/save-entropy[45954]: The entropy directory /var/db/entropy does
not exist, and cannot be created. Therefore no entropy can be saved.

I solved this by creating /var/db/entropy and chowned and chgrped to mysql
(don't know if that was right.)

2. I can't start mysqld_safe using command 'mysqld_safe '. I get the
following errors...

 when i try as normal user:
/usr/local/bin/mysqld_safe: cannot create /usr/db/mysql/server.err:
Permission denied

when i try from  root:
server# Starting mysqld daemon with databases from /usr/db/mysql
040318 09:51:58  mysqld ended

I had a look at server.err in /usr/db/mysql and i found the following line:

040318  9:51:56  Fatal error: Can't open privilege tables: Can't find file:
'./mysql/host.frm' (errno: 13)

Please advise. Any assistance will be very much appreciated.
Thank you
Gareth






___
[EMAIL PROTECTED] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]