Default Password Change in Mysql Issue

[gopalv]

Hello,

I have set the default password for mysql on my local machine for the username ROOT.
Now, i m not able to access the phpmyadmin on my local system.
It is giving me the erroe "#1045 - Access denied for user 'root'@'localhost' (using password: NO) ".
Now, could you please help me with the steps from where I can set the password for my localhost mysql.
Waiting for urgent help.
Thanks.

[Nobbie]

Edit config.inc.php in folder phpmyadmin and apply the password (you will see the appropriate line).

or

Edit config.inc.php and change auth_type from "config" to "cookie". If you do so, you will get a login dialog upon startup of phpmyadmin, enter "root" and the new password.

[Christina_Juanito]

Hello,

I have the exact same problem and cannot do anything to fix it.
I am a learner on site building and programming and do not have
much knowledge for problem solving of this type yet.

I tried what you wrote, but the file "phpmyadmin" does not let me
to edit it, as it seems to be locked along with the database…
(read only)

I would appreciate a response by someone from the administrators,
as nothing I have read, nor any improvising of mine has done any good.

Thank you in advance,

Christina



PS: My XAMPP Version actually is 5.6.8-0, but this choice did not exist
on your list

[Christina_Juanito]

I have at last managed to reverse the password
and I am posting the procedure here for anyone with the
same problem:


1. Make sure the servers (Apache Web Server,MySQL, ProFTPD) are running
2. Go through Finder on Mac to
- Applications -> XAMPP -> bin -> mysqladmin (it's a Unix Executable File, open it)
- The terminal you opened describes the basic commands you can use and other info
which I do not comprehend at the time
- With Cmnd+N or Shell -> New Command you are opening a new command window
(it is actually the same procedure you did to change the password at the first time)

- Type
/Applications/XAMPP/bin/mysqladmin --user=root --password=thepasswordyouenteredbefore password ""

and push enter

* the password you entered before without "" around it
* the "" section is for returning to not having a password, that' s why we type nothing inside the "" .
* After this you go again in "No security mode" and I do not know yet how to apply security, but I guess I
will find out soon. At least the nightmare of access denied is over...

It' s done!
It gives you the following warning:

Warning: Using a password on the command line interface can be insecure.


Now you can enter your phpMyAdmin again !

[Nobbie]

I tried what you wrote, but the file "phpmyadmin" does not let me
to edit it, as it seems to be locked along with the database…
(read only)

There is no file "phpmyadmin", that is a folder. Inside that folder is a file config.inc.php which you should edit (see my post above). If it is read only for your UserID, you can start the editor via "sudo".

[chiericitom]

i solved....
i've edited config.inc.php i've put my database's user and my password and now i see all my databases!

[skd]

Hi, I am unable to edit that php file. How did you edit it?

[Nobbie]

You must open it with an "editor", the standard Windows Editor is called "notepad.exe". On OSX there seems to be a tool called "textedit". If unsure, proceed to an OSX forum and ask there for an OSX text editor.