Difference between revisions of "Managing MySQL"

From XMission Wiki
Jump to: navigation, search
(Plesk Shared Hosting: Managing MySQL)
 
(16 intermediate revisions by 4 users not shown)
Line 1: Line 1:
== Plesk Unlimited Hosting: Managing MySQL ==
+
= Plesk Shared Hosting: Managing MySQL =
  
XMission's Unlimited Hosting powered by Plesk has phpmyadmin essentially built right into it!
+
XMission's Shared Hosting powered by Plesk has phpMyAdmin for it’s web based management interface. 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.
  
 
*From the Control Panel, click on the "Domains & Websites" tab near the top of the screen.
 
*From the Control Panel, click on the "Domains & Websites" tab near the top of the screen.
[[File:Plesk_tabs_new.png]]
+
[[File:PleskSidebar.png]]
  
 +
*On the next screen, you will see any existing databases listed near the bottom of the screen. If no databases are listed simply click "'''Add Database'''".
 +
[[File:PleskMySQL-1.png|600px]]
  
*Near the bottom of the screen, click the button labeled "Databases."
 
[[File:Mysql1.png]]
 
  
 +
* You can fill on the required fields to create your database.
 +
[[File:PleskMySQL-2.png|600px]]
  
*On the next screen, you will see any existing databases listed near the bottom of the screen. To manage/modify one, simply click the database name. In this case, the example database would be ''example_user_example_database''.
+
* '''Database name''' - the name of your database
[[File:Mysql2.png]]
+
* '''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. If the ''webadmin'' button' is grayed out, you will need to create a new user using the corresponding button and then click the button labeled "Make Default for DB Webadmin" to give the user account you created access to the database. Once the ''webadmin'' button is available, simply click on it.  
+
'''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.
[[File:Managing_mysql1.png]]
 
  
  
To manage your existing databases, please read [[Managing MySQL]].
+
*Now, you should see the screen below. You can then click on '''phpMyAdmin''' to manage your MySQL through phpMyAdmin.
 +
[[File:PleskMySQL-3.png|600px]]
  
  
Continue onto....
+
[[File:Phpymyadmin.png|600px]]
*[[Administration/Logging in]]
+
 
*[[Previewing the Website]]
+
 
*[[Managing Domain/Users]]
+
{{:Shared_Hosting}}
*[[Creating/Managing User Roles]]
+
[[Category:Shared Hosting|Managing MySQL]]
*[[Managing FTP Access/Users]]
 
**[[About FTP and Unlimited Hosting]]
 
**[[Managing MySQL]]
 
*[[Adding/Managing DNS Records]]
 

Latest revision as of 00:23, 8 December 2022

Plesk Shared Hosting: Managing MySQL

XMission's Shared Hosting powered by Plesk has phpMyAdmin for it’s web based management interface. 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.

  • From the Control Panel, click on the "Domains & Websites" tab near the top of the screen.

PleskSidebar.png

  • On the next screen, you will see any existing databases listed near the bottom of the screen. If no databases are listed simply click "Add Database".

PleskMySQL-1.png


  • You can fill on the required fields to create 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.


  • Now, you should see the screen below. You can then click on phpMyAdmin to manage your MySQL through phpMyAdmin.

PleskMySQL-3.png


Phpymyadmin.png


Additional Development Help

Applications

Domain Management