{"id":344,"date":"2024-07-31T14:09:39","date_gmt":"2024-07-31T14:09:39","guid":{"rendered":"https:\/\/mediadrive.ca\/docs\/?p=344"},"modified":"2024-07-31T14:09:39","modified_gmt":"2024-07-31T14:09:39","slug":"creating-a-sql-database","status":"publish","type":"post","link":"https:\/\/mediadrive.ca\/docs\/creating-a-sql-database\/","title":{"rendered":"Creating a SQL database"},"content":{"rendered":"\n<p>Log in to the control panel.<\/p>\n\n\n\n<p>Under <code>Account Manager<\/code>, choose <code>Databases<\/code>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"842\" height=\"518\" src=\"https:\/\/mediadrive.ca\/docs\/wp-content\/uploads\/2024\/07\/image.png\" alt=\"\" class=\"wp-image-345\" srcset=\"https:\/\/mediadrive.ca\/docs\/wp-content\/uploads\/2024\/07\/image.png 842w, https:\/\/mediadrive.ca\/docs\/wp-content\/uploads\/2024\/07\/image-300x185.png 300w, https:\/\/mediadrive.ca\/docs\/wp-content\/uploads\/2024\/07\/image-768x472.png 768w\" sizes=\"auto, (max-width: 842px) 100vw, 842px\" \/><\/figure>\n\n\n\n<p>Below your list of databases, you will find <code>Create Database<\/code>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"196\" src=\"https:\/\/mediadrive.ca\/docs\/wp-content\/uploads\/2024\/07\/image-1-1024x196.png\" alt=\"\" class=\"wp-image-346\" srcset=\"https:\/\/mediadrive.ca\/docs\/wp-content\/uploads\/2024\/07\/image-1-1024x196.png 1024w, https:\/\/mediadrive.ca\/docs\/wp-content\/uploads\/2024\/07\/image-1-300x57.png 300w, https:\/\/mediadrive.ca\/docs\/wp-content\/uploads\/2024\/07\/image-1-768x147.png 768w, https:\/\/mediadrive.ca\/docs\/wp-content\/uploads\/2024\/07\/image-1-1536x294.png 1536w, https:\/\/mediadrive.ca\/docs\/wp-content\/uploads\/2024\/07\/image-1-2048x392.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>The system will automatically generate a username and secure password for this database. Provide a name for your database and then press the <code>Create<\/code> button.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"200\" src=\"https:\/\/mediadrive.ca\/docs\/wp-content\/uploads\/2024\/07\/image-2-1024x200.png\" alt=\"\" class=\"wp-image-347\" srcset=\"https:\/\/mediadrive.ca\/docs\/wp-content\/uploads\/2024\/07\/image-2-1024x200.png 1024w, https:\/\/mediadrive.ca\/docs\/wp-content\/uploads\/2024\/07\/image-2-300x58.png 300w, https:\/\/mediadrive.ca\/docs\/wp-content\/uploads\/2024\/07\/image-2-768x150.png 768w, https:\/\/mediadrive.ca\/docs\/wp-content\/uploads\/2024\/07\/image-2-1536x299.png 1536w, https:\/\/mediadrive.ca\/docs\/wp-content\/uploads\/2024\/07\/image-2-2048x399.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Once the database is created, the details for that database will appear below the <code>Create<\/code> button. You can take the username, password, and database values that were presented and provide them to your CMS installer, web developer, etc.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Log in to the control panel. Under Account Manager, choose Databases. Below your list of databases, you will find Create Database. The system will automatically generate a username and secure password for this database. Provide a name for your database and then press the Create button. Once the database is created, the details for that [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-344","post","type-post","status-publish","format-standard","hentry","category-managing-your-site"],"_links":{"self":[{"href":"https:\/\/mediadrive.ca\/docs\/wp-json\/wp\/v2\/posts\/344","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mediadrive.ca\/docs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mediadrive.ca\/docs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mediadrive.ca\/docs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mediadrive.ca\/docs\/wp-json\/wp\/v2\/comments?post=344"}],"version-history":[{"count":2,"href":"https:\/\/mediadrive.ca\/docs\/wp-json\/wp\/v2\/posts\/344\/revisions"}],"predecessor-version":[{"id":349,"href":"https:\/\/mediadrive.ca\/docs\/wp-json\/wp\/v2\/posts\/344\/revisions\/349"}],"wp:attachment":[{"href":"https:\/\/mediadrive.ca\/docs\/wp-json\/wp\/v2\/media?parent=344"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mediadrive.ca\/docs\/wp-json\/wp\/v2\/categories?post=344"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mediadrive.ca\/docs\/wp-json\/wp\/v2\/tags?post=344"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}