Root user phpmyadmin

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

Root user phpmyadmin

Postby chihwahli » 23. May 2010 12:38

Hello,

I installed Xampp in windows vista 32 bit.
Everything is working, until I did the following:

Because I could add another user with full permissions, I made one then deleted the root user.
Now I cannot access phpmyadmin from: http://localhost/phpmyadmin

Two questions:
1) Why has the root user no password? (This is the reason I delete the root user, and tried to add my own super user. Or is it not important that the root user has no password?
2) The phpadmin uses the root user to login?? Can I use my own super user by changing a file? Or should I add the root back back somehow?
And how can I do this?

Thanks!
Last edited by chihwahli on 23. May 2010 14:22, edited 1 time in total.
chihwahli
 
Posts: 6
Joined: 23. May 2010 12:28

Re: Root user phpmyadmin

Postby BigWetDog » 23. May 2010 13:00

Have you taken a look at the xampp for windows faq here: http://www.apachefriends.org/en/faq-xam ... #password2
User avatar
BigWetDog
 
Posts: 148
Joined: 25. February 2010 15:54

Re: Root user phpmyadmin

Postby chihwahli » 23. May 2010 14:55

Thanks for replying.

Well, it's not about a password problem, the problem is that inside Xampp where you can add users for the database, I deleted the root user!
With shell commands to set the root cannot be used to create the root user again right?

So the shell command to set the password can never help, right?I --> mysqladmin.exe -u root password secret

Is there any way to recover from the root user deletion?
chihwahli
 
Posts: 6
Joined: 23. May 2010 12:28

Re: Root user phpmyadmin

Postby BigWetDog » 23. May 2010 19:05

I understan, I was just thinking that if you updated the config to use your new user/password instead of root, it might get you back up and running.
User avatar
BigWetDog
 
Posts: 148
Joined: 25. February 2010 15:54

Re: Root user phpmyadmin

Postby chihwahli » 23. May 2010 21:55

There is another thing I noticed:
The config.inc.php file may not be altered with Windows notepad is that right?
I tried it with a working config.inc.php file, then I altered it with notepad and I get an error, that phpmyadmin cannot read the file.
Any suggestions what kind of editor I could use without problems?

I have windows 7 64bit OS
chihwahli
 
Posts: 6
Joined: 23. May 2010 12:28

Re: Root user phpmyadmin

Postby MC10 » 24. May 2010 00:30

Use Notepad++. Notepad creates a BOM.
MC10
 
Posts: 148
Joined: 20. February 2010 20:13

Re: Root user phpmyadmin

Postby chihwahli » 24. May 2010 10:11

I downloaded notepad++ and winvi, tried winvi, works good, I can edit without problems. Thanks!

More questions =)

Question 1:
I recovered from my mistake by copying all xampp files from a fresh install and recreated my SQL database from scratch, I just started, the amount of data was zero bytes.
But if I forgot my database login info, is there any way to recover them?

Question 2:
Which files are important to backup? And which SQL file(s) are that? (config.inc.php, ..... )

Question 3:
I used the shell command mysqladmin.exe -u root password xxx
With this shell command I changed the root password from nothing to xxx.
I changed the config.inc.php to reflect this password xxx
logging in from browser: http://localhost/phpmyadmin works without problems.

But if I try to change the password to something else with the shell command, I get an error that I cannot to the server'.' failed.
error message: access denied for user 'root' @ 'localhost' (using password 'no'
Is there another file which Xampp uses to store passwords?

Thanks!
chihwahli
 
Posts: 6
Joined: 23. May 2010 12:28

Re: Root user phpmyadmin

Postby chihwahli » 27. May 2010 14:08

Log in problem solved by editing the config.inc.php file with notepad++ / winvi.
chihwahli
 
Posts: 6
Joined: 23. May 2010 12:28

Re: Root user phpmyadmin

Postby JonB » 27. May 2010 15:23

thanks for the resolution info, chiliwahli
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


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 49 guests