When you purchase a Managed Database Hosting package from Provider.lk, your database is created for you and ready to use. This article explains how to locate your login details, access phpMyAdmin, and understand key connection parameters like host and port.
1. Where to Find Your Login Details
After your order is completed, you will receive an email with the subject 'Managed Database Hosting Account Information' containing your database name, username, password and all the details required to setup.
2. Accessing phpMyAdmin
phpMyAdmin is a web-based tool that makes it easy to manage your MySQL database without needing to run command-line queries.
Steps to log in:
- Go to the Control Panel URL provided in your email.
- Enter your database username and password.
- Once logged in, you can:
- Create or edit tables.
- Run SQL queries.
- Import/export .sql backups.
Tip: Always log out of phpMyAdmin after you are done, especially on shared or public computers.
3. Database Host and Port Explained
When connecting your website or application to your hosted database, you will need to use the correct host and port:
- Database Host: This is the server address where your database resides. It will be listed in your welcome email. For example:
- db.provider.lk (example only, check your email for the actual host). - Port: By default, MySQL uses port 3306. Unless your email specifies otherwise, use this port.
4. Security Recommendations
- Do not share your main database credentials with third parties.
- If you need separate access for developers or applications, request an additional database user with limited privileges by submitting a technical support ticket.
5. Troubleshooting Login Issues
- “Access denied for user” → Double-check your username and password.
- Can’t connect remotely → Ensure you are using the correct database host and port.
By following these steps, you can connect, manage, and secure your hosted database with Provider.lk. If you need further help, our technical support team is available 24/7 to assist you.
