Thread

I’m trying to set up phpmyadmin so I can appraoch all my databases from one place. But I’m puzzled about how to do this. The documentation is IMO a bit confusing.

Has anyone experience with this? Or know where to find a good tutorial/walkthrough?

Are you on shared hosting? A lot of hosts (like Dreamhost) only allow you to create databases from their own control panel - you then access phpmyadmin on a per database basis - having to drop out to their control panel to switch databases.

If you are on your own host - it’s pretty easy actually. I haven’t done it in forever (thanks to xampp automatically setting it up for you), but if I remember correctly you simply give it your hostname, login, and password - don’t specify a particular DB - and it will take care of the rest.

The phpmyadmin setup script seems to be an easy solution to getting it all up and running.

Are you on shared hosting? A lot of hosts (like Dreamhost) only allow you to create databases from their own control panel - you then access phpmyadmin on a per database basis - having to drop out to their control panel to switch databases.

If you are on your own host - it’s pretty easy actually. I haven’t done it in forever (thanks to xampp automatically setting it up for you), but if I remember correctly you simply give it your hostname, login, and password - don’t specify a particular DB - and it will take care of the rest.

The phpmyadmin setup script seems to be an easy solution to getting it all up and running.

Ah. The thing I was doing wrong was providing the username/password for the database. But this should be the uname/pass for the server itself. Duh.  😝

But still, I now have the right uname/pass and I get the ‘access denied’ error. I’m sure the combo is correct. I tested it in winscp and it works.

Config should look like this, right?

$cfg['Servers'][$i]['host'] = 'ip-here';
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'username';
$cfg['Servers'][$i]['password'] = 'password';

Whoops, didn’t carefully read your first lines.

Yes, I’m on a shared host. It’s BECAUSE I have to login into the control panel I want to set up phpmyadmin on one domain. But if I understand correctly I’m pretty much screwed.

Thanks anyway!

EDIT: But what you CAN do is add multiple servers (server=localhost, username=db_user, paswword=db_password) and you’re able to select the DB you want. It’s not the easiest option, but it’ll do!