ok thanks, in fact I did : cd /usr/local/mysql chown -R mysql.mysql * ./bin/musql_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
encore merci ;p yoann Andrew Braithwaite a écrit:
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
___________________________________________________________________
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
