It runs now.
I tried many things, so I'm not sure of what I did in order to make it run,
but I think these things where important
- always be sure that /var/lib/mysql is 'chowned -R mysql:mysql'
- run mysql_install_db to install base tables properly
- start manually mysql with : 'safe_mysqld
--defaults-file=/path/to/your/config/file'
this file contains the following (in my case, but I think it's the rpm-orig
too) :
<snip>
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
</snip>
I did a lot of things to make it run, so this list is maybe not exactly the
good way, but it will surely help ;-)
Remember:
- Read manual or search manual.pdf with your error, type in your error in
the search box on www.google.com, you'll find directly mailing-lists
archives talking about your problem.
thanks ,
Bastien
<just do it>
> > > Before posting, please check:
> > > http://www.mysql.com/manual.php (the manual)
> > > http://lists.mysql.com/ (the list archive)
</just do it>
> -----Original Message-----
> From: Chris Freeman [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, May 21, 2001 2:29 PM
> To: DEVOS BASTIEN
> Subject: Re: mysql start failed.
>
> oops that was not quite right,
> that was a mixture of starting the daemon and connecting to the server all
> with one command, and would never have worked. I am very new to mysql, so
> you will have to forgive me for that one.
>
>
>
> first step, if you haven't done it already, is to go
>
> cd /usr
> ./bin/mysql_install_db
>
>
> then, go to /var/lib/mysql, and make sure a folder called mysql exists
> within that directory
> (ie, if you can go
>
> cd /var/lib/mysql/mysql
>
> then it has worked)
>
>
> if okay so far, try
>
> safe_mysqld --basedir=/usr -u root mysql &
>
>
> that should start the daemon,
> then try to connect with
>
> mysql -u root -p
>
> if that fails, please let me know where and in what way.
>
> IF that works, configure it using instructions on this top-notch site
>
> http://www.mysql.com/documentation/mysql/bychapter/
> Cheers,
> Chris
>
> ----- Original Message -----
> From: "DEVOS BASTIEN" <[EMAIL PROTECTED]>
> To: "'Chris Freeman'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Monday, May 21, 2001 7:39 PM
> Subject: RE: mysql start failed.
>
>
> > 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
