CanerAkar Your FPS.ms web hosting service includes MySQL databases for your websites and applications. You can create, manage, and delete databases from the panel.
Creating a new database
- Go to the Databases section of your web hosting server
- Click Create Database
- Fill in the following fields:
- Database name -- alphanumeric characters only (your username is automatically prefixed)
- Database user -- the username to connect with
- Database password -- minimum 8 characters
- Click Create
yourusername_dbname and the user will be yourusername_dbuser.
Connection details
Use these details to connect your website or application to the database:- Host:
localhost(when connecting from your web hosting server) - Port:
3306 - Database:
yourusername_dbname - Username:
yourusername_dbuser - Password: the password you set during creation
PHP Connection
In your PHP code, you can connect using:
class="hljs-variable">$conn = new mysqli('localhost', 'yourusername_dbuser', 'your_password', 'yourusername_dbname');Accessing phpMyAdmin
If phpMyAdmin is available on your hosting server, you can access it from the Databases section to visually browse and manage your database tables, run SQL queries, and import or export data.Deleting a database
- Go to the Databases section
- Find the database you want to remove
- Click Delete and confirm
Permanent Action
Deleting a database permanently removes all data. Make sure to create a backup before deleting a database you may still need.