Category » Database

There were 5 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 ...
4. What is the username and password to access MySQL on my Unix dedicated server?
   The username for root access to MySQL is “admin”. The password will be the same as your 'admin' password for the Plesk Control Panel login. Note: MySQL is configured to only allow access from localhost. This means you can only access the server from a MySQL management interface su ...
5. How do I back up MSSQL databases?
   Important Notes: This procedure will have to be done from Remote Desktop Protocol. If you do not know how to connect using RDP. Getting Started: To back up the database you are going to use the mysqldump command: Open Microsoft SQL Server Management Studio and select Databases Then Right-C ...