A
Anonymous
Guest
It seems that $cfg['Servers'][$i]['host'] does not allow wilcards like 192.168.1.% or 192.168.1.*
So I tried approach I found in the manual (for user named xxyyzz):
$cfg['Servers'][$i]['AllowDeny']['order'] = 'allow,deny';
$cfg['Servers'][$i]['AllowDeny']['rules'] = array('allow xxyyzz from 192.168.100.[10-50]');
Unfortunatelly this is not working, as I get Access Denied error when I try to log in to phpMyAdmin. I guess that I don't understand the manual correctly.
I have mysql user xxyyzz in the db:
Below is the relevant (I think) portion of config.inc.php:
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['AllowDeny']['order'] = 'allow,deny';
$cfg['Servers'][$i]['AllowDeny']['rules'] = array('allow xxyyzz from 192.168.100.[10-50]');
//$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['AllowNoPassword'] = true;
(it does not matter if the statement $cfg['Servers'][$i]['host'] = 'localhost'; is comented out or or noncomented)
So, any help will be appreciated.
So I tried approach I found in the manual (for user named xxyyzz):
$cfg['Servers'][$i]['AllowDeny']['order'] = 'allow,deny';
$cfg['Servers'][$i]['AllowDeny']['rules'] = array('allow xxyyzz from 192.168.100.[10-50]');
Unfortunatelly this is not working, as I get Access Denied error when I try to log in to phpMyAdmin. I guess that I don't understand the manual correctly.
I have mysql user xxyyzz in the db:
Code:
+-------------+-------------+-------------------------------------------+
| User | Host | Password |
+-------------+-------------+-------------------------------------------+
| mariadb.sys | localhost | |
| lado | 192.168.1.% | *C979990636F0FD3A713EA90111608F3C9E530C6C |
| root | ..... | ..... |
+-------------+-------------+-------------------------------------------+
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['AllowDeny']['order'] = 'allow,deny';
$cfg['Servers'][$i]['AllowDeny']['rules'] = array('allow xxyyzz from 192.168.100.[10-50]');
//$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['AllowNoPassword'] = true;
(it does not matter if the statement $cfg['Servers'][$i]['host'] = 'localhost'; is comented out or or noncomented)
So, any help will be appreciated.