You need a data directory in the mysql directory. Did you run the install script?
The install script is at: scripts/mysql_install_db For a normal linux/unix install you need to do the following.... ------------------------------------------- cd /usr/local/mysql/ groupadd mysql useradd -g mysql mysql scripts/mysql_install_db chown -R root /usr/local/mysql chown -R mysql /usr/local/mysql/data chgrp -R mysql /usr/local/mysql chown -R root /usr/local/mysql/bin ------------------------------------------- Hope this helps.. bonne chance, Andrew Sql, query, wibble -----Original Message----- From: Yoann [mailto:linux-yoann@;ifrance.com] Sent: Thursday, 17 October 2002 23:36 To: [EMAIL PROTECTED] Subject: Re: mysql 4.04beta I haven't a directory called "data" in the mysql directory and I never specified where mysql have to put the database. I try to find where mysql is supposed to get the mysql.host and the database but i don't find it yet So in which file I can't get this information ? thanks yoann Andrew Braithwaite a écrit: >Hi, > >If I had to guess - I would say that you do not have permissions for >the datadir. > >Try the following: > >Chown -R mysql:root /usr/local/mysql/data (or wherever your datadir >is....) > >And > >Chmod -R 660 /usr/local/mysql/data (or wherever your datadir is....) > >Cheers, > >Andrew > >Sql, query, wibble > >-----Original Message----- >From: Yoann [mailto:linux-yoann@;ifrance.com] >Sent: Thursday, 17 October 2002 21:33 >To: [EMAIL PROTECTED] >Subject: mysql 4.04beta > > >hi all, >I just finished to compile mysql 4.04 beta but when I start mysqld I >have this error > ># mysqld -u mysql & >[1] 19034 >22:10:55 babar:/usr/web/mysql# 021017 22:10:55 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. >021017 22:10:56 InnoDB: Database was not shut down normally. >InnoDB: Starting recovery from log files... >InnoDB: Starting log scan based on checkpoint at >InnoDB: log sequence number 0 37082 >InnoDB: Doing recovery: scanned up to log sequence number 0 37082 021017 >22:10:56 InnoDB: Flushing modified pages from the buffer pool... >InnoDB: Creating foreign key constraint system tables >InnoDB: Foreign key constraint system tables created >021017 22:10:56 InnoDB: Started >021017 22:10:56 Fatal error: Can't open privilege tables: Table >'mysql.host' doesn't exist > >is it a bug or I have to do another thing before lauch mysqld ? thanks >for you help yoann > > >--------------------------------------------------------------------- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > >--------------------------------------------------------------------- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > >___________________________________________________________________ >Haut Débit: Modem offert soit 150,92 euros remboursés sur le Pack >eXtense de Wanadoo ! Profitez du Haut Débit à partir de 30 euros/mois : >http://www.ifrance.com/_reloc/w > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
