Category » Database

There were 3 articles found in this category:

1. How do I manage databases in the Plesk control panel?
   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 ...
2. How can I configure remote access for mysql?
   Important Notes: This guide will help you configure your server to allow remote connections to your mySQL database. This guide is intended for server with the Plesk Control Panel installed. If you are with Managed Hosting, please login to https://serverportal.com/ and submit an A la Carte' w ...
3. Do you have some database performance tuning suggestions?
   The following are some database performance tuning strategies: Check that all columns where searches or sorts take place are indexed unless tables are very small or have high levels of updates. One place where indexes are overlooked (and very necessary) is on the parent column of a foreign key ...