#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2012
    Posts
    15
    Rep Power
    0

    Question Database kill process


    I have a database on windows. I want to end postgresql/mysql program/database via task manager or via terminal in linux. The reason I want to end it is because I forgot the username and password. I want to kill the database so I can try to reconnect to it and guess the username and password.
    Last edited by goinsurgency; June 19th, 2012 at 02:54 AM. Reason: sorry i meant mysql/postgres
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Oct 2003
    Location
    Germany
    Posts
    2,788
    Rep Power
    349
    Originally Posted by goinsurgency
    I want to end mysql program/database
    If you are running MySQL why are you asking in the PostgreSQL forum?
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2012
    Posts
    15
    Rep Power
    0
    Originally Posted by shammat
    If you are running MySQL why are you asking in the PostgreSQL forum?
    sorry meant posatgres/mysql
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Oct 2003
    Location
    Germany
    Posts
    2,788
    Rep Power
    349
    Originally Posted by goinsurgency
    sorry meant posatgres/mysql
    There is no such thing as "postgres/mysql".

    PostgreSQL and MySQL are two completely different things.

    What exactly are you running?
  8. #5
  9. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2012
    Posts
    15
    Rep Power
    0
    Originally Posted by shammat
    There is no such thing as "postgres/mysql".

    PostgreSQL and MySQL are two completely different things.

    What exactly are you running?
    I am trying out both.
  10. #6
  11. No Profile Picture
    Contributing User
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Oct 2003
    Location
    Germany
    Posts
    2,788
    Rep Power
    349
    Originally Posted by goinsurgency
    I want to end postgresql/mysql program/database via task manager or via terminal in linux.
    No you don't. Use a regular "shutdown" command to stop the server.

    The standard command is:
    Code:
    pg_ctl -D /your/data/directory stop
    This works in Windows and Linux.

    In Windows you can also use the control panel to stop the service, or the command
    Code:
    net stop postgresql
    The exact name of the service depends on your installation and you need to check that in the control panel.

    For more information I suggest you read the manual:

    http://www.postgresql.org/docs/current/static/app-pg-ctl.html
    http://www.postgresql.org/docs/current/static/server-start.html
    http://www.postgresql.org/docs/current/static/server-shutdown.html

IMN logo majestic logo threadwatch logo seochat tools logo