|
.
You are here:
Support Center ->
MySQL Databases ->
Changing Database Password
MYSQL
Databases
This section provides information about changing database passwords,
setting up your database with scripts and accessing phpMyAdmin.
Changing
Database Passwords
To change a database password, first click on the name of
the database in the main MySQL Management menu. The list
of database users will appear. To
change the password for the database user, click the " Modify " link and enter a new password, then click the
" Create " button. You do not need to know the old
password to make this change.
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 Management menu.
For example, if you sign into the control panel as "abcd"
and create a database named "count," the true database
name is abcd_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.
Accessing
phpMyAdmin
phpMyAdmin is a tool written in PHP that allows you to
administrate your MySQL databases. You can execute SQL
statements, work with fields (add, edit, delete), work
with tables (create, alter, drop), create additional
databases, and much more. phpMyAdmin is intended for
advanced users. Most PHP scripts will automatically
setup the database for you, so you probably won't need
to use phpMyAdmin.
phpMyAdmin can be accessed at http://www.yourdomain.com/phpMyAdmin
Need more
help?
If you're in need of assistance or
have any unanswered questions please
Contact
Us Here.
. |
compare
our
plans
