PHP My Admin

programming
1

Hi everyone :slight_smile:

I’m having some problems using PHP My Admin. At my previous server, I installed it too, and it worked fine there. What it did there was display a login screen (http auth), where you had to fill in user name and password for that database.

Now I’m trying to accomplish the same again, but it just doesn’t work ! No matter what I do, it doesn’t. Here’s the Documentation file (which says how to install it).

For ‘HTTP’ and ‘cookie’ modes, phpMyAdmin needs a controluser that has only the SELECT privilege on the mysql.user (all columns except “Password”), mysql.db (all columns) & mysql.tables_priv (all columns except “Grantor” & “Timestamp”) tables.
You must specify the details for the controluser in the config.inc.php3 file under the $cfg[‘Servers’][$i][‘controluser’]& $cfg[‘Servers’][$i][‘controlpass’] settings.
The following example assumes you want to use pma as the controluser and pmapass as the controlpass, but this is only an example: use something else in your file!
Of course you have to replace localhost by the webserver’s host if it’s not the same as the MySQL server’s one.

– I don’t understand a sh$t of this. I never had to do anything with this at my previous server.

**$cfg[‘Servers’][$i][‘controluser’] string
$cfg[‘Servers’][$i][‘controlpass’] string
When using HTTP or cookie authentication modes (or ‘config’ authentication mode since phpMyAdmin 2.2.1), you need to supply the details of a MySQL account that has SELECT privilege on the mysql.user (all columns except “Password”), mysql.db (all columns) & mysql.tables_priv (all columns except “Grantor” & “Timestamp”) tables. This account is used to check what databases the user will see at login.
Please see the install section on “Using HTTP authentication” for more information.

Note that if you try login to phpMyAdmin with this “controluser”, you could get some errors, depending the exact privileges you gave to the “controluser”. phpMyAdmin does not support a direct login with the “controluser”.

In versions before 2.2.5, those were called “stduser/stdpass”. **

– I don’t get it !? There are two users and passes: controluser, controlpass, user and pass. For HTTP, some of these should be filled in and some of shouldn’t. Which of those should be filled in or not !?? I always get this error about some root that is logged in and that everyone has access and all.

What’s the deal with this root ??

2

woah, I never seen anything like that, sry no answer here but to try and reinstall it. is this on your pc at home or web server?

3

you just want to protect the directory your PHPMyAdmin is in? use .htpasswd and .htaccess in the installation directory

4

Oh, I forgot about this thread :stuck_out_tongue: Well, it’s on a server, and I don’t know anything about .htaccess or anything like that. I never had to change anything of that. It’s just something in my config.inc.php file I guess, but no matter what I do, it just doesn’t work.

5

well what i’m saying is, if you Google a tutorial on using .htaccess and .htpasswd together you won’t have to worry about editing config.inc.php…

…if all you’re trying to do is require authentication to use PHPMyAdmin

6

I myself am having trouble getting the .htaccess protection working, which is just odd 'cause itäs so simple.

Well, I uploaded my .htaccess and .htpasswd files in ASCII mode into a folder I wanted to protect. Cool, the folder got protected, but even I can’t get in :smiley:

Some protection huh?

It just isn’t letting me in. The file permissions are set to 644 and paths are correct.

Any idea what went wrong?

7

AFter you are finished completeing your site you should delete phpMyAdmin. Even with the authentication, if someone where to get by it they could completely destroy your database…