Where is the best place to put phpmyadmin so that I can use it for any of my website mysql databases ?

6 posts / 0 new
Topic locked
Last post
#1 Wed, 01/13/2010 - 04:34
Anonymous

Where is the best place to put phpmyadmin so that I can use it for any of my website mysql databases ?

I think the title question is about it :)

Where is the best place to put phpmyadmin so that I can use it for any of my website mysql databases ?

I have been using the built in database management tool but there are a few things that would be much quicker with phpmyadmin.

With cPanel it is already set up, so I am not sure where I should put it to run on my VirualMin setup. Will I need to supply it with my root admin user and password ?

Thanks for your help.

Wed, 01/13/2010 - 05:31
tabletguy

Several years ago this was the default on my server. Installing phpMyAdmin under any domain could access all domains if the root user and password were used. I don't know if that's because I accidentally configured MySql for user root to be able to access all databases, but that might be the place to start.

I would very much like to know how to do this too, and perhaps it could also be added to the document wiki?

Wed, 01/13/2010 - 08:07
andreychek

In the past, I've just set this up under the primary domain of the server.

So let's say your hosting business is "example_hosting.com.

What I'd do is create a new Virtual Server named phpmyadmin.example_hosting.com, then setup phpMyAdmin in the root folder of that Virtual Server.

phpMyAdmin doesn't care where it's installed or who is logging in, so long as the user logging in is a valid database user.

So your users can all log in at phpmyadmin.example_hosting.com using their database credentials.

-Eric

Fri, 01/15/2010 - 00:31 (Reply to #3)
tabletguy

That works for each user, but how can I set it up so that I can log in as "root" and get access to all accounts. I have the "allow root = yes" already set, but it still doesn't work.

I've set up root to have access to all databases under the MySql panel, both with localhost and with 127.0.0.1 and neither of those permissions worked either.

Fri, 01/15/2010 - 09:08 (Reply to #4)
andreychek

That should work out of the box... are you logging in using root's MySQL credentials, rather than root's server account credentials?

-Eric

Fri, 01/15/2010 - 23:51 (Reply to #5)
tabletguy

Ironically, I was wondering about that.

Yes, it does work. I had to refresh my memory of the MySql Admin password. For others, that can be found under "Webmin -> Servers -> MySql -> "Change Administrator Password" which also shows the current password.

Thanks

Topic locked