{"id":397225,"date":"2006-06-01T01:27:02","date_gmt":"2006-06-01T01:27:02","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/help-selecting-database-problem\/"},"modified":"2016-08-18T21:33:32","modified_gmt":"2016-08-18T21:33:32","slug":"help-selecting-database-problem","status":"closed","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/help-selecting-database-problem\/","title":{"rendered":"Help Selecting Database Problem"},"content":{"rendered":"<p>Ok&#8230; This is how my wp-config.php file looks like<\/p>\n<p>&#8212;&#8212;&#8212;&#8212;-<br \/>\n\/\/ ** MySQL settings ** \/\/<br \/>\ndefine(&#8216;DB_NAME&#8217;, &#8216;iotera_wordpress&#8217;);    \/\/ The name of the database<br \/>\ndefine(&#8216;DB_USER&#8217;, &#8216;iotera_wpiotera&#8217;);     \/\/ Your MySQL username<br \/>\ndefine(&#8216;DB_PASSWORD&#8217;, &#8216;Bleeped&#8217;); \/\/ &#8230;and password<br \/>\ndefine(&#8216;DB_HOST&#8217;, &#8216;localhost&#8217;);    \/\/ 99% chance you won&#8217;t need to change this value<br \/>\n&#8212;&#8212;&#8212;&#8212;-<\/p>\n<p>Ok, in CPanel,  i created a database called &#8216;wordpress&#8217; .. And it renamed itself to &#8216;iotera_wordpress&#8217;.<br \/>\nI added a user, user &#8216;wpiotera&#8217;. And it renamed itself to &#8216;iotera_wpiotera&#8217;.<br \/>\nOk so i entered that information into my config.php file and i am STILL getting an error saying &#8220;Can\u2019t select database<\/p>\n<p>We were able to connect to the database server (which means your username and password is okay) but not able to select the wpiotera_wordpress database.<\/p>\n<p>    * Are you sure it exists?<br \/>\n    * On some systems the name of your database is prefixed with your username, so it would be like username_wordpress. Could that be the problem?<br \/>\n&#8220;<br \/>\n&#8212;<br \/>\nThank you SO MUCH if you can help me!<\/p>\n","protected":false},"template":"","class_list":["post-397225","topic","type-topic","status-closed","hentry","topic-tag-database","topic-tag-selecting","topic-tag-stuff"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/397225","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/397225\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=397225"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}