LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)
-   -   Problems starting MySQL server (https://www.linuxquestions.org/questions/linux-newbie-8/problems-starting-mysql-server-922170/)

raystar 01-05-2012 04:25 AM

Problems starting MySQL server
 
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 :doh:

TB0ne 01-05-2012 11:06 AM

Quote:

Originally Posted by deep27ak (Post 4566711)
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 (Post 4567540)
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.


All times are GMT -5. The time now is 01:30 AM.