Connect to a MySQL Database | A Small Orange Support

<p>In order for your MySQL database to work as intended, it will need a script calling or querying the database for the information it stores. In order to do this, you must connect your script to the database with a configuration file.</p>

<h2 class="subject2a">Configuration Settings</h2>

<p>Database driven scripts, such as Wordpress, WHMCS and Joomla, will generally have a default configuration file ready for you to edit with the appropriate information. Below you will find examples of what this access information will look like:</p>

<p>Host Name = localhost (literally input localhost)<br />
Database Name = cpanelUsername_databaseName<br />
Database Username = cpanelUsername_databaseUsername<br />
Database Password = whatever you selected</p>

<div class="groupbox">
<p><strong>WordPress Example</strong></p>

<table border="0" cellpadding="1" cellspacing="1">
	<tbody>
		<tr>
			<td>
			<p><em>Username = joe1337</em></p>
			</td>
			<td>
			<p><em>Database Name = wrdp1</em></p>
			</td>
		</tr>
		<tr>
			<td>
			<p><em>Database-Username = wp1</em></p>
			</td>
			<td>
			<p><em>Database-User Password = eHTb7%Pxa9</em></p>
			</td>
		</tr>
	</tbody>
</table>

<p class="code"><br />
<strong>// ** MySQL Settings ** //</strong><br />
<br />
<span style="font-family: courier new,courier,monospace;">/** The name of the database for WordPress */<br />
define('DB_NAME', 'joe1337_wrdp1');<br />
<br />
/** MySQL database username */<br />
define('DB_USER', 'joe1337_wp1');<br />
<br />
/** MySQL database password */<br />
define('DB_PASSWORD', 'eHTb7%Pxa9');<br />
<br />
/** MySQL hostname */<br />
define('DB_HOST', 'localhost');</span><br />
&nbsp;</p>
</div>

<p class="blockquoteerror">While it is possible to connect to the database using your cPanel username and password, we&nbsp;<strong>NEVER</strong>&nbsp;recommend this. Every time you change or reset your cPanel password your databases will stop working until configuration files are updated.</p>

<h2 class="subject2blue">Tips and Tricks for Moving Databases</h2>

<ul>
	<li class="look_here">
	<p>When you move databases to our servers, the database name and username may change. This change must be updated in your script code. The database name and username is clearly displayed in cPanel, in the MySQL area.</p>
	</li>
	<li>
	<p>On Shared servers, the database username cannot be changed to something without the cPanel username in it. This is to keep database names and usernames from conflicting with others on the server.</p>
	</li>
</ul>

<div class="look_here">
<h2>MySQL User Has No Privileges</h2>

<p>Since the 11.25 update, we've noticed an occasional bug where adding an IP to the MySQL remote access list results in the corresponding MySQL user having no privileges.</p>

<p>In order to get the correct privileges added:</p>

<ol>
	<li>
	<p>Go to your<strong> MySQL Databases</strong> in cPanel</p>
	</li>
	<li>
	<p>Re-add the <strong>user</strong> to each database by selecting the user and the database from the drop-down menus</p>
	</li>
	<li>
	<p>Reassign the privileges</p>
	</li>
	<li>
	<p>Click <strong>Add</strong></p>
	</li>
</ol>
</div>