| View previous topic :: View next topic |
| Author |
Message |
allancairns
Tux's lil' helper
Joined: 18 Dec 2003
Posts: 80
Location: Perth, Western Australia
|
 Posted: Tue Jan 27, 2004 11:58 am Post subject: Accessing phpmyadmin from other computers |
 |
|
Hi,
I have set up mysql, apache2, mod_php and phpmyadmin and can quite happily access phpmyadmin from the server it is running on using the root user and password.
I am having trouble setting up a user to access phpmyadmin from another computer on my network. I must admit I got a bit lost in the phpmyadmin documentation.
I tried adding a user (@%) to the mysql database and granting that user all privileges. No luck.
Help!
Thanks,
Allan |
|
| Back to top |
|
 |
kitano
Apprentice
Joined: 19 Dec 2002
Posts: 228
Location: Munich, Germany, Europe, Earth
|
| Posted: Tue Jan 27, 2004 4:05 pm Post subject: |
|
|
maybe you could post an excerpt from your mysql.user table, so we can have a look.
what kind of authentification-method do you have enabled in /etc/phpmyadmin/config.inc.php?
_________________
->searched for a gentoo penguin ->alienated it with "find edges", "saturation", "photocopy" ->encoded quicktime from still ->played with aaxine ->screenshotted ->made it my avatar
only in case you were going to ask what it is... |
|
| Back to top |
|
|
allancairns
Tux's lil' helper
Joined: 18 Dec 2003
Posts: 80
Location: Perth, Western Australia
|
| Posted: Wed Jan 28, 2004 2:14 pm Post subject: |
|
|
Here is my are the relevant auth lines from my config -
| Code: | root@linserve phpmyadmin # cat config.inc.php | grep 'auth'
* The 'cookie' auth_type uses blowfish algorithm to encrypt the password. If
* at least one server configuration uses 'cookie' auth_type, enter here a
$cfg['Servers'][$i]['auth_type'] = 'http'; // Authentication method (config, http or cookie based)?
// with 'config' auth_type)
$cfg['Servers'][$i]['AllowDeny']['order'] // Host authentication order, leave blank to not use
$cfg['Servers'][$i]['AllowDeny']['rules'] // Host authentication rules, leave blank for defaults
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['LoginCookieRecall'] = TRUE; // recall previous login in cookie auth. mode or not
$cfg['AllowArbitraryServer'] = FALSE; // allow login to any user entered server in cookie based auth |
The user I am trying to log in using -
user host p/w Global privileges Grant
allan % Yes ALL PRIVILEGES Yes
Thanks,
Allan |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
Networking & Security
