Create MySQL/MS-SQL databases in Windows Hosting?

Create MySQL/MS-SQL databases in Windows Hosting server involves different steps depending on the hosting provider and the control panel they offer.

Here’s a general guide:

MySQL Database Creation:

1. Log in to your Hosting Control Panel: Access your hosting provider’s control panel. Popular control panels include Plesk, cPanel, and DirectAdmin.
2. Locate the MySQL Database Section: In your control panel, find the section related to databases. It’s usually labeled something like “Databases” or “Database Management.”
3. Create a New Database: Within the database section, there should be an option to create a new database. Click on it.
4. Enter Database Details: You’ll typically need to provide a name for your database. Optionally, you might be able to set a username and password for database access. Note down these details as you’ll need them later.
5. Submit the Form: After entering the required details, submit the form to create the database.

6. 

   

   Configure Access: If you’ve set up a separate username and password for the database, you might need to configure access privileges. Usually, there’s an option to assign privileges to users within the database section of the control panel.

MS-SQL Database Creation:

1. Access the Hosting Control Panel: Log in to your hosting control panel.
2. Find the MS-SQL Server Section: Look for the section related to MS-SQL Server or SQL Databases. It might be labeled differently depending on the hosting provider.
3. Create a New Database: Within the MS-SQL Server section, there should be an option to create a new database. Click on it.
4. Enter Database Details: Provide a name for your database. Optionally, you might be able to set additional parameters such as database size, collation, etc.
5. Submit the Form: After entering the details, submit the form to create the database.
6. Configure Access: Similar to MySQL, if you’ve set up a separate username and password for the database, you might need to configure access privileges. Look for options related to user management within the MS-SQL Server section.
7. Connect to the Database: Once the database is created, you can connect to it using your preferred database management tool (like MySQL Workbench for MySQL or SQL Server Management Studio for MS-SQL). Use the database credentials you set up earlier to establish the connection.

Additional Tips:

• Always remember to keep your database credentials secure.
• It’s a good practice to regularly back up your databases to prevent data loss.
• If you’re unsure about any step, don’t hesitate to consult your hosting provider’s documentation or contact their support team for assistance.
  

  Create MySQL/MS-SQL databases in Windows Hosting

  

  

  In Plesk, you can create MySQL or MSSQL databases on your hosting account for your websites to use.

  1. Sign in to your product page.
  2. Select Web Hosting. Then, next to the hosting account you want to use, select Manage.
  3. Select Plesk Admin.
  4. On the left-side menu, select Databases.
  5. Select Add New Database.
  6. Enter a Database name, select a server from the Database server dropdown list, and then select a site from the Related site dropdown list.
  7. Enter a Database user name, and then enter a password in the Password and Confirm password text fields.
  8. (Optional) Select the checkbox to give your database user access to all databases within the selected subscription.
  9. Select OK.

  

  A success message will confirm your database and database user have been created. If you need to create additional users, select User Management, and then select Add New Database User.

   Note: Each database user can access only one database type. But you can create users with the same name for each database type.