Difference between revisions of "Managing MySQL"
From XMission Wiki
(→Plesk Shared Hosting: Managing MySQL) |
|||
(13 intermediate revisions by 4 users not shown) | |||
Line 1: | Line 1: | ||
− | + | = Plesk Shared Hosting: Managing MySQL = | |
− | XMission's | + | 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: | + | [[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]] | ||
− | |||
− | |||
+ | * You can fill on the required fields to create your database. | ||
+ | [[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. | ||
− | + | '''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. | ||
+ | [[File:PleskMySQL-3.png|600px]] | ||
− | |||
− | |||
+ | [[File:Phpymyadmin.png|600px]] | ||
− | |||
− | |||
− | + | {{:Shared_Hosting}} | |
− | + | [[Category:Shared Hosting|Managing MySQL]] | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− |
Latest revision as of 00:23, 8 December 2022
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.
- 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".
- You can fill on the required fields to create your database.
- 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.
- Administration/Logging in
- Adding a Domain
- Adding MySQL Databases
- Managing MySQL
- Adding/Managing DNS Records
- Managing Domain/Users
- Managing FTP Access/Users
- PHP Settings
- Previewing the Website
- Secure Your Sites
- Web Statistics
Additional Development Help
Applications
Domain Management