No Privileges on a Fresh Installation

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

No Privileges on a Fresh Installation

Postby jordanmc » 28. October 2010 07:08

I just installed XAMPP and after changing the MySQL password (and choosing to set 'random' password for pma and dump them both to text files) I am unable to connect to the database.

phpmyadmin just says "No Privileges" and there doesn't appear to be anyway to say, update the password or get more specific error information.

To be sure it wasn't a problem with an unclear uninstall of XAMPP (long story), I tried installing it in A VM (VMWare from University License) of Windows 7 Professional (From MSDNAA) which only has a few programs installed (I can't honestly remember why I needed to run a Windows 7 VM within Windows 7... ) and has never had XAMPP Installed on it before.

I even tried installing it into a Ubuntu VM and setting the passwords, and it still says "No Privileges".

I can get either set up to work by not changing the security settings, but that's simply not helpful.

Am I doing something wrong?

I am using Windows 7 Home Premium 64 bit.
jordanmc
 
Posts: 2
Joined: 28. October 2010 04:57

Re: No Privileges on a Fresh Installation

Postby JonB » 28. October 2010 19:33

Use the 'resetroot.bat' file in \xampp\mysql folder

make this change 1st

here is the little fix in english:
- open resetroot.bat file in your editor
- after the parameter "--no-defaults" add your mysql data directory with this syntax: --datadir=c:/xampp/mysql/data
- save the file
- execute the file

(thanks to Altrea)

That will reset the MySQL root and pma users to no password.
:D
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: No Privileges on a Fresh Installation

Postby Nobbie » 28. October 2010 21:25

JonB wrote:(thanks to Altrea) :D


You mean "thanks to Nobbie" ;)
Nobbie
 
Posts: 13165
Joined: 09. March 2008 13:04

Re: No Privileges on a Fresh Installation

Postby JonB » 28. October 2010 21:47

OK :) But Altrea was also the one who pointed it our to me. So thanks to Altrea and Nobbie

and I guess I will thank myself as I also worked it out independently (I found out it didn't work by testing things) - BUT it is still missing something I just found out by testing with a clean install,

that same line also needs this fix:

Edited -THIS FIX IS NOT NEEDED - Nobbie is correct

line starts

\mysql\bin\mysqld.exe but should start this way (complete line is given)

Code: Select all
c:\xampp\mysql\bin\mysqld.exe --no-defaults  --datadir=c:/xampp/mysql/data --bind-address=127.0.0.1 --bootstrap --console --skip-grant-tables --skip-innodb --standalone <resetroot.sql  >resetroot.err 2>&1


8)
Last edited by JonB on 30. October 2010 03:51, edited 1 time in total.
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: No Privileges on a Fresh Installation

Postby Nobbie » 28. October 2010 22:02

JonB wrote:that same line also needs this fix:

line starts

\mysql\bin\mysqld.exe but should start this way (complete line is given)


Not quite right - the line starts WITHOUT the leading backslash:

Code: Select all
mysql\bin\mysqld.exe --no-defaults ...


And some lines above there is a "CD ..", so when I double click the resetroot.bat in Explorer (or call it in a CMD Shell), it executes without error. Therefore i did not fix that, as it works without any problems. There is no need to apply the full pathname.
Nobbie
 
Posts: 13165
Joined: 09. March 2008 13:04

Re: No Privileges on a Fresh Installation

Postby jordanmc » 28. October 2010 22:51

This works (and also fixes the resetroot.bat) great! I was expecting it to break again as soon as I set the passwords, but it didn't, so we're good.

Line 18:
Code: Select all
mysql\bin\mysqld.exe --no-defaults --datadir=c:/xampp/mysql/data --bind-address=127.0.0.1 --bootstrap --console --skip-grant-tables --skip-innodb --standalone <resetroot.sql  >resetroot.err 2>&1
jordanmc
 
Posts: 2
Joined: 28. October 2010 04:57

Re: No Privileges on a Fresh Installation

Postby JonB » 29. October 2010 16:41

One final note:

I discovered why copying the \xampp\mysql\bin\my.ini to \xampp\mysql\data\my.cnf worked on one machine.

On that machine, I had modified the my.ini and created and experimented with additional 'profile' ini's so I could move the MySQL databases to and from my Centos Linux VPS I am building a project on - in doing that I had gotten the files to the point they were OS and location neutral.

CASE CLOSED

:D
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: No Privileges on a Fresh Installation

Postby Altrea » 29. October 2010 18:25

Nobbie wrote:
JonB wrote:(thanks to Altrea) :D


You mean "thanks to Nobbie" ;)

:D
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 10 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 151 guests