[FC2] Can't start mysql

[Coume - Lubox.com]

Hello,

Is something changed in the way mysql is working under FC2?
I have been trying for the last 3hours to get mysql working but I can't.
Before I just had to do "mysqld start" to active mysql and that was it,
I was even to activate it at boot time.

But now, it does not work. It always tells me, "bash: mysqld: command
not found"
Then I checked if I have installed the mysql packages... but all the
packages available are installed.

Anybody experienced that? I really hope that it a dumb and easy problem
to solve, as I badly need to use mysql today :(

Thanks in advance
Ludo
______________________________________
http://www.mythTVtalk.com (Now Open!!!)
Feel free to assist us in building a MythTV community!

[Ron Palmer]

you can always try fedora GUI
system-config-services

and manually start mysql in that GUI. You can set its default boot
behaviour as well.

IF you  haven't access to X, have a look in /etc/rc.d/init.d and run
/etc/rc.d/init.d/mysqld restart (or start or stop or status...)

Have fun,
Ron

On Sun, 2004-05-30 at 21:58, Coume - Lubox.com wrote:
> Hello,
>
> Is something changed in the way mysql is working under FC2?
> I have been trying for the last 3hours to get mysql working but I can't.
> Before I just had to do "mysqld start" to active mysql and that was it,
> I was even to activate it at boot time.
>
> But now, it does not work. It always tells me, "bash: mysqld: command
> not found"
> Then I checked if I have installed the mysql packages... but all the
> packages available are installed.
>
> Anybody experienced that? I really hope that it a dumb and easy problem
> to solve, as I badly need to use mysql today :(
>
> Thanks in advance
> Ludo
> ______________________________________
> http://www.mythTVtalk.com (Now Open!!!)
> Feel free to assist us in building a MythTV community!

[Coume - Lubox.com]

On Sun, 2004-05-30 at 14:11, Ron Palmer wrote:
> you can always try fedora GUI
> system-config-services
>
> and manually start mysql in that GUI. You can set its default boot
> behaviour as well.
>
> IF you  haven't access to X, have a look in /etc/rc.d/init.d and run
> /etc/rc.d/init.d/mysqld restart (or start or stop or status...)

It's what I was speaking about in my previous msg.
But when I try to do that, it fails and gives me as error:
command not found.

Ludo
______________________________________
http://www.mythTVtalk.com (Now Open!!!)
Feel free to assist us in building a MythTV community!

[Juan Martinez]

On Sun, 2004-05-30 at 07:58, Coume - Lubox.com wrote:
> Hello,
>
> Is something changed in the way mysql is working under FC2?
> I have been trying for the last 3hours to get mysql working but I can't.
> Before I just had to do "mysqld start" to active mysql and that was it,
> I was even to activate it at boot time.
>
> But now, it does not work. It always tells me, "bash: mysqld: command
> not found"
> Then I checked if I have installed the mysql packages... but all the
> packages available are installed.
>
> Anybody experienced that? I really hope that it a dumb and easy problem
> to solve, as I badly need to use mysql today :(
>
> Thanks in advance
> Ludo

The only way "mysqld start" will work is if you have /etc/rc.d/init.d in
your path.  Use the absolute path to the script mysqld when you run your
command or use "service mysqld start".  BTW, "service" is in the /sbin
directory.

Good luck,
Juan

[Coume - Lubox.com]

> The only way "mysqld start" will work is if you have /etc/rc.d/init.d in
> your path.  Use the absolute path to the script mysqld when you run your
> command or use "service mysqld start".  BTW, "service" is in the /sbin
> directory.

Hello

If I type: /sbin/service mysqld start
If give me this error:

Initializing MySQL database: OK
Timeout error occured trying to start Mysql Daemon
Starting MySQL: Failed

Regards,
Ludo
______________________________________
http://www.mythTVtalk.com (Now Open!!!)
Feel free to assist us in building a MythTV community!

[Hannes Mayer]

Coume - Lubox.com wrote:
> > The only way "mysqld start" will work is if you have /etc/rc.d/init.d in
> > your path.  Use the absolute path to the script mysqld when you run your
> > command or use "service mysqld start".  BTW, "service" is in the /sbin
> > directory.
>
> Hello
>
> If I type: /sbin/service mysqld start
> If give me this error:
>
> Initializing MySQL database: OK
> Timeout error occured trying to start Mysql Daemon
> Starting MySQL: Failed

Did you remove the anonymous user in MySQL ?

from /etc/rc.d/init.d/mysqld:

# If you've removed anonymous users, this line must be changed to
         # use a user that is allowed to ping mysqld.
         ping="/usr/bin/mysqladmin -uUNKNOWN_MYSQL_USER ping"

if the user you're using also has a password, add -ppassword

Cheers,
Hannes.

[Coume - Lubox.com]

On Sun, 2004-05-30 at 14:57, Hannes Mayer wrote:
> Did you remove the anonymous user in MySQL ?
>
> from /etc/rc.d/init.d/mysqld:
>      # If you've removed anonymous users, this line must be changed to
>      # use a user that is allowed to ping mysqld.
>      ping="/usr/bin/mysqladmin -uUNKNOWN_MYSQL_USER ping"
>
> if the user you're using also has a password, add -ppassword

No, I did not remove anything, and I changed nothing at all it is in the
same state that it is when you just install FC2.

I do not understand, I never had any problem with my other installation
before :(

Ludo
______________________________________
http://www.mythTVtalk.com (Now Open!!!)
Feel free to assist us in building a MythTV community!

[Shockwave]

On Sun, 2004-05-30 at 09:17, Coume - Lubox.com wrote:
> On Sun, 2004-05-30 at 14:57, Hannes Mayer wrote:
> > Did you remove the anonymous user in MySQL ?
> >
> > from /etc/rc.d/init.d/mysqld:
> >      # If you've removed anonymous users, this line must be changed to
> >      # use a user that is allowed to ping mysqld.
> >      ping="/usr/bin/mysqladmin -uUNKNOWN_MYSQL_USER ping"
> >
> > if the user you're using also has a password, add -ppassword
>
> No, I did not remove anything, and I changed nothing at all it is in the
> same state that it is when you just install FC2.
>
> I do not understand, I never had any problem with my other installation
> before :(
>
> Ludo

Edit the /etc/rc.d/init.d/mysqld script and add "-u mysqld" to the lines
that issue the "mysqladmin ping" command so they look like this:
        mysqladmin -u mysqld ping

That should do the trick.  ;)

Shockwave

[Alexander Dalloz]

Am So, den 30.05.2004 schrieb Shockwave um 15:35:
> > > from /etc/rc.d/init.d/mysqld:
> > >      # If you've removed anonymous users, this line must be changed to
> > >      # use a user that is allowed to ping mysqld.
> > >      ping="/usr/bin/mysqladmin -uUNKNOWN_MYSQL_USER ping"
> Edit the /etc/rc.d/init.d/mysqld script and add "-u mysqld" to the lines
> that issue the "mysqladmin ping" command so they look like this:
>         mysqladmin -u mysqld ping
>
> That should do the trick.  ;)
> Shockwave

No, you are speaking of an issue with the FC1 mysqld init script, which
fails after setting the password for the MySQL root user.

See above, in the FC1 mysqld init script this is already fixed and no
changes needed.

Alexander

[Craig Thomas]

On Sun, 2004-05-30 at 08:52, Coume - Lubox.com wrote:
> If I type: /sbin/service mysqld start
> If give me this error:
>
> Initializing MySQL database: OK
> Timeout error occured trying to start Mysql Daemon
> Starting MySQL: Failed

Are you sure it is not already running?
> Regards,
> Ludo

Craig Thomas

[Coume - Lubox.com]

On Sun, 2004-05-30 at 15:27, Craig Thomas wrote:
> On Sun, 2004-05-30 at 08:52, Coume - Lubox.com wrote:
> > If I type: /sbin/service mysqld start
> > If give me this error:
> >
> > Initializing MySQL database: OK
> > Timeout error occured trying to start Mysql Daemon
> > Starting MySQL: Failed
>
> Are you sure it is not already running?

Hi craig,

I tried the mysqld status and it gives me this error:
mysqld dead but subsys locked

I have no clue what it means :/
Ludo
______________________________________
http://www.mythTVtalk.com (Now Open!!!)
Feel free to assist us in building a MythTV community!

[Craig Thomas]

On Sun, 2004-05-30 at 09:35, Coume - Lubox.com wrote:
> I tried the mysqld status and it gives me this error:
> mysqld dead but subsys locked

Try removing the

/var/lock/subsys/mysql

file and then

service mysqld restart

Craig Thomas

[Hannes Mayer]

Craig Thomas wrote:
> On Sun, 2004-05-30 at 09:35, Coume - Lubox.com wrote:
> > I tried the mysqld status and it gives me this error:
> > mysqld dead but subsys locked
>
> Try removing the
>
> /var/lock/subsys/mysql
>
> file and then
>
> service mysqld restart

AHH! We're getting close ;-)

Yep, remove the lockfile - make sure no mysqld processes
are running
# ps -A
...
in case:
# killall mysqld
and then start

Cheers,
Hannes.

[FC2] Can't start mysql [SOLVED]

[Coume - Lubox.com]

On Sun, 2004-05-30 at 16:26, Hannes Mayer wrote:
> Craig Thomas wrote:
> > On Sun, 2004-05-30 at 09:35, Coume - Lubox.com wrote:
> > > I tried the mysqld status and it gives me this error:
> > > mysqld dead but subsys locked
> >
> > Try removing the
> >
> > /var/lock/subsys/mysql
> >
> > file and then
> >
> > service mysqld restart
>
> AHH! We're getting close ;-)
>
> Yep, remove the lockfile - make sure no mysqld processes
> are running
> # ps -A
> ...
> in case:
> # killall mysqld
> and then start
>
> Cheers,
> Hannes.

gosh it's finally solved and it is now working.
After doing these steps several times and several reboots, it seems to
be working correctly now! and even when I reboot it still works :D :D

Thxs all for your help!
regards,
Ludovic
______________________________________
http://www.mythTVtalk.com (Now Open!!!)
Feel free to assist us in building a MythTV community!

[Craig Thomas]

On Sun, 2004-05-30 at 07:58, Coume - Lubox.com wrote:
> Before I just had to do "mysqld start" to active mysql and that was it,
> I was even to activate it at boot time.

Have your tried:

service mysqld restart [in case it is already running]
or
service mysqld start
or
service mysqld status
> Thanks in advance
> Ludo

HTH,

Craig Thomas