can only create one database in phpmyadmin

joyce posted this at 03:00 — 25th July 2002.

Joined: Nov 2001

hi, i have a few things to ask about phpMyAdmin.

i installed it on my server, everything seems to run perfectly. but there are one thing very strange which is, i only can see one database there. means i can't create a new database. why is it like tat??

my web hosting set up the mysql for me. is it because they set it in order i can only create one database?

another problem is about the username and password. i do know tat u can set password in the config.inc. i set my username and password in it but when i access the index.php, i can straight away see all my database and tables without keying in any password. i thought by setting username and password phpmyadmin will prompt me to key in my username and password before i can view all my data. how can i set the password in order to have the pop up box for me to key in username and password??

this is how i set:

$cfgServers[$i]['user']          = 'abc';      // MySQL user
$cfgServers[$i]['password']      = 'abc123';   // MySQL password (only needed

pls help...thanks. :bawling:

Mark Hensler posted this at 06:09 — 25th July 2002.

He has: 4,048 posts

Joined: Aug 2000

My install, with root mySQL priveleges (root is prefered)

// stduser is a mysql user with SELECT access to only
// the `user` and `db` tables in the `mysql` database
$cfgServers[1]['controluser']   = 'stduser';
$cfgServers[1]['controlpass']   = 'shhh';

$cfgServers[1]['auth_type']     = 'http';

// leave this empty!
$cfgServers[1]['only_db']       = '';

'
Another install, without root...

$cfgServers[1]['auth_type']     = 'config';

$cfgServers[1]['user']          = 'my_user';
$cfgServers[1]['password']      = 'my_pass';

$cfgServers[1]['only_db']       = '';

'With the second setup, you need to protect the directory with .htaccess.

Mark Hensler
If there is no answer on Google, then there is no question.