Installing phpMyadmin

[abdul]

Where do I unzip it? If I do that in my htdocs folder, it'll ask me to overwrite some of the files (eg Index.php). I don't want to do that because I also have some pages with these names in the same folder. Is there anyway to put all the phpMyadmin files into a separate folder in htdocs folder so I can use it?

[cpradio]

You will want to make a new directory in your htdocs folder (do not name it phpMyAdmin as that is commonly used), then unzip all the files in the phpMyAdmin zip file to that directory, edit the config file and your all set.

[abdul]

Ok thanks. I created a folder called "myadmin" in htdocs and now when I try this URL "http://localhost/myadmin/index.php", it gives me this:
The $cfgPmaAbsoluteUri directive MUST be set in your configuration file!

What do I edit in the config file to get it to work?

[abdul]

Never mind, got it working now after editing config.inc.

[The Hobo]

The $cfgPmaAbsoluteUri variable?

Also, if you have the ability, you might want to password your phpMyAdmin directory so others can't access it. Because last I knew, phpMyAdmin doesn't have password protection built in.

[abdul]

Yes, $cfgPmaAbsoluteUri was empty in config.inc. I had to set to the path to phpMyAdmin (localhost/myadmin).
But now I can only access the database on my local machine (using localhost). I have registered at www.coolfreepage.com and it supports php/mysql. It sent me my account information and database name through email. It says that my homepage is http://gx.coolfreepage.com but when I use "http://gx.coolfreepage.com" as the host (eg localhost) and the username/password that the company gave me, it says that the access was blocked.

[cpradio]

That may be due to restrictions by your host. Have you tried uploading the myadmin file to your free server and running it on there?

[abdul]

Ok thanks, I am uploading myadmin to the web server and then I'll see if it works or not. But if I do that, wouldn't anybody who runs phpMyAdmin(he'll certainly be able to because he can see my webpage) be able to edit the database and stuff?

[The Hobo]

Originally posted by abdul
Ok thanks, I am uploading myadmin to the web server and then I'll see if it works or not. But if I do that, wouldn't anybody who runs phpMyAdmin(he'll certainly be able to because he can see my webpage) be able to edit the database and stuff?

You're going to have to password protect the directory like I said, if your webhost has support for it. If not, then yes, they can edit the database. Unless you hide it in a really weird directory like http://www.yoursite.com/g532i235a1 or something.

[cpradio]

or edit the index.php file that phpMyAdmin uses. Make it show a form and ask for a username and password, then check to see if the form was submitted and that the information is correct.

If it is correct display the frames that phpMyAdmin uses

[The Hobo]

Or hire a doorman to keep all the bad people out?

[abdul]

I guess I'll just work on the website/database locally and then upload it instead of going through this hard work...

[The Hobo]

it's not that hard...

[chrisjk]

http://www.colostate.edu/~ric/htpass.html