Koozali.org: home of the SME Server

Contribs.org Forums => General Discussion => Topic started by: dazza0101 on December 31, 2007, 06:06:38 AM

Title: Installed phpmyadmin,newby don't know how to change default password.
Post by: dazza0101 on December 31, 2007, 06:06:38 AM

Hi,

Sorry guys, if this is not the appropriate place to ask this question :???:, but I am in need of a quick answer due to my problem being a security risk.

I installed phpmyadmin on my sme server.  Using the following code.

wget "http://www.vanhees.cc/index.php?name=CmodsDownload&file=index&req=getit&lid=296"
yum localinstall smeserver-phpmyadmin-multiuser-*.noarch.rpm

The installation went smoothly, and I logged into phpmyadmin using the default username and password admin,admin, but I cannot work out how to change the default logging username and password.

Any help would be greatly appreciated,

Thank you Darren.

Title: Re: Installed phpmyadmin,newby don't know how to change default password.
Post by: raem on December 31, 2007, 06:28:28 AM

dazza0101

Carefully read all of
http://wiki.contribs.org/Phpmyadminmulti

Title: Re: Installed phpmyadmin,newby don't know how to change default password.
Post by: dazza0101 on December 31, 2007, 07:10:45 AM

Hi RayMitchell, and thank you for your quick reply, I really appreciate it.

Being a newby at this stuff and I can be a little thick at times :D, I cannot find on the link that you provided, any think that clearly indicates to me how to change my login username password.  I think I need it explained to me in newby terms :sad:, it is unusual for me to ask for help, I usually just keep at it until I have sorted it out one-way or another usually the hard way :D, but this problem needs to be sorted out as soon as possible :shock:.

Thank you,

Darren.

Title: Re: Installed phpmyadmin,newby don't know how to change default password.
Post by: raem on December 31, 2007, 07:42:02 AM

dazza0101

Forgive me for asking, but are you blind ?

Utilisation

You can access phpmyadmin interface by opening your web browser at the address: https://[IP or DOMAIN]/myadmin

A login and a password is needed to connect. By default, the installation process creates a user "admin" with "admin" as password.

Of course, the first thing you have to do, is change the admin password.

Use the following commands (replace newpassword with your actual desired admin password).

You can also use the same commands to reset the admin password to admin, if you have any problems connecting (ie replace newpassword with the word admin). You must be logged in as the root user.

mysql --execute="grant all privileges on *.* to admin@localhost identified by 'newpassword' WITH GRANT OPTION"
mysql --execute="flush privileges"

Title: Re: Installed phpmyadmin,newby don't know how to change default password.
Post by: dazza0101 on December 31, 2007, 11:51:40 AM

Thank you RayMitchell got it sorted, I do understand why you asked if I was blind.

I did read through very careful, I just simply didn't understand :oops:, in your previous post you pointed out to me what I needed to do, and made it a little more clearer how to do it :razz:.  I am learning and I do find it very difficult, but I do find it even harder to give up :D.

Thank you once again RayMitchell.

Darren.