tkm Posted June 6, 2008 Share Posted June 6, 2008 Hello Mates, I am trying to configure config.inc.php for phpmyadmin. I am doing the following: $cfg['Servers'][$i]['host'] = 'localhost'; $cfg['Servers'][$i]['port'] = ''; $cfg['Servers'][$i]['socket'] = ''; $cfg['Servers'][$i]['connect_type'] = 'tcp'; $cfg['Servers'][$i]['extension'] = 'mysql'; $cfg['Servers'][$i]['compress'] = FALSE; $cfg['Servers'][$i]['controluser'] = 'pma'; $cfg['Servers'][$i]['controlpass'] = 'pmapass'; $cfg['Servers'][$i]['auth_type'] = 'http'; $cfg['Servers'][$i]['user'] = ''; $cfg['Servers'][$i]['password'] = ''; GRANT USAGE ON mysql.* TO 'pma'@'localhost' IDENTIFIED BY 'pmapass'; GRANT SELECT (Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv, Execute_priv, Repl_slave_priv, Repl_client_priv) ON mysql.user TO 'pma'@'localhost'; GRANT SELECT ON mysql.db TO 'pma'@'localhost'; GRANT SELECT ON mysql.host TO 'pma'@'localhost'; GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv) ON mysql.tables_priv TO 'pma'@'localhost'; when I open phpmyadmin index page, it doesn't take my root username/password. However I can log into phpmyadmin when I use the same root username and password in config auth_type. Can anyone please point out where I am doing wrong? Thank you. Quote Link to comment https://forums.phpfreaks.com/topic/108958-phpmyadmin-configuration-problem/ Share on other sites More sharing options...
BioBob Posted August 5, 2008 Share Posted August 5, 2008 Well considering this is in the IIS thread, I'll assume youre on an IIS server. Try changing your auth type to cookie instead of config. Some of the other auth methods simply arent available for php running on IIS... Quote Link to comment https://forums.phpfreaks.com/topic/108958-phpmyadmin-configuration-problem/#findComment-608489 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.