Setting up your Database with Scripts


Most scripts need to know four things about your database: the database name, database username, password, and hostname.  

The database name always takes the form as ControlPanelUsername_DatabaseName, where ControlPanelUsername is the sign in name you use to access the control panel.  The DatabaseName is the name you give to the database from the MySQL databases menu.  For example, if you sign into the control panel as "gary" and create a database named "count," the true database name is gary_count -- you will want to enter this database name into your script configuration.


The database username can be the same as the database name or you may choose a different username for the database.  The database username takes the form of ControlPanelUsername_DatabaseUserName.
 

The database password is set during database creation.  The password should be different than your control panel password.  The script will need to know the database password in order to modify the database.

The hostname tells the script where to access the database.  Usually this is designated as 'localhost' because the script and database are located on the same server.  If the script doesn't allow a text entry in the hostname configuration, enter the IP address of your site.

 

Note:  

After you create a database, the control panel will take you to a screen that gives you all this information.  Simply take the values from this page and enter them into your script configuration.

Kas see vastus oli kasulik?

 Prindi artikkel

Seotud artiklid

Mysql database beschadigd / repareren tabellen

Een database heeft af en toe onderhoud nodig (bijv. analyseer tabel of gewoon verwijderen...

Kan ik de database benaderen vanaf een externe lokatie?

Nee, een database is een additionele dienst op een shared hostingaccount. Connecties naar de...

Maakt Codyco backups van mijn MySQL database?

Codyco maakt dagelijks een back-up van de databaseservers. Deze back-up is alleen voor crashes en...

Accessing phpMyAdmin

phpMyAdmin is a tool written in PHP that allows you to administrate your MySQL databases.  You...

Changing Database Passwords

To change a database password, first click on the name of the database in the main MySQL...