Apache Friends Support Forum

Okay.. I changed my password from (blank) to ******, well, not literally
but anyways...
I can no longer access mysql through phpmyadmin, nor through my website (using phpbb forums)

Oh,
Windows 2000 computer, not running off of services.
Xampp version 1.4.11 (latest)
and uh..... thats it..

You must change the MySQL configuration for each application that use MySQL and notify them the new password.

I did, and my new username/password fail to work.

Edit: Also, I am trying to install phpbb forums, they have not been installed as of yet.
Next, I can access phpmyadmin with the username "Admin" while using " " for a password (blank), although I have no rights other than to view... I still cannot access with root

how can I get my my settings to be
Username: Root
Password: whatIwant

?

Here's one way:

Code: Select all

> mysqladmin -uroot password whatIwant

The command needs to be entered in a command prompt window that's in the directory containing mysqladmin.exe.

Rukie wrote:Okay.. I changed my password from (blank) to ******, well, not literally
but anyways...
I can no longer access mysql through phpmyadmin, nor through my website (using phpbb forums)

I have the exact same problem
So now WE need help

Okay. Here's how I solved this.
First, I completely removed xampp. Made sure nothing was left, had a clean install.
I then switched to PHP4 (you can leave in php5 if thats what you want)
I then proceeded to click on the "Security Tab." Afterwards, it tells you unsecure for pretty much everything.

I clicked on the http://localhost/security.phpthingymagiggy

A new page loaded askin for a new password for "root" fo rmysql, and a new username/password for loading the "xampp" folder.

I IGNORED the second half. I entered my password, test. I then entered "test" in the confirmed text space. I pressed submit. Nothing really happened.

A third text area appeared(I believe, but I am not sure anymore), asking for the "current" password. I entered "test". I then entered "test" for the next two text area's for my password, and hit submit.

It THEN said that 3 files had been updated. This had not happened to me before. It all seems to be working fine.

Rukie wrote:Okay. Here's how I solved this.
First, I completely removed xampp. Made sure nothing was left, had a clean install.
I then switched to PHP4 (you can leave in php5 if thats what you want)
I then proceeded to click on the "Security Tab." Afterwards, it tells you unsecure for pretty much everything.

I clicked on the http://localhost/security.phpthingymagiggy

A new page loaded askin for a new password for "root" fo rmysql, and a new username/password for loading the "xampp" folder.

I IGNORED the second half. I entered my password, test. I then entered "test" in the confirmed text space. I pressed submit. Nothing really happened.

A third text area appeared(I believe, but I am not sure anymore), asking for the "current" password. I entered "test". I then entered "test" for the next two text area's for my password, and hit submit.

It THEN said that 3 files had been updated. This had not happened to me before. It all seems to be working fine.

It worked for me...

Thanks.