In news:[EMAIL PROTECTED],
satimis <[EMAIL PROTECTED]> wrote:
> Pls advise how to locate mysql=E2=80=99s hostname.pid file?
Try looking in standard directories such as:
/var/run/mysqld or /var/run/mysql or /var/run
The filename can be in form of 'hostname.pid', but it will rather be named
'mysqld.pid'.
Alternatively, if you have slocate package installed and the database is
running for some time now (a day or so), you may try to run
# locate mysqld.pid
/var/run/mysqld/mysqld.pid
The tool will tell you where the file should be.
> Then to run;
> # kill `cat /mysql-data-directory/host_name.pid`
> mysqld_safe =E2=80=93skip-grant-tables &
> mysqladmin -u root flush-privileges password
> =E2=80=9Cnewpassword=E2=80=9D
The other way to find out the process ID of MySQL is looking at the process
list with 'ps' or 'pstree'.
# ps axf | grep "[m]ysqld"
9238 ? Ssl 0:01 /usr/sbin/mysqld --defaults-file=...
# pstree -p mysql
mysqld(9238)-+-{mysqld}(9245)
|-{mysqld}(9246)
|-{mysqld}(9247)
|-{mysqld}(9248)
...
In this case 9238 is the PID you would need to send TERM signal to in order
to stop mysql server:
# kill 20868
Maciek
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
