Knowledge Base
Home 
 
/
 Powered by Network Solutions: Working with MySQL databases
Categories: Legacy Domain

Powered by Network Solutions: Working with MySQL databases

This comprehensive guide is your one-stop shop for MySQL database management.

Access the MySQL Management page

  1. Log in to your account via https://www.networksolutions.com/my-account/login.
  2. Click Websites & Hosting from the left navigation menu.

    Email option in the Account Manager navigation menu
     
  3. Navigate to the hosting package that you want to access with Website Builder, then click Manage to continue.

    Manage Website
     
  4. In the left pane, click on MySQL Management.

    MySQL Management
     
  5. On the MySQL Management page, you will find all the databases on your hosting server. Click the Manage button to go to the management page of the specific database.

    Database - Manage button

 

Create a new MySQL database

  1. On the MySQL Management page, click + Add MySQL database.

    MySQL Management - Add MySQL Database
     
  2. Enter a name for your database, then click Next.

    MySQL Management - Enter database name

    Database naming pro tips
     
    • Use lowercase - this will help avoid mistakes due to case sensitivity.
    • No spaces - use underscore instead.
    • No numbers - use only alpha English characters.
    • Use valid, understandable names like blog, WordPress, e-commerce, and store. The name should be self-explanatory.
    • Database name should not be more than 64 characters.
    • Avoid using prefix.
       
  3. Type your database username and password, then click on Save.

    MySQL Management - Enter username and password
     
  4. In the next pop-up, set the database privileges.

    MySQL Management - Set privileges

 

Delete a MySQL database

  1. Go to the MySQL Management page.
  2. Locate the database you want to delete, then click the trash bin icon on the right.

    MySQL Management - Delete MySQL Database

 

Connect to a MySQL database

  1. On the Database Management page, look for your database user and click its ellipsis icon on the right.

    Database user
     
  2. Select Generate Code from the list of options.

    Generate code
     
  3. Select the Programming Language (Perl, PHP, or Python) from the drop-down menu.

    Select programming language
     
  4. The connection string and codes necessary to connect to your database are generated depending on the selected programming language. Click on Copy Code Snippet and close the pop-up window.
  5. Use the code in your site where you want to make the connection to the database.

 

Can't schedule a MySQL database backup

Problem: When you go to the MySQL Beta > Manage Backups tab and click a database name to schedule it for backup, nothing happens.

Why is this happening: The server is trying to post an error, and it's not being displayed. The error says: Server is busy. Please try again later.

Solution: Please try to schedule your database backup later.

 

Manage MySQL database via phpMyAdmin

Within phpMyAdmin, you can also take the following actions to manage your database.

 

Get practical tips and product updates on LinkedIn.
Follow Network Solutions

Back to top