Problems starting MySQL server

raystar · 01-05-2012, 04:25 AM

i have a big problem running any data management app.ive tried lemonpos open erp.am suspecting it all has to do with mysql server which has refused to start.can someone help?
ray@ray-laptop:~$ sudo /etc/init.d/mysql start
[sudo] password for ray:
sudo: /etc/init.d/mysql: command not found
ray@ray-laptop:~$ sudo /etc/init.d/mysql start
sudo: /etc/init.d/mysql: command not found
ray@ray-laptop:~$

jv2112 · 01-05-2012, 04:36 AM

First off I would suggest not placing "urgent" in your subject line. That is a relative term and not very descriptive to what your concern is. If you would like some help please post some more information so members can have a better understanding of the issue.

Questions to start -->

Is mysql installed ? ( sudo aptitude install mysql )

If so where is it ? ( sudo find / -iname mysql )

Is it in your path ? ( echo $PATH )

What distro are you using ? ( I assume Ubuntu )

deep27ak · 01-05-2012, 05:06 AM

deleted

APOLOGIES

TB0ne · 01-05-2012, 11:06 AM

Quote:

Originally Posted by deep27ak

The first thing for a system administrator is PATIENCE which if you don't have you might face problem. So writing urgent won't make any difference instead use appropriate heading which will be helpful for both of us. make sure the path you are using is appropriate

use this command to lookout for the path of command

Code:

#which mysql
/usr/bin/mysql   <---you will get output something similar to this

I don't think mysql lies inside

Code:

/etc/init.d

Code:

#/usr/bin/mysql start

Sorry, no. Starting MySQL like that isn't the recommended way.../etc/init.d/mysql start is the correct command most of the time. Starting the daemon that way requires a bunch of different variables, like the PID file, sockets, etc. The start script does this for you.

If the start script is missing (an "ls /etc/init.d/my*" will tell you), and it WAS there, then it somehow got deleted. If this is 'urgent', how about some actual details?? Version/distro of Linux, who has access to the system, any recent changes/patches/updates, etc.

deep27ak · 01-05-2012, 09:49 PM

Thanks for the info TB0ne

In that case I believe the package is missing because in my workstation even I was getting the same error while trying to run

Code:

#/etc/init.d/mysql start
/etc/init.d/mysql No such file or directory

after I did a bit of google and fond that I need to install a package mysql-server

after which

Code:

# /etc/init.d/mysqld start
Starting MySQL:                                            [  OK  ]

# service mysqld start
Starting MySQL:                                            [  OK  ]

Is it because I installed mysql-server, I am getting mysqld instead of mysql or both are same thing?
Can you help me removing my confusion?

chrism01 · 01-05-2012, 11:02 PM

mysqld = "mysql daemon" aka server

colucix · 01-06-2012, 01:32 AM

Please use a descriptive title for your thread excluding words like 'urgent' or 'help'. Using a proper title makes it easier for members to help you. Moreover, demanding urgent help from a community of volunteers that spend some of their free time to help others, is considered rude. Title edited.

TB0ne · 01-06-2012, 10:15 AM

Quote:

Originally Posted by deep27ak

Thanks for the info TB0ne
In that case I believe the package is missing because in my workstation even I was getting the same error while trying to run

Code:

#/etc/init.d/mysql start
/etc/init.d/mysql No such file or directory

after I did a bit of google and fond that I need to install a package mysql-server after which

Code:

# /etc/init.d/mysqld start
Starting MySQL:                                            [  OK  ]
# service mysqld start
Starting MySQL:                                            [  OK  ]

Is it because I installed mysql-server, I am getting mysqld instead of mysql or both are same thing? Can you help me removing my confusion?

Chrism01 answered it already. And obviously if you don't install mysql-server, you won't be able to RUN a MySQL server, anymore than you could run a mail server without installing one. Which is why I asked what I did to the OP.