thank you for your answer, but I ran mysql the way you explained
(safe_mysqld --basedir=/usr -u user -p password), but it doesn't change
anything.
Here is the log :
<snip>
basedir: /usr/
datadir: /var/lib/mysql/
tmpdir: /tmp/
language: /usr/share/mysql/english/
pid file: /var/run/mysqld/mysqld.pid
TCP port: 3306
Unix socket: /var/lib/mysql/mysql.sock
system locking is not in use
Possible variables for option --set-variable (-O) are:
back_log current value: 50
binlog_cache_size current value: 32768
connect_timeout current value: 5
delayed_insert_timeout current value: 300
delayed_insert_limit current value: 100
delayed_queue_size current value: 1000
flush_time current value: 0
interactive_timeout current value: 28800
join_buffer_size current value: 131072
key_buffer_size current value: 8388600
long_query_time current value: 10
lower_case_table_names current value: 0
max_allowed_packet current value: 1048576
max_binlog_cache_size current value: 4294967295
max_connections current value: 100
max_connect_errors current value: 10
max_delayed_threads current value: 20
max_heap_table_size current value: 16777216
max_join_size current value: 4294967295
max_sort_length current value: 1024
max_tmp_tables current value: 32
max_write_lock_count current value: 4294967295
myisam_sort_buffer_size current value: 8388608
net_buffer_length current value: 16384
net_retry_count current value: 10
net_read_timeout current value: 30
net_write_timeout current value: 60
open_files_limit current value: 0
query_buffer_size current value: 0
record_buffer current value: 131072
slow_launch_time current value: 2
sort_buffer current value: 2097144
table_cache current value: 64
thread_concurrency current value: 10
thread_cache_size current value: 0
tmp_table_size current value: 1048576
thread_stack current value: 65536
wait_timeout current value: 28800
010521 11:34:12 mysqld ended
</snip>
any other idea ?
I even ran it with all options listed here in the log. I mean basedir,
tmpdir, ...
thanks,
Bastien.
> -----Original Message-----
> From: Chris Freeman [SMTP:[EMAIL PROTECTED]]
> Sent: Saturday, May 19, 2001 3:07 PM
> To: DEVOS BASTIEN
> Subject: Re: mysql start failed.
>
> the answer is to set the basedir when you start the daemon. I can't
> remember the exact syntax, and I'm not near my linux box at the moment.
> something like.
>
> safe_mysqld -basedir=/usr -u root -p password &
>
> that's probably not exact but along those lines.
>
> i had a bitch of a time getting it working too with the same error. found
> the answer in the installation guide at www.mysql.com
>
> your base directory may be different. Mine was on RH 7.0, following the
> installation instructions from mysql.com to the letter, using the RPM
> from
> the red hat CD. once i ran it with the basedir argument i stopped getting
> the error that you are.
> ----- Original Message -----
> From: DEVOS BASTIEN <[EMAIL PROTECTED]>
> Newsgroups: mailing.database.mysql
> Sent: Friday, 18 May 2001 10:40 PM
> Subject: RE: mysql start failed.
>
>
> > Nothing is running.
> > I tried removing the socket mysql.sock and trying reconnect, but it
> creates
> > a new socket mysql.sock and mysql is not running.
> > I know this kind of problem is known, but I never found a solution.
> >
> >
> > > -----Original Message-----
> > > From: Rolf Hopkins [SMTP:[EMAIL PROTECTED]]
> > > Sent: Friday, May 18, 2001 1:29 PM
> > > To: DEVOS BASTIEN; [EMAIL PROTECTED]
> > > Subject: Re: mysql start failed.
> > >
> > > has it already started? ps -ef | grep mysql
> > >
> > >
> > > ----- Original Message -----
> > > From: "DEVOS BASTIEN" <[EMAIL PROTECTED]>
> > > To: <[EMAIL PROTECTED]>
> > > Sent: Friday, May 18, 2001 19:11
> > > Subject: mysql start failed.
> > >
> > >
> > > > Here's a problem I have when trying starting mysql.
> > > > Config : RH7.0, MySQL 3.23.32, kernel2.4.3.
> > > > I read that there's a problem with RH7.0 and that a ´chown -R mysql
> > > > /var/lib/mysql´ should resolve that, but it doesn't change anything.
> > > >
> > > > always this message :
> > > > <snip>
> > > > 010518 13:00:22 mysqld started
> > > > 010518 13:00:22 /usr/libexec/mysqld: Can't find file:
> > > './mysql/host.frm'
> > > > (errno: 13)
> > > > 010518 13:00:22 mysqld ended
> > > > </snip>
> > > >
> > > > even when I boot, it says :
> > > > blahblah [OK]
> > > > blahblah [OK]
> > > > Starting MySQL [OK]
> > > > mysqld ended
> > > > blahblah [OK]
> > > > blahblah [OK]
> > > > blahblah [OK]
> > > >
> > > > Any idea ?
> > > >
> > > >
> ---------------------------------------------------------------------
> > > > 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
> >
> > ---------------------------------------------------------------------
> > 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