Difference between revisions of "Managing MySQL"

From XMission Wiki
Jump to: navigation, search
(Plesk Shared Hosting: Managing MySQL)
 
(15 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 "Add New Database User" button.  
+
'''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]]
 
  
  
 +
*Now, you should see the screen below. You can then click on '''phpMyAdmin''' to manage your MySQL through phpMyAdmin.
 +
[[File:PleskMySQL-3.png|600px]]
  
If you had to create a new user, you will see the following screen. Simply provide a unique username and password -- please choose a strong password -- for the user.
 
[[File:Managing_mysql2.png]]
 
  
 +
[[File:Phpymyadmin.png|600px]]
  
Once the ''webadmin'' button is no longer grayed out, click on it to access phpmyadmin.
 
  
Continue onto....
+
{{:Shared_Hosting}}
*[[Administration/Logging in]]
+
[[Category:Shared Hosting|Managing MySQL]]
*[[Previewing the Website]]
 
*[[Managing Domain/Users]]
 
*[[Creating/Managing User Roles]]
 
*[[Managing FTP Access/Users]]
 
**[[About FTP and Unlimited Hosting]]
 
*[[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