Voetsjoeba
August 1st, 2003, 05:11 AM
Hi everyone :)
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 (http://www.phpmyadmin.net/documentation/) 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 ??
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 (http://www.phpmyadmin.net/documentation/) 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 ??