{"id":164,"date":"2009-04-04T09:19:49","date_gmt":"2009-04-04T08:19:49","guid":{"rendered":"http:\/\/www.withinweb.com\/info\/?p=164"},"modified":"2009-04-04T09:37:04","modified_gmt":"2009-04-04T08:37:04","slug":"creating-a-mysql-database-in-cpanel-new-style","status":"publish","type":"post","link":"https:\/\/www.withinweb.com\/info\/creating-a-mysql-database-in-cpanel-new-style\/","title":{"rendered":"Creating a mySQL Database in cPanel (new style)"},"content":{"rendered":"

Log in to your Cpanel<\/strong><\/p>\n

Log into cPanel and click on the mySQL database link.<\/p>\n

\"\"<\/p>\n

Create A New Database<\/strong><\/p>\n

Scroll down to where it says ‘new database’ and enter your choosen database name in the field and click on ‘Create Database’<\/p>\n

\"\"<\/p>\n

MySql Account Maintenance Page\u00a0<\/strong><\/p>\n

Each step in the process will take you back and forth to the mySQL Maintenace page to verify that you have set up the process correctly and you will be able to see the information you have created.<\/p>\n

Here you will see you have added the database.<\/p>\n

Click on the Go Back button.<\/p>\n

\"\"<\/p>\n

Enter Username and Password<\/h3>\n

Scroll down to username and password and enter your information.\u00a0 Click on create user.<\/p>\n

\"\"<\/p>\n

Back to MySql Account Maintenance Page\u00a0<\/strong><\/p>\n

The username and password have been created for you database.\u00a0 Click on the Go Back button to return.<\/p>\n

\"\"<\/p>\n

Add username to database<\/strong><\/p>\n

Scroll down to add users to your databases.<\/p>\n

If there are no users or databases previously created you will only see one in each selection.<\/p>\n

Choose the username that you want to add.\u00a0 Note that the username previously created “myusername” has been shortened to “myusern”\u00a0 This is the name that you need to use in the config.php file.\u00a0<\/p>\n

Example: “vonnamia_myusern” not “vonnamia_myusername”<\/p>\n

Select the Database you created from the list.<\/p>\n

Select the Checkbox “All Privileges”.<\/p>\n

Click Add User To Database<\/p>\n

\"\"<\/p>\n

MySql Account Maintenance\u00a0<\/strong><\/p>\n

This will take you back to the MySql Account Maintenance page for verification, you will see the shortened Username there.<\/p>\n

Click on the\u00a0Go Back button and you will see the contents of your finished Database.<\/p>\n

\"\"<\/p>\n

Running the install.php file<\/strong><\/p>\n

At this point you have created the database, created a user and allocated the user to the database.<\/p>\n

You can now create the tables using the install.php script supplied with the zip file.<\/p>\n

You will need to have the following information available :<\/p>\n

database name
\ndatabase username
\ndatabase password
\ndatabase host (usually local host but refer to your host documentation if you are not sure)<\/p>\n

When you run the install.php file in your browser you will be presented with boxes as follows :<\/p>\n

\"\"<\/p>\n","protected":false},"excerpt":{"rendered":"

Log in to your Cpanel Log into cPanel and click on the mySQL database link. Create A New Database Scroll down to where it says ‘new database’ and enter your choosen database name in the field and click on ‘Create…<\/span><\/p>\n

Read more Creating a mySQL Database in cPanel (new style)<\/span> ›<\/span><\/a><\/div>\n

<\/p>\n","protected":false},"author":40,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,5,4,10],"tags":[],"class_list":["post-164","post","type-post","status-publish","format-standard","hentry","category-php-eseller","category-php-keycodes","category-php-securearea","category-sql_databases_and_queries"],"yoast_head":"\nCreating a mySQL Database in cPanel (new style) - PHP Web Applications<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.withinweb.com\/info\/creating-a-mysql-database-in-cpanel-new-style\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Creating a mySQL Database in cPanel (new style) - PHP Web Applications\" \/>\n<meta property=\"og:description\" content=\"Log in to your Cpanel Log into cPanel and click on the mySQL database link. Create A New Database Scroll down to where it says ‘new database’ and enter your choosen database name in the field and click on ‘Create…Read more Creating a mySQL Database in cPanel (new style) ›\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.withinweb.com\/info\/creating-a-mysql-database-in-cpanel-new-style\/\" \/>\n<meta property=\"og:site_name\" content=\"PHP Web Applications\" \/>\n<meta property=\"article:published_time\" content=\"2009-04-04T08:19:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2009-04-04T08:37:04+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.withinweb.com\/graphics\/wordpress\/cpanel1_new_style.gif\" \/>\n<meta name=\"author\" content=\"paulv\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"paulv\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.withinweb.com\\\/info\\\/creating-a-mysql-database-in-cpanel-new-style\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.withinweb.com\\\/info\\\/creating-a-mysql-database-in-cpanel-new-style\\\/\"},\"author\":{\"name\":\"paulv\",\"@id\":\"https:\\\/\\\/www.withinweb.com\\\/info\\\/#\\\/schema\\\/person\\\/04da5531c302d55ffcd777fe81dbb93c\"},\"headline\":\"Creating a mySQL Database in cPanel (new style)\",\"datePublished\":\"2009-04-04T08:19:49+00:00\",\"dateModified\":\"2009-04-04T08:37:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.withinweb.com\\\/info\\\/creating-a-mysql-database-in-cpanel-new-style\\\/\"},\"wordCount\":362,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.withinweb.com\\\/info\\\/creating-a-mysql-database-in-cpanel-new-style\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/www.withinweb.com\\\/graphics\\\/wordpress\\\/cpanel1_new_style.gif\",\"articleSection\":[\"PHP-eSeller\",\"PHP-KeyCodes\",\"PHP-SecureArea\",\"SQL databases\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.withinweb.com\\\/info\\\/creating-a-mysql-database-in-cpanel-new-style\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.withinweb.com\\\/info\\\/creating-a-mysql-database-in-cpanel-new-style\\\/\",\"url\":\"https:\\\/\\\/www.withinweb.com\\\/info\\\/creating-a-mysql-database-in-cpanel-new-style\\\/\",\"name\":\"Creating a mySQL Database in cPanel (new style) - PHP Web Applications\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.withinweb.com\\\/info\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.withinweb.com\\\/info\\\/creating-a-mysql-database-in-cpanel-new-style\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.withinweb.com\\\/info\\\/creating-a-mysql-database-in-cpanel-new-style\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/www.withinweb.com\\\/graphics\\\/wordpress\\\/cpanel1_new_style.gif\",\"datePublished\":\"2009-04-04T08:19:49+00:00\",\"dateModified\":\"2009-04-04T08:37:04+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.withinweb.com\\\/info\\\/#\\\/schema\\\/person\\\/04da5531c302d55ffcd777fe81dbb93c\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.withinweb.com\\\/info\\\/creating-a-mysql-database-in-cpanel-new-style\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.withinweb.com\\\/info\\\/creating-a-mysql-database-in-cpanel-new-style\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.withinweb.com\\\/info\\\/creating-a-mysql-database-in-cpanel-new-style\\\/#primaryimage\",\"url\":\"http:\\\/\\\/www.withinweb.com\\\/graphics\\\/wordpress\\\/cpanel1_new_style.gif\",\"contentUrl\":\"http:\\\/\\\/www.withinweb.com\\\/graphics\\\/wordpress\\\/cpanel1_new_style.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.withinweb.com\\\/info\\\/creating-a-mysql-database-in-cpanel-new-style\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.withinweb.com\\\/info\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Creating a mySQL Database in cPanel (new style)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.withinweb.com\\\/info\\\/#website\",\"url\":\"https:\\\/\\\/www.withinweb.com\\\/info\\\/\",\"name\":\"PHP Web Applications\",\"description\":\"Information and support for products of WithinWeb.com\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.withinweb.com\\\/info\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.withinweb.com\\\/info\\\/#\\\/schema\\\/person\\\/04da5531c302d55ffcd777fe81dbb93c\",\"name\":\"paulv\",\"url\":\"https:\\\/\\\/www.withinweb.com\\\/info\\\/author\\\/paulv\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Creating a mySQL Database in cPanel (new style) - PHP Web Applications","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.withinweb.com\/info\/creating-a-mysql-database-in-cpanel-new-style\/","og_locale":"en_US","og_type":"article","og_title":"Creating a mySQL Database in cPanel (new style) - PHP Web Applications","og_description":"Log in to your Cpanel Log into cPanel and click on the mySQL database link. Create A New Database Scroll down to where it says ‘new database’ and enter your choosen database name in the field and click on ‘Create…Read more Creating a mySQL Database in cPanel (new style) ›","og_url":"https:\/\/www.withinweb.com\/info\/creating-a-mysql-database-in-cpanel-new-style\/","og_site_name":"PHP Web Applications","article_published_time":"2009-04-04T08:19:49+00:00","article_modified_time":"2009-04-04T08:37:04+00:00","og_image":[{"url":"http:\/\/www.withinweb.com\/graphics\/wordpress\/cpanel1_new_style.gif","type":"","width":"","height":""}],"author":"paulv","twitter_card":"summary_large_image","twitter_misc":{"Written by":"paulv","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.withinweb.com\/info\/creating-a-mysql-database-in-cpanel-new-style\/#article","isPartOf":{"@id":"https:\/\/www.withinweb.com\/info\/creating-a-mysql-database-in-cpanel-new-style\/"},"author":{"name":"paulv","@id":"https:\/\/www.withinweb.com\/info\/#\/schema\/person\/04da5531c302d55ffcd777fe81dbb93c"},"headline":"Creating a mySQL Database in cPanel (new style)","datePublished":"2009-04-04T08:19:49+00:00","dateModified":"2009-04-04T08:37:04+00:00","mainEntityOfPage":{"@id":"https:\/\/www.withinweb.com\/info\/creating-a-mysql-database-in-cpanel-new-style\/"},"wordCount":362,"commentCount":0,"image":{"@id":"https:\/\/www.withinweb.com\/info\/creating-a-mysql-database-in-cpanel-new-style\/#primaryimage"},"thumbnailUrl":"http:\/\/www.withinweb.com\/graphics\/wordpress\/cpanel1_new_style.gif","articleSection":["PHP-eSeller","PHP-KeyCodes","PHP-SecureArea","SQL databases"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.withinweb.com\/info\/creating-a-mysql-database-in-cpanel-new-style\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.withinweb.com\/info\/creating-a-mysql-database-in-cpanel-new-style\/","url":"https:\/\/www.withinweb.com\/info\/creating-a-mysql-database-in-cpanel-new-style\/","name":"Creating a mySQL Database in cPanel (new style) - PHP Web Applications","isPartOf":{"@id":"https:\/\/www.withinweb.com\/info\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.withinweb.com\/info\/creating-a-mysql-database-in-cpanel-new-style\/#primaryimage"},"image":{"@id":"https:\/\/www.withinweb.com\/info\/creating-a-mysql-database-in-cpanel-new-style\/#primaryimage"},"thumbnailUrl":"http:\/\/www.withinweb.com\/graphics\/wordpress\/cpanel1_new_style.gif","datePublished":"2009-04-04T08:19:49+00:00","dateModified":"2009-04-04T08:37:04+00:00","author":{"@id":"https:\/\/www.withinweb.com\/info\/#\/schema\/person\/04da5531c302d55ffcd777fe81dbb93c"},"breadcrumb":{"@id":"https:\/\/www.withinweb.com\/info\/creating-a-mysql-database-in-cpanel-new-style\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.withinweb.com\/info\/creating-a-mysql-database-in-cpanel-new-style\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.withinweb.com\/info\/creating-a-mysql-database-in-cpanel-new-style\/#primaryimage","url":"http:\/\/www.withinweb.com\/graphics\/wordpress\/cpanel1_new_style.gif","contentUrl":"http:\/\/www.withinweb.com\/graphics\/wordpress\/cpanel1_new_style.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/www.withinweb.com\/info\/creating-a-mysql-database-in-cpanel-new-style\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.withinweb.com\/info\/"},{"@type":"ListItem","position":2,"name":"Creating a mySQL Database in cPanel (new style)"}]},{"@type":"WebSite","@id":"https:\/\/www.withinweb.com\/info\/#website","url":"https:\/\/www.withinweb.com\/info\/","name":"PHP Web Applications","description":"Information and support for products of WithinWeb.com","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.withinweb.com\/info\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.withinweb.com\/info\/#\/schema\/person\/04da5531c302d55ffcd777fe81dbb93c","name":"paulv","url":"https:\/\/www.withinweb.com\/info\/author\/paulv\/"}]}},"_links":{"self":[{"href":"https:\/\/www.withinweb.com\/info\/wp-json\/wp\/v2\/posts\/164","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.withinweb.com\/info\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.withinweb.com\/info\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.withinweb.com\/info\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.withinweb.com\/info\/wp-json\/wp\/v2\/comments?post=164"}],"version-history":[{"count":18,"href":"https:\/\/www.withinweb.com\/info\/wp-json\/wp\/v2\/posts\/164\/revisions"}],"predecessor-version":[{"id":183,"href":"https:\/\/www.withinweb.com\/info\/wp-json\/wp\/v2\/posts\/164\/revisions\/183"}],"wp:attachment":[{"href":"https:\/\/www.withinweb.com\/info\/wp-json\/wp\/v2\/media?parent=164"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.withinweb.com\/info\/wp-json\/wp\/v2\/categories?post=164"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.withinweb.com\/info\/wp-json\/wp\/v2\/tags?post=164"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}