phpMyAdmin

Started by Ray, Apr 23, 2009, 12:09:52

Previous topic - Next topic

0 Members and 2 Guests are viewing this topic.

Sebby


psp83

Quote from: Sheltieuk on Apr 25, 2009, 17:29:03
Thank you, Jane, that's solved my problem by putting the user name and DB password in the config file, I can now access the database from phpmyadmin.  :thumb:  :thnks: and :karma:

Putting your user and password into the config.inc.php is not very secure if your server is online, anyone going to the phpmyadmin folder on your domain can get access. If this is the case for you then i would password protect the directory.

jane

That's great. I did say I was using it on a local test PC but should have stressed the security issues. Having said that, being able just to get into the thing is a start. I gave up on it umpteen times before it clicked and that was only after reading between the lines on the so-called help forums. I'm going to have to write this down so I don't forget it now  ;D

Cheers  :thumb:


Rik

The forum does its magic again. Thanks, Jane. :karma:
Rik
--------------------

This post reflects my own views, opinions and experience, not those of IDNet.

Ray

#29
Quote from: psp83 on Apr 25, 2009, 23:40:23
Putting your user and password into the config.inc.php is not very secure if your server is online, anyone going to the phpmyadmin folder on your domain can get access. If this is the case for you then i would password protect the directory.

Thanks, Paul, that thought did occur to me, so I've disable anonymous user on the directory security tab and set it to require Windows authentication in the IIs server properties for the folder.  :thumb:
Ray
--------------------

This post reflects my own views, opinions and experience, not those of IDNet.

psp83

Making PHP My Admin work the way you want it to work requires a computer science degree.

I hate setting it up and i'm a web developer!  :-\

Ray

Quote from: psp83 on Apr 26, 2009, 16:34:29
Making PHP My Admin work the way you want it to work requires a computer science degree.

I hate setting it up and i'm a web developer!  :-\

I've got to agree with you there, Paul, I've been playing with the config file again and there's no way I can get it to login unless I set the auth_type to 'config'. I've got the directory tightened down now so that when you try to access it you get a Windows user name and password box come up and there's only one user allowed to access it.
Ray
--------------------

This post reflects my own views, opinions and experience, not those of IDNet.