Root user phpmyadmin

[chihwahli]

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!

[BigWetDog]

Have you taken a look at the xampp for windows faq here: http://www.apachefriends.org/en/faq-xam ... #password2

[chihwahli]

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?

[BigWetDog]

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.

[chihwahli]

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

[MC10]

Use Notepad++. Notepad creates a BOM.

[chihwahli]

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]

Log in problem solved by editing the config.inc.php file with notepad++ / winvi.

[JonB]

thanks for the resolution info, chiliwahli