Difference between revisions of "Setup - Database"

From TNG_Wiki
Jump to navigation Jump to search
m (→‎Related Links: added linke to TNG not communicating with database)
(Updated, and collapsed the Server options)
 
(One intermediate revision by one other user not shown)
Line 2: Line 2:
 
|__TOC__
 
|__TOC__
 
|}
 
|}
 +
 +
As you install TNG, or later, if you change your database name or database user, you'll need to define the TNG parameters that it needs to talk to your database.  If your database hasn't been created yet, see See [[Database - Creating]]
  
 
== TNG Database Parameters ==
 
== TNG Database Parameters ==
Line 7: Line 9:
 
{|  
 
{|  
 
|[[image:setup_database.jpg|thumb|500px|TNG Database Parameters ]]
 
|[[image:setup_database.jpg|thumb|500px|TNG Database Parameters ]]
|
+
| The parameters TNG needs to communicate with your database are defined at '''Administration >> Setup >> General Settings >> Database'''  
The '''Setup >> General Settings >> Database''' provides the parameters needed for TNG to communicate with your database.
 
 
 
 
|}
 
|}
  
Line 16: Line 16:
 
== Database Connection Information ==
 
== Database Connection Information ==
  
The following are some examples of different host database connection information.
+
Here are some examples of how to get the host database connection information.  In all cases, if you don't know the password, you cannot just look it up; you'll have to reset the password for the TNG user.
  
 
=== ICDSoft mySQL 4 ===
 
=== ICDSoft mySQL 4 ===
 
+
<div class='mw-collapsible mw-collapsed'>
 
The cPanel MySQL interface on ICDSoft for mySQL 4 shows the following high-lighted information which is used to create your TNG Database parameters.
 
The cPanel MySQL interface on ICDSoft for mySQL 4 shows the following high-lighted information which is used to create your TNG Database parameters.
{|
+
<div>[[image:setup_database_mysql4.jpg|700px|ICDSoft cPanel - MySQL 4 ]]</div>
|[[image:setup_database_mysql4.jpg|thumb|700px|ICDSoft cPanel - MySQL 4 ]]
+
</div>
 
 
|}
 
  
 
=== ICDSoft mySQL 5 ===
 
=== ICDSoft mySQL 5 ===
 
+
<div class='mw-collapsible mw-collapsed'>
 
The Control Panel MySQL Database Manager interface on ICDSoft for mySQL 5 shows the following high-lighted information which is used to create your TNG Database parameters.
 
The Control Panel MySQL Database Manager interface on ICDSoft for mySQL 5 shows the following high-lighted information which is used to create your TNG Database parameters.
 
+
<div>[[image:setup_database_mysql5.jpg|700px|ICDSoft cPanel - MySQL 5 ]]</div>
{|
+
</div>
|[[image:setup_database_mysql5.jpg|thumb|700px|ICDSoft cPanel - MySQL 5 ]]
 
|
 
 
 
|}
 
  
 
=== Simply Hosting mySQL ===
 
=== Simply Hosting mySQL ===
 
+
<div class='mw-collapsible mw-collapsed'>
 
The cPanel for the MySQL Database Manager interface on Simply Hosting shows the following high-lighted information which is used to create your TNG Database parameters.
 
The cPanel for the MySQL Database Manager interface on Simply Hosting shows the following high-lighted information which is used to create your TNG Database parameters.
 
+
<div>[[image:SH_cPanel_database_user.jpg|700px|SH cPanel - MySQL ]]</div>
{|
+
</div>
|[[image:SH_cPanel_database_user.jpg|thumb|700px|SH cPanel - MySQL ]]
 
|
 
 
 
|}
 
  
 
=== GoDaddy ===
 
=== GoDaddy ===
 
+
<div class='mw-collapsible mw-collapsed'>
The following link [http://help.godaddy.com/topic/67/article/3351 provides the information] for connecting to a database on GoDaddy. <sub>Provided by Scotty on [http://www.tngforum.us/index.php?s=&showtopic=4294&view=findpost&p=20542 the TNG Forum]</sub>
+
The following link [http://help.godaddy.com/topic/67/article/3351 provides the information] for connecting to a database on GoDaddy. <sub>Provided by Scotty on [http://tng.community/index.php?s=&showtopic=4294#comment-20542 the TNG Community Forum]</sub>
 
+
</div>
  
 
=== Local server ===
 
=== Local server ===
 +
<div class='mw-collapsible mw-collapsed'>
 +
Launch '''phpMyAdmin''' from the WampServer icon in the system tray
 +
* The Host Name is almost certainly "localhost", but you can confirm that by looking at the "Server" value listed in the '''MySQL'' panel on the far right of the phpMyAdmin home page.
 +
* The database is one of the database names listed in the left-hand panel of the phpMyAdmin home page.
 +
* To find the database user name, click on the database name in the left-hand panel, and then select the '''Privileges''' tab.  More than one user name may be listed.  You'll have to decide which one is the right one.
  
On your local web server in the database setup, the Username might be Root and the password null, if you did not set the password for MySQL when you created the local web server or after.
+
If the only database username is "Root", you should consult the phpMyAdmin instructions in the [[Database - Creating#phpMyAdmin|Database - Creating]] article in order to
 +
* Make sure that the "Root" account has a password, and
 +
* Set up a separate user account for TNG to use.
 +
</div>
  
 
== Related Links ==
 
== Related Links ==
  
 
* [[Database - Creating]]
 
* [[Database - Creating]]
 
 
* [[TNG not communicating with database]]
 
* [[TNG not communicating with database]]
  
 
[[Category:Setup]]
 
[[Category:Setup]]

Latest revision as of 21:30, 11 December 2015

As you install TNG, or later, if you change your database name or database user, you'll need to define the TNG parameters that it needs to talk to your database. If your database hasn't been created yet, see See Database - Creating

TNG Database Parameters

TNG Database Parameters
The parameters TNG needs to communicate with your database are defined at Administration >> Setup >> General Settings >> Database

You should be able to find the values needed for the TNG database paremeters from your host's control panel MySQL databases interface.

Database Connection Information

Here are some examples of how to get the host database connection information. In all cases, if you don't know the password, you cannot just look it up; you'll have to reset the password for the TNG user.

ICDSoft mySQL 4

The cPanel MySQL interface on ICDSoft for mySQL 4 shows the following high-lighted information which is used to create your TNG Database parameters.

ICDSoft cPanel - MySQL 4

ICDSoft mySQL 5

The Control Panel MySQL Database Manager interface on ICDSoft for mySQL 5 shows the following high-lighted information which is used to create your TNG Database parameters.

ICDSoft cPanel - MySQL 5

Simply Hosting mySQL

The cPanel for the MySQL Database Manager interface on Simply Hosting shows the following high-lighted information which is used to create your TNG Database parameters.

SH cPanel - MySQL

GoDaddy

The following link provides the information for connecting to a database on GoDaddy. Provided by Scotty on the TNG Community Forum

Local server

Launch phpMyAdmin from the WampServer icon in the system tray

  • The Host Name is almost certainly "localhost", but you can confirm that by looking at the "Server" value listed in the 'MySQL panel on the far right of the phpMyAdmin home page.
  • The database is one of the database names listed in the left-hand panel of the phpMyAdmin home page.
  • To find the database user name, click on the database name in the left-hand panel, and then select the Privileges tab. More than one user name may be listed. You'll have to decide which one is the right one.

If the only database username is "Root", you should consult the phpMyAdmin instructions in the Database - Creating article in order to

  • Make sure that the "Root" account has a password, and
  • Set up a separate user account for TNG to use.

Related Links