Hi all,

Probably a dumb question...

I'm looking into several hosts who have almost the same control panel. In their demos, they do not have a way to manage your databses through the browser, such as PHPMyAdmin. The ones I've asked about this say I must email them for database setup.:disagree:

Can PHPMyAdmin be installed on a shared hosting environment, so I can manage my databases from my own space? Is there another tool? Do I have to have telnet access for the install, or am I out of luck?

Thanks :)

Originally posted by ginakra

Can PHPMyAdmin be installed on a shared hosting environment, so I can manage my databases from my own space?

Yes.


Originally posted by ginakra

Do I have to have telnet access for the install, or am I out of luck?

No. PhpMyAdmin is just plain php files - all you need to do is change the config file then upload all of it through FTP

Thanks for replying :)

I took a look at the config file, and there's alot of stuff I don't know here. I uploaded it to my current host that has a database management system (not PHPMyAdmin) to see if I could get it going.

In the config, I put in my absolute url for the domain and folder I uploaded MyAdmin to. Then I left everything alone except for inputting my username and password in the areas provided :['user']. ['password']. When I go to the index page of MyAdmin, I keep getting:

Error
MySQL said:
Access denied for user: 'myusername@localhost' (Using password: YES)

The server is "localhost" so I don't know where I am going wrong here. The username and pass are the same ones I use to log into my other control panel that has the database admin. Anywhere to point where I might have missed an important setting or something? I looked at the config explanations, and though most of them areover my head, everything looks right to me:confused:

The username and pass are the same ones I use to log into my other control panel that has the database admin.


I don't know what type of CP you are using, but it might be so that it ( the database admin part in the cp, that is ) use another user/password. Like sql_[username] as user name or something like that.

Does it anywhere say something about what username and password you are supposed to use from your scripts?

Otherwise I would email your hosts support asking for it.

Well, with this host, I always input my plain ol username and password. With another host I have, I have to use sysusername_dbname, or sysusername_dbusername. Unfortunately, I can't email the host, because it's 8Host, who just went out of business. That's why I'm looking into another ;-)

Um...phpMyAdmin, once I get it installed *will* let me create databases and users--right? I just need it to connect to the MySQL area for my username in the first place, correct?

Databases and users.. most likely not. Unless your host allows unlimited databases.. then you could create as many databases as you like, however I doubt you'll be able to create users.

I'm not sure what you're asking in your second question.. are you asking if all you need to do to be able to add databases and users is be able to connect to mysql? If that's what you mean, yes and no.. MySQL has a "user" table that stores what you are allowed and not allowed to do. Only if your host has your mysql account setup with the pertinent priveledges will you be able to create databases/users. If you meant something else by your question LMK.

Justin

Now that I think about it... I think only the root mysql user can create accounts..:confused:

One last thing.. make sure you're connecting to the right server, one of my old hosts had a server specifically for mysql.. instead of 'localhost' as the hostname, it was something like 'mysql.myhost.com'.

HTH