Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 430
  • 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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
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

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

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