Database kill process

Dev Shed Forums Sponsor:

June 18th, 2012, 05:54 PM

goinsurgency

Registered User

Join Date: May 2012

Posts: 15

Time spent in forums: 1 h 56 m 15 sec
Reputation Power: 0

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 01:54 AM. Reason: sorry i meant mysql/postgres

June 19th, 2012, 01:31 AM

shammat

Contributing User

Join Date: Oct 2003

Location: Germany

Posts: 2,684

Time spent in forums: 1 Month 3 Weeks 3 Days 19 h 37 m 18 sec
Reputation Power: 284

Quote:

Originally Posted by goinsurgency

I want to end mysql program/database

If you are running MySQL why are you asking in the PostgreSQL forum?

June 19th, 2012, 01:54 AM

goinsurgency

Registered User

Join Date: May 2012

Posts: 15

Time spent in forums: 1 h 56 m 15 sec
Reputation Power: 0

Quote:

Originally Posted by shammat

If you are running MySQL why are you asking in the PostgreSQL forum?

sorry meant posatgres/mysql

June 19th, 2012, 02:20 AM

shammat

Contributing User

Join Date: Oct 2003

Location: Germany

Posts: 2,684

Time spent in forums: 1 Month 3 Weeks 3 Days 19 h 37 m 18 sec
Reputation Power: 284

Quote:

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?

June 20th, 2012, 02:14 AM

goinsurgency

Registered User

Join Date: May 2012

Posts: 15

Time spent in forums: 1 h 56 m 15 sec
Reputation Power: 0

Quote:

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.

June 20th, 2012, 02:23 AM

shammat

Contributing User

Join Date: Oct 2003

Location: Germany

Posts: 2,684

Time spent in forums: 1 Month 3 Weeks 3 Days 19 h 37 m 18 sec
Reputation Power: 284

Quote:

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

Database kill process

Developer Shed Advertisers and Affiliates