Page 1 of 1

Upgraded to v.1.8.1 and Privileges tab missing in phpMyAdmin

PostPosted: 28. November 2012 15:22
by luismartin
I've just upgraded Xampp from 1.7 to 1.8.1. Well, I've followed these steps I saw somewhere:

1- Exported old databases with phpMyAdmin,
2- Renamed /xampp to /xampp_old
3- Installed new xampp in /xampp
4- Imported old databases (I managed to do it with MySQL Administrator because phpMyAdmin failed this time due to collisions with default databases on new installation, and I couldn't drop any of these databases from phpmyadmin).

Finally this is how I've configured config.inc.php in /xampp/phpmyadmin/

Code: Select all
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
$cfg['Lang'] = '';


Despite being root with no password, I can't manage users through the phpmyadmin GUI. I had to do it directly in the mysql>user table.

Any help to enable this tab would be appreciated.

Re: Upgraded to v.1.8.1 and Privileges tab missing in phpMyA

PostPosted: 28. November 2012 15:46
by hackattack142
Simply go to the Users tab when you open PHPMyAdmin. There is not a privileges tab in the newer version on the main screen.

Re: Upgraded to v.1.8.1 and Privileges tab missing in phpMyA

PostPosted: 28. November 2012 16:44
by luismartin
There is no Users tab either.

Re: Upgraded to v.1.8.1 and Privileges tab missing in phpMyA

PostPosted: 29. November 2012 01:25
by hackattack142
Hmm, here are my next suggestions:
1. Try a different browser. I have seen people report issues with the Users tab missing while using Chrome
2. Make sure you are on the phpMyAdmin home (don't have any databases selected)
3. If you imported old server tables (information_schema, mysql, performance_schema, phpmyadmin) over new ones, that could potentially cause issues if the old version was significantly older and the table structure was different.

Re: Upgraded to v.1.8.1 and Privileges tab missing in phpMyA

PostPosted: 18. December 2012 13:02
by luismartin
Excuse the delay. I was temporarily using "root" with no password. I tried using Firefox and the Users tab appeared. It's just as you said, an issue with Chrome. I guess it's up to the phpMyAdmin programmers to get this issue fixed.

Thanks a lot for your help! By the way, great new graphic interface you made! :)