|

|
how
do i manage databases in the plesk control panel?
|
Answer
by: Stuart Pierce, Aplus.Net Knowledge Base
The Plesk Control Panel has the ability to create
multiple MySQL and PostgreSQL databases as well as multiple users
within each database. Also,
directly accessible via Plesk, are the links to phpMyAdmin and
PhpPGAdmin, the PHP interface
applications that abstract mysql or postgresql into a web-based
administration tool, allowing you to sort, edit, and
create tables within a given database.
Before
creating your databases within the Plesk Control Panel, please ensure
that you have already added a hosted domain name to your dedicated
server:
Here is how you can create MySQL (or PostgreSQL) databases using Plesk:
- Login
to your Plesk Control Panel. Use the login details
sent to you in the "Welcome" email when the server was initially setup.
- Click
on Domains from
the navigation bar on the left.
-
Select the domain name that you'd like to associate your
database with.
-
Click the Databases
icon.
-
Click the Add
New Database icon.
-
Enter a name in the Database
name field.
-
Select the Database
Type using the respective drop-down menu.
-
Select the Database
Server using the respective drop-down menu.
-
Click OK.
-
Click the Add
New Database User icon in order to setup database
administrator's credentials.
-
Enter a username
and a password
which will be used for accessing the contents of the
database.
-
Click OK.
-
Now, you can use the DBWebAdmin
tool to access the phpMyAdmin tool where you can
create, edit and sort tables within your database.