Jump to content
The Uniform Server Community

What is the mysql password?


robster
 Share

Recommended Posts

Hi there, I have looked around, and I'm trying to do it, basically I found a commented out password in the my-small file, but uncommenting and changing that doesn't work.

 

What is the default mysql password, and how can i change it to my own?

 

Thanks :D

 

Rob

Link to comment
Share on other sites

  • 3 months later...

That is not suppose to happen. Please recheck to make sure. Nothing writes to that file so it is suppose to stay whatever it is changed to. Unless someone changed it back or messed with the file. :(

Link to comment
Share on other sites

No one has access to the server...

 

When setting a new password in the file only PhpMyAdmin changes it's password so I get an error message.

 

If I try to access the database using something else like Navicat using root/root it works altough the password file says something else (not Root).

Link to comment
Share on other sites

No, if you want to chnage the system root password, you have to do that through phpMyAdmin's Administration Interface. It is there that you change user settings, add users, and so on.

Link to comment
Share on other sites

  • 4 months later...
When setting a new password in the file only PhpMyAdmin changes it's password so I get an error message.

 

If I try to access the database using something else like Navicat using root/root it works altough the password file says something else (not Root).

 

This is how:

 

In phpMyAdmin, open an SQL window and type:

 

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPassword');

 

Then click "Go". The next thing you know, the phpMyAdmin will not work since the root password has changed -_- (then you need to change the password in the file previously mentioned - if you still want to use phpMyAdmin)

 

--

 

And btw olajideolaolorun,

 

You have a great software, thank you!

 

:)

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...