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]