Starting MySQL daemon Post: 302099930

Sponsored Content

Top Forums UNIX for Dummies Questions & Answers Starting MySQL daemon Post 302099930 by unispace on Thursday 14th of December 2006 07:23:28 PM

12-14-2006

Registered User

Okay, so I killed all mysql processes. I check ps aux and no mysql process are running. Then I start it via the shell script and I check ps aux (below). Now I check my website to see if it connects to the database and it doesn't, shows a mysql error. THen I try to connect to the database via the shell and it says
"ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)" Don't I need to start mysqld, or is it already running?

Code:

root  11987  0.0  0.2  2228  1916  p0  S     4:15PM   0:00.04 /usr/local/bin/bash
root  12007  0.0  0.1  1764  1400  p0  S     4:16PM   0:00.01 sh /usr/local/etc/rc.d/mysql-server
root  12017  0.0  0.1  1604  1268  p0  S     4:16PM   0:00.01 su -m mysql -c sh -c "/usr/local/bin
mysql 12018  0.0  0.2  2188  1876  p0  S     4:16PM   0:00.02 /usr/local/bin/bash
mysql 12020  0.0  0.1  1408   928  p0  R+    4:16PM   0:00.00 ps aux

unispace

View Public Profile for unispace

Find all posts by unispace

6 More Discussions You Might Find Interesting

1. Linux

mysql not starting with fedora linux

Hi... I have installed mysql in Fedora and when i tried to start mysql the error i get was "Asked for 196608 thread stack" What might be the problem???? I have tried all ways but doesnt work out........

2. Solaris

Problems starting apache 1.3 with mysql

I've been working on a project to replace one of the my group's primary NIS servers. It also runs mysql and apache, as it is the host for the our team's hardware tracking database and website. Its running apache 1.3, and for some odd reason, I can't get apache to start on system boot. The...

3. SCO

Stoping & starting the cron daemon

Hi We are running SCO ver 5. Recently the cron daemon stopped running on its own. How do I find out why? How do I restart/stop it? I typed cron but it didn't work. Will rebooting it do the trick or can I manually start and stop the cron daemon? Please help. Thanks & Regards.

4. Shell Programming and Scripting

How to starting process as daemon using ssh command?

Hello, I need to run a command on remote Linux using the ssh command from my local machine. I am able to execute the command on remote machine using ssh but it's behaving strangely. The command is supposed to start a daemon process on remote linux box and the control should return back to me...

5. UNIX and Linux Applications

MySQL Daemon failed to start - no mysql.sock file

After doing a yum install mysql mysql-server on Fedora 14 I wasn't able to fully install the packages correctly. It installed MySQL 5.1. I was getting the following error when running the: mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)...

6. UNIX for Dummies Questions & Answers

How to grep a line not starting with # from a file (there are two lines starting with # and normal)?

e.g. File name: File.txt cat File.txt Result: #INBOUND_QUEUE=FAQ1 INBOUND_QUEUE=FAQ2 I want to get the value for one which is not commented out. Thanks,

LEARN ABOUT CENTOS

pmdamysql

PMDAMYSQL(1)						       Performance Co-Pilot						      PMDAMYSQL(1)

NAME

       pmdamysql - MySQL database PMDA

DESCRIPTION

       pmdamysql is a Performance Co-Pilot PMDA which extracts live performance data from a running MySQL database.

INSTALLATION

       pmdamysql uses a configuration file from (in this order):

       o   /etc/pcpdbi.conf

       o   $PCP_PMDAS_DIR/mysql/mysql.conf

       This file can contain overridden values (Perl code) for the settings listed at the start of pmdamysql.pl, namely:

       o   database name (see DBI(3) for details)

       o   database user name

       o   database pass word

       Once this is setup, you can access the names and values for the mysql performance metrics by doing the following as root:

	       # cd $PCP_PMDAS_DIR/mysql
	       # ./Install

       If you want to undo the installation, do the following as root:

	       # cd $PCP_PMDAS_DIR/mysql
	       # ./Remove

       pmdamysql is launched by pmcd(1) and should never be executed directly.	The Install and Remove scripts notify pmcd(1) when the agent is
       installed or removed.

Binary Status values in text
       Some of the status values are in the form of YES/NO or ON/OFF.

       Since these cannot be intepreted by tools like PMIE, they have been duplicated with a _num extension and the values of 1 (YES/ON) or 0
       (NO/OFF).

   Eg:
       o   mysql.slave_status.slave_io_running

       o   mysql.slave_status.slave_io_running_num

FILES

       /etc/pcpdbi.conf
	   configuration file for all PCP database monitors

       $PCP_PMDAS_DIR/mysql/mysql.conf
	   configuration file for pmdamysql

       $PCP_PMDAS_DIR/mysql/Install
	   installation script for the pmdamysql agent

       $PCP_PMDAS_DIR/mysql/Remove
	   undo installation script for the pmdamysql agent

       $PCP_LOG_DIR/pmcd/mysql.log
	   default log file for error messages from pmdamysql

SEE ALSO

       pmcd(1), pmdadbping.pl(1) and DBI(3).  # vi: sw=4 ts=4 et:

3.8.10							       Performance Co-Pilot						      PMDAMYSQL(1)