Jump to content
The Uniform Server Community
robster

What is the mysql password?

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

Share this post


Link to post
Share on other sites

After changing the password in home/admin/www, stoping and started the server again it kept working with the original password (root).

 

Any idea how to fix this or is there any other way to change the password?

Share this post


Link to post
Share on other sites

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. :(

Share this post


Link to post
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).

Share this post


Link to post
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.

Share this post


Link to post
Share on other sites
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!

 

:)

Share this post


Link to post
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...

×
×
  • Create New...