Permissions problem after 1.8 upgrade
Posted: 16. May 2013 13:30
Just upgraded to v 1.8 and I seem to be logged in as root@localhost (or similar) but I don't have permission to create either users or databases. How do I resolve? thanks
https://community.apachefriends.org/f/
https://community.apachefriends.org/f/viewtopic.php?f=16&t=54162
SELECT CURRENT_USER();
SHOW GRANTS;
bikeman wrote:@localhost
Altrea wrote:bikeman wrote:@localhost
Which simply means that you are logged in as anonymous user from host localhost.
Anonymous users surely doesn't have any permissions to create databases.
bikeman wrote:Ok thats fine but there must be a default admin user/password with full permissions for new installs so I can get started?
Altrea wrote:root@localhost
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
bikeman wrote:If I login as root with no password I end up as an anonymous user with no permissions.
bikeman wrote:I jumped strait to running 'resetroot.bat' and now it's fine.
bikeman wrote:I changed nothing, this is a untampered with new install.