you can install phpmyadmin yourself. simply follow the instructions and set it for a non-advenced authentication method and it will work all fine for you.


------------------
Félix C.Courtemanche . Head Designer
Co-Administrator . Can-Host Networks
http://www.can-host.com
webmaster@can-host.com

Originally posted by major:
But, I got a little confused by Tera-Byte's support team (which responds fairly quickly btw). First I got an email saying I could install phpMyAdmin myself - and then in another mail they said I would only set phpMyAdmin up if I was on a dedicated server... ???

If I can set it up myself, I think I will choose them actually... I will look further into this question...

I don't think it makes a difference if you're on a ded or not. All it requires is that you are able to set the config to make the connection to the db and use the format that Felix mentioned. Instead of using root (the std user), you'll simply use the username and password for your account (the basic auth), like this:

$cfgServers[1]['host'] = 'localhost'; // MySQL hostname
$cfgServers[1]['port'] = ''; // MySQL port - leave blank for default port
$cfgServers[1]['adv_auth'] = false; // Use advanced authentication?
$cfgServers[1]['stduser'] = 'root'; // MySQL standard user (only needed with advanced auth)
$cfgServers[1]['stdpass'] = ''; // MySQL standard password (only needed with advanced auth)
$cfgServers[1]['user'] = 'username'; // MySQL user (only needed with basic auth)
$cfgServers[1]['password'] = 'password'; // MySQL password (only needed with basic auth)
$cfgServers[1]['only_db'] = 'db_name'; // If set to a db-name, only this db is accessible
$cfgServers[1]['verbose'] = ''; // Verbose name for this host - leave blank to show the hostname




------------------
Annette
Hosting Matters, Inc.
http://www.hostmatters.com

I am currently hosted with HostRocket and I am VERY happy with their service, prices etc. BUT I really need a host that offers PHP4...

Everything on my site will be built using PHP/MySQL so I really think I should run the latest, faster version of PHP...

This is what I am looking for:
- PHP4 (maybe with Zend Optimizer)
- MySQl database (preferably 3 - but one will do for the time being)
- SSH, FTP, CGI and the rest of it!
- Generous bandwidth (please, a company with a GB indication ;))
- phpMyAdmin
- Good support

I am looking for a prize around $10-15. I know it isn't much but I know it exists...

I have considered Tera-Byte, but they don't have phpMyAdmin installed. It is not a must, but would really be appreciated...

And hopefully at a place where I can grow when my site does :)

Tera-byte has gotten excellent reviews. Any reason you can't set up phpMyAdmin (http://www.phpwizard.net/projects/phpMyAdmin/index.html) even if they don't offer it themselves? It won't be integrated into any controls they might offer, and it might take a little tweaking to get the settings just right, but at least only the config file will require it. If you've found a host that offers what you want and that provides the service that tera-byte does, I say go for it - even if there's a piece you have to set up yourself. :)

------------------
Annette
Hosting Matters, Inc.
http://www.hostmatters.com

Thanks for replying, Annette.

I know Tera-Byte has gotten excellent reviews (together with Hostmatters ;)) and I consider them strongly...

But, I got a little confused by Tera-Byte's support team (which responds fairly quickly btw). First I got an email saying I could install phpMyAdmin myself - and then in another mail they said I would only set phpMyAdmin up if I was on a dedicated server... ???

If I can set it up myself, I think I will choose them actually... I will look further into this question...

Or just go with someone that already uses phpmyAdmin for MySQL. There are tons out there, we're one and Im sure theres plenty more to pick from on this board too.

Annette's configuration sample is right. phpMyAdmin is fairly simple to install yourself. I've done this for my clients who need it. The benefit in doing it yourself is you will have the latest version. Most hosts are lagging behind by a few dot-releases. You'll find plenty of help here if you need it.

Thanks to all of you - and especially to Annette for showing me the configuration code :)

I haven't decided yet, but think I might just go with Tera-Byte as phpMyAdmin can be installed...

I have installed PhpMyAdmin @ Tera-Byte before, so if you need some help give me a yell.

------------------
Webhost Area Forums! (http://www.webhostarea.com/forums/)

Well, I did sign up with Tera-Byte, and everything is working fine. But the thing is - I will get three MySQL databases, and would like to be able to use phpMyAdmin with all of them. Obviously I would like to have only one installation of it on the server, is that possible ?

Yes, you will - if you enter the data for the other databases in the additional configuration areas of the config file. The example given above is section one; by default, phpMyAdmin gives you three in the config file, and if you have more than three you can simply add another section.

Annette, thanks yet again. You are great ;)