MySQL Database

ID #33

I can't get phpMyAdmin to work.

Applies to: Grid System

Chances are, your web browser does not allow third party cookies. To remedy this situation, you can either enable third party cookies or instruct your browser to allow all cookies from secure-dbadmin.com. This guide will assist you to find the Cookies/Privacy settings in your preferred web browser. Once you adjust these settings, you may have to restart your browser for the changes to take effect.

---

If you would rather use your own phpMyAdmin instead of the one integrated into OnSite, then you can download your own copy from phpmyadmin.net.

Make sure you have setup a MySQL database for yourself before trying to use your phpMyAdmin. You can create and check on databases through the OnSite.

Unpack phpMyAdmin into its own directory where the webserver can serve it, such as: /htdocs/www/phpMyAdmin
Change into the phpMyAdmin directory. Edit the file: config.inc.php3

Configure with these settings:

$cfgServers[1]['host'] = 'DBSERVER';

# replace DBSERVER above with
# the correct database server host name
# as described here



$cfgServers[1]['port'] = '3306';
$cfgServers[1]['adv_auth'] = false;
$cfgServers[1]['stduser'] = '';
$cfgServers[1]['stdpass'] = '';
$cfgServers[1]['user'] = 'your_username';
$cfgServers[1]['password'] = 'your_password';
$cfgServers[1]['only_db'] = 'your_database';
$cfgServers[1]['verbose'] = '';

Where 'your_username' would be 'joeblow' or whoever you are.
And where 'your_password' is the password that goes with your username.
And where 'your_database' is the name of your database, which is likely your domain name without the ".com", ".net", or ".org" on the end. If you don't have a domain name then your database name is probably the same as your username.

Then consider password protecting that directory so that anyone can't come along and drop your tables.


Last update: 2010-09-29 16:16
Author: FAQ Admin
Revision: 1.2

Digg it! Share on Facebook Print this record Send FAQ to a friend Show this as PDF file
Please rate this FAQ:

Average rating: 0 (0 Votes)

completely useless 1 2 3 4 5 most valuable

You can comment this FAQ