Permissions problem after 1.8 upgrade

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Permissions problem after 1.8 upgrade

Postby bikeman » 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
bikeman
 
Posts: 11
Joined: 26. May 2005 14:41

Re: Permissions problem after 1.8 upgrade

Postby Altrea » 16. May 2013 18:00

Access the phpmyadmin SQL tab, execute this two statement and post the results of each
Code: Select all
SELECT CURRENT_USER();
SHOW GRANTS;
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: Permissions problem after 1.8 upgrade

Postby bikeman » 20. May 2013 12:06

@localhost

GRANT USAGE ON *.* TO ''@'localhost'
bikeman
 
Posts: 11
Joined: 26. May 2005 14:41

Re: Permissions problem after 1.8 upgrade

Postby Altrea » 20. May 2013 12:45

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.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: Permissions problem after 1.8 upgrade

Postby bikeman » 06. June 2013 11:19

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.


Ok thats fine but there must be a default admin user/password with full permissions for new installs so I can get started?
bikeman
 
Posts: 11
Joined: 26. May 2005 14:41

Re: Permissions problem after 1.8 upgrade

Postby Altrea » 06. June 2013 12:08

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?

root@localhost
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: Permissions problem after 1.8 upgrade

Postby bikeman » 19. June 2013 23:07

Altrea wrote:root@localhost


No password?

If I login as root with no password I end up as an anonymous user with no permissions.

I've been using Xampp for a long time. I upgraded to 1.8 sometime ago and things have changed so now I cant even create a database. Trying to get some basic info to resolve this has been like extracting teeth. Please simply tell me how do I login as root. Thank you.
bikeman
 
Posts: 11
Joined: 26. May 2005 14:41

Re: Permissions problem after 1.8 upgrade

Postby hackattack142 » 20. June 2013 00:13

Hello,

By default, the root account does not have a password. Assuming you did not set one manually, you did not set one via the XAMPP security page, something you or someone else did did not set one, you did not import old mysql primary databases (the MySQL database with users table), you did not change any settings, and Apache and MySQL are both running, you should be able to go to http://localhost/phpmyadmin and be logged in as root automatically.

Alternatively you could use the command line mysql client.

You could try setting a password via the XAMPP Security Page (http://localhost/security/index.php)

Another thing you could try is changing the phpMyAdmin auth type in /xampp/phpmyadmin/config.inc.php
from
Code: Select all
$cfg['Servers'][$i]['auth_type']     = 'config';
to
Code: Select all
$cfg['Servers'][$i]['auth_type']     = 'cookie';


If all else fails, you could try running /xampp/mysql/resetroot.bat to remove any root password (make sure MySQL is off when running this).

If that still does not work for you, you will need to provide more details as to what you changed from the default configuration.
XAMPP Control Panel Developer
Latest CP: viewtopic.php?f=16&t=48932
hackattack142
 
Posts: 701
Joined: 20. May 2011 23:29
Operating System: Windows 7 Ultimate SP1 64-Bit

Re: Permissions problem after 1.8 upgrade

Postby bikeman » 20. June 2013 09:20

I changed nothing, this is a untampered with new install.

I jumped strait to running 'resetroot.bat' and now it's fine.

I am glad it's resolved but still don't understand why this happened.
bikeman
 
Posts: 11
Joined: 26. May 2005 14:41

Re: Permissions problem after 1.8 upgrade

Postby Altrea » 20. June 2013 10:31

bikeman wrote:If I login as root with no password I end up as an anonymous user with no permissions.

There are only two situations this can happen (As requirement there must be an anonymous user for that host or any host):
  • Your request is not matching with the host (localhost)
  • the specific username is not existent

If the username would be existent and the host matches, but the password is not, then your login attempts would be denied.

bikeman wrote:I jumped strait to running 'resetroot.bat' and now it's fine.

Thats another hint that the user wasn't existent any more.
This resetroot.bat file containy REPLACE Database statement that will recreate / insert the user if it is not existent.

bikeman wrote:I changed nothing, this is a untampered with new install.

Did you try to install XAMPP over another existing XAMPP installation?
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 141 guests