Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 432
  • Last Modified:

Manage MySQL via SSH

I'm trying to boost the max_allowed_packet in mySQL. I can connect via SSH and change to root user. I've written the change to my.cnf, but I do not know the correct syntax to restart mysqld.

typing service mysqld restart in SSH returns "service command not found".
0
webdork
Asked:
webdork
  • 11
  • 11
1 Solution
 
Dan CraciunIT ConsultantCommented:
You need the full path.

Type /sbin/service mysld restart

HTH,
Dan
0
 
webdorkAuthor Commented:
typing /sbin/service mysld restart

returns mysld unrecognized seervice
0
 
webdorkAuthor Commented:
service
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
Dan CraciunIT ConsultantCommented:
Yup, typo.

/sbin/service mysqld restart
0
 
webdorkAuthor Commented:
Tried that.

root@ip-xx.xx.xxx.xxx [/home/xxxxxxx]# /sbin/service mysqld restart
mysqld: unrecognized service
0
 
Dan CraciunIT ConsultantCommented:
What OS are you using? service is usually available on Redhat and variants (Fedora, CentOS etc.).

On others you can try:
sudo /etc/init.d mysqld restart

Or your daemon might be called otherwise.

use ps -aux | grep mysql
to check what processes are running that have mysql in their names.
0
 
webdorkAuthor Commented:
Cent OS 5
0
 
webdorkAuthor Commented:
root@ip-xx-xx-xxx-xxx [/home/xxxxxxxx]# sudo/etc/init.d mysqld restart
bash: sudo/etc/init.d: No such file or directory
0
 
Dan CraciunIT ConsultantCommented:
OK, so service is available. What's the output of the ps command?
0
 
Dan CraciunIT ConsultantCommented:
Tested on Centos 6 and these both work:

/sbin/service mysqld restart
/etc/init.d/mysqld restart
0
 
webdorkAuthor Commented:
root@ip-xxxxxx [/home/xxxx]# ps
  PID TTY          TIME CMD
15818 pts/0    00:00:00 su
15823 pts/0    00:00:00 bash
16024 pts/0    00:00:00 ps
0
 
Dan CraciunIT ConsultantCommented:
ps -aux | grep mysql
0
 
webdorkAuthor Commented:
verbatim give bad syntax:

root@ip-xxxxxxxxxxx [/home/xxxxxxxxxx]# ps -aux | grep mysql
Warning: bad syntax, perhaps a bogus '-'? See /usr/share/doc/procps-3.2.7/FAQ
0
 
Dan CraciunIT ConsultantCommented:
ps aux | grep mysql

It should list 3 processes containing "mysql".

It should work with the -, even with the warning...
0
 
webdorkAuthor Commented:
here is the return from typing: ps aux | grep mysql



root@ip-xxxxxxxxxx [/home/xxxxxxxxx]# ps aux | grep mysql
root      3622  0.0  0.0   2564  1188 ?        S    Apr15   0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/my              sql --pid-file=/var/lib/mysql/ip-xxxxxxxip.secureserver.net.pid
mysql     3725  0.0  2.1 331908 69116 ?        Sl   Apr15   1:07 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib              /mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --log-error=/var/lib/mysql/ip-xxxxxxxx.ip.secureserver.              net.err --pid-file=/var/lib/mysql/ip-5xxxxxxxxxxx.ip.secureserver.net.pid
root     16066  0.0  0.0   1952   560 pts/0    S+   09:51   0:00 grep mysql
0
 
Dan CraciunIT ConsultantCommented:
OK. So the mysqld daemon is named "mysqld" and is running.

What's the output of
/etc/init.d/mysqld restart
0
 
webdorkAuthor Commented:
root@ip-xxxxxxxxxxx [/home/xxxxxxxxxxx]# /etc/init.d/mysqld restart
bash: /etc/init.d/mysqld: No such file or directory
0
 
Dan CraciunIT ConsultantCommented:
Then I don't understand. I don't have a CentOS 5 box to test on, but the same commands apply since CentOS 4 so it should work.
The exception is if you or someone else manually compiled MySQL and did not create the start/stop/restart scripts, but I don't think that's the case.

You can do it the hard way, by killing processes with pid 3622 and 3725 and then running:
/bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/ip-xxxxxxxip.secureserver.net.pid

Open in new window

but that will cause problems, as the pid file will still exist after a dirty exit and you might lose uncommitted transactions.
0
 
webdorkAuthor Commented:
I got the answer from the server tech support in about 10 seconds (below).  The last tech support guy said "gee we cant help you with that" - go figure.

I'll certainly give you credit for the solution.


root@ip-xxxxxxxxxxxxx [~]# service mysql restart
Shutting down MySQL.... SUCCESS!
Starting MySQL.. SUCCESS!
root@ip-xxxxxxxxxxxxxxx [~]#
0
 
Dan CraciunIT ConsultantCommented:
They renamed the service name from mysqld to mysql... Why?
0
 
webdorkAuthor Commented:
My best experience in 5 years with EE.

Quick with advice
Stayed engaged
Put up with my frustation
0
 
Dan CraciunIT ConsultantCommented:
Glad I could help!

PS: I own a small support company so I know a bit about frustrated clients :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 11
  • 11
Tackle projects and never again get stuck behind a technical roadblock.
Join Now