Difference between revisions of "Adding MySQL Databases"

From XMission Wiki
Jump to: navigation, search
(Plesk Shared Hosting: Adding MySQL Databases)
(Plesk Shared Hosting: Adding MySQL Databases)
 
(4 intermediate revisions by 2 users not shown)
Line 1: Line 1:
== Plesk Shared Hosting: Adding MySQL Databases ==
+
= Plesk Shared Hosting: Adding MySQL Databases =
  
Create and remove databases used by your websites, and manage them using integrated administrative web application.  
+
This management interface will allow you to not only create and remove databases, but also manage them with the integrated PHPMyAdmin web interface.
  
*From the Control Panel, click on the "Domains & Websites" tab near the top of the screen.
+
*From the Side Panel, click on the "Databases".
[[File:Plesk_tabs_new.png]]
+
[[File:PleskSidebar.png]]
  
  
*Ob the left, click the button labeled "Databases."  
+
*On the next screen, you will see the option to "Add New Database" and, if you already have existing databases, you will see them listed near the bottom. To add a new database, simply click the button labeled "Add New Database."  
[[File:Mysql1.png]]
+
[[File:PleskMySQL-1.png|600px]]
  
  
*On the next screen, you will see the option to "Add New Database" and, if you already have existing databases, you will see them listed near the bottom. To add a new database, simply click the button labeled "Add New Database."
+
*Now, you should see the screen below. The '''only''' field you can make changes to -- and it is necessary to do so -- is a unique name for your database.  
[[File:Mysql2.png]]
+
[[File:PleskMySQL-2.png|600px]]
  
 +
* '''Database name''' - the name of your database
 +
* '''Database server''' - you can choose MariaDB or PostgresSql if available
 +
* '''Related site''' - the domain which you want to associate the database with
 +
* '''Database use name''' - the username you want to use for your database
 +
* '''Password''' - the password for your database
 +
* '''Confirm password''' - retype your password
 +
* '''User has access to all databases''' - if you want this user to have access to all databases on your account you can check this box.
  
*Now, you should see the screen below. The '''only''' field you can make changes to -- and it is necessary to do so -- is a unique name for your database.
 
[[File:Mysql3.png]]
 
  
 +
'''Note''': We do not allow remote access to databases on shared hosting. If your development requires remote database access it can be manually reviewed after speaking with support.
  
 
To manage your existing databases, please read [[Managing MySQL]].
 
To manage your existing databases, please read [[Managing MySQL]].

Latest revision as of 23:11, 7 December 2022

Plesk Shared Hosting: Adding MySQL Databases

This management interface will allow you to not only create and remove databases, but also manage them with the integrated PHPMyAdmin web interface.

  • From the Side Panel, click on the "Databases".

PleskSidebar.png


  • On the next screen, you will see the option to "Add New Database" and, if you already have existing databases, you will see them listed near the bottom. To add a new database, simply click the button labeled "Add New Database."

PleskMySQL-1.png


  • Now, you should see the screen below. The only field you can make changes to -- and it is necessary to do so -- is a unique name for your database.

PleskMySQL-2.png

  • Database name - the name of your database
  • Database server - you can choose MariaDB or PostgresSql if available
  • Related site - the domain which you want to associate the database with
  • Database use name - the username you want to use for your database
  • Password - the password for your database
  • Confirm password - retype your password
  • User has access to all databases - if you want this user to have access to all databases on your account you can check this box.


Note: We do not allow remote access to databases on shared hosting. If your development requires remote database access it can be manually reviewed after speaking with support.

To manage your existing databases, please read Managing MySQL.


Additional Development Help

Applications

Domain Management