Is there a Database Control Panel in Plesk ?

“Plesk Power Pack” is the add-on that allows you to manage various databases. MSSql Databases, MySQL Databases, PostgreSQL Databases are supported and manageable through Plesk Power Pack.

Below is an example:

yourusername_dbname

Connection connection = null;
Class.forName(”org.gjt.mm.MySQL.Driver”).newInstance();
connection = DriverManager.getConnection(”jdbc: MySQL://localhost/yourusername_dbname?user=&password=”);

Host : localhost

[or add the IP address of your account to the list of authorized hosts in your phpMyadmin area and replace your IP with the Host]
Username : cPanelusername_MySQLusername [example: Sam_forum]
Password : MySQL password

Our servers support MySQL databases, not MS Access. But there is a program that can convert Access Databases to MySQL, or can even make an ODBC connection between MySQL and MS Access which is called ‘MyODBC’.

Please check http://www.MySQL.com/downloads/api-myodbc.html for info, downloads and documentation for help on installation.

We recommend PHP 5 and MySQL 5, as they are the most trusted ones.

However, you are the owner of VPS server, so you can decide it for you. If you want other versions, just lets us know so that we can setup the desired one for you.

On the server that currently hosts the MySQL database, you can back it up through cPanel (If the server is cPanel based), and upload it through our cPanel to your account with Micfo.com.

Otherwise here’s how to upload your current database to your new Micfo account:

1. FTP your database.sql file to your new Micfo account.
2. Login to cPanel and create a database.
3. Create a new user and add him to the database you just created in Step #2
4. Login via SSH, and run: MySQL -u DB_username -p DB_password Database_name < database.sql

Alternatively, we can do all of this for you if you tell us your old host’s details, so we can login and move the database from there and install it on your new Micfo account. To do this, please send all the relevant info, including old hosts IP, username, password, database name and database username/password via help desk.

Here is a quick description of commands, which are needed in your PHP pages to connect to MySQL.

Note: If you need to connect remotely from another machine, you must let us know the IP# you will be connecting from so we can enable this for your database.

1. Connect to the MySQL Server
Use the following statement to connect to the database server.
Substitute the username and password for your MySQL username and password. MYSQL_CONNECT(’localhost’,'USERNAME’,'PASSWORD’);

2. Select Your Database
Use the following statement to select the database you wish to connect to.
Make sure you substitute your database name for the example.
@MySQL_select_db(’DATABASENAME’);

3. Executing A Query
You are now ready to execute your queries.

[Most problems that arise with your scripts will be due to incorrect permission settings.]

The host for MySQL database is ‘localhost’.

You can use PhpMyAdmin to dump the contexts of a database to an *.sql file.

You can also use PhpMyAdmin to restore a database from an *.sql file.

You can create new databases in the SQL feature of the cPanel located at http://yourdomain.com/cPanel.
First, you must create the actual database. For that you need to enter a name for the database, such as ‘users’. The database will be created as your-username_users.

Once done, you will need to create a username and password in the MySQL system. A username could be ‘access’. When created it will become your-username_access. Once done, you need to add the user into the database. This is the final step of creating a MySQL database.