phpMyAdmin

From DreamHost
Jump to: navigation, search

To use phpMyAdmin to access one of your MySQL databases simply go to that database's hostname on the web. For example, if your MySQL hostname was mysql.example.com, point your browser to http://mysql.example.com. You will then be prompted for a username and password. Every domain hosted at Dreamhost has phpMyAdmin configured to use HTTP authentication against the database server. The user and password you enter should be a MySQL user / password that has access to the database you want to manage. Note that unless your site uses HTTPS (Secure HTTP), your username, password, and all data viewed through phpMyAdmin will be unencrypted and therefore viewable by others on the same network if they are using the right tools.


Security

HTTPS

For access via Secure HTTP, your domain must have secure hosting on it.

You may set up your domain to have secure hosting by going to the panel and to "domains->manage domains" and click "edit" under "secure hosting" to add secure hosting to your domain. No matter what, if you add secure hosting, you are going to need to pay the ongoing yearly rate to enable the unique IP; however, if you choose to "use your own certificate" (and don't purchase one from elsewhere), the system will setup a self-signed certificate for you. Though this isn't very secure for ecommerce and whatnot, it will probably be good enough for secure mysql management.

If you haven't subscribed to the secure hosting option, you may still access your database in a secure fashion by connecting via your shell account.

Accessing phpMyAdmin with SSL-encrypted Domain

If your domain already has an SSL certificate assigned to it, you can then access phpMyAdmin through the full URL as in this example, replacing 'yourdomain.com' with your actual SSL-encrypted domain and an active MySQL hostname in your DreamHost panel:

https://www.yourdomain.com/dh_phpmyadmin/mysql.yourdomain.com/

This should show you the SSL warning screen and then allow you to accept the certificate and log as your database user.


HTTP

phpMyAdmin can be used to securely interact with your database if you install it locally and connect to your database though an SSH tunnel and forwarding a port, such as 3307, to your database on port 3306 (such as mysql.mydomain.com:3306). On Windows, this tunnel can be with PuTTY. On Linux, you can simply add port forwarding as an argument to the SSH command. After creating the tunnel, you simply point phpMyAdmin to 127.0.0.1:3307 and enjoy your secure connection to your data.

Copying MySQL data

The following steps outline how to copy a table from one MySQL database to another:

Exporting the data

  1. Login to phpMyAdmin.
  2. Select the source database.
  3. Open the table you wish to export.
  4. Export the table as a file with a .sql extension.

Importing the data

  1. Select the destination database.
  2. Click the Import tab.
  3. Click Browse and locate the file with the .sql extension you saved earlier.
  4. Click OK and then Go.

The newly-imported table will appear in the list of tables.

If you need your database username password, please log into your web panel and go to this page: https://panel.dreamhost.com/index.cgi?tree=goodies.mysql& Once you're on that page, click on whichever username you wish to view the password for.

Note on Dropping (Deleting) a Database

You cannot Drop a database on DreamHost using phpMyAdmin; you can "delete" a database using the Control Panel -> Goodies -> Manage MySQL screen. Even if you do this, a database created on DreamHost is never fully dropped by using the Control Panel -> Goodies -> Manage MySQL screen. If you login to the host with the appropriate credentials, via phpMyAdmin or the shell command line, you'll still find your database. Dreamhost does not completely delete the database as the result of a Control Panel action. Be careful!

If you no longer want a database you have set up on DreamHost, and you have any sensitive data in the database that you want to obliterate, you might consider dropping all the tables from the database so that the data can not be viewed in this manner.

phpMyAdmin Version Warning

When accessing phpMyAdmin, you can safely ignore the following (or similar) warning: "Your PHP MySQL library version 5.0.51a differs from your MySQL server version 5.1.39. This may cause unpredictable behavior."

VPS Admin

phpMyAdmin is installed at /dh/web/phpmyadmin. Themes can be added at /dh/web/phpmyadmin/themes.

See also

External link