Servers and Hosting Server Issues - Shared, Virtual, and Dedicated Hosting Options.

Reply
 
Thread Tools

  #1  
Old 11-22-2005, 06:42 AM
sho sho is offline
TAZ Rookie
 
Join Date: Sep 2005
Admin Experience: Beginner
Posts: 26
sho is on a distinguished road
Changing phpmyadmin username and password
Hi,
Total tech newbie here... I don't know if I have posted this in the right place, or if the terms I use are correct...

I have taken over a message board as admin and owner after the former owner decided he wanted out. I have changed all usernames and passwords for hosting services, site management, admin access, domain ownership etc, but I can't find a way to change the username and password for phpmyadmin. I of course really want to and need to do that to make sure the old owner doesn't have access to the database.

I have heard that changing this username and password might... change other things and affect the database or the site or something... Could you tell me what would happen if and when I change the username and password? I am terrified of screwing something up!

How can I change the password and username... and what will happen when I do so... Please help
sho
Reply With Quote
  #2  
Old 11-22-2005, 10:42 AM
Oldiesmann's Avatar
Oldiesmann Oldiesmann is offline
SMF Lead Developer
 
Real Name: Michael
Join Date: Oct 2005
Admin Experience: Advanced
Location: Cincinnati, Ohio
Age: 31
Posts: 1,976
Oldiesmann is a glorious beacon of lightOldiesmann is a glorious beacon of lightOldiesmann is a glorious beacon of light
Default
You need to change the values for the $cfg['Servers'][$i]['user'] and $cfg['Servers'][$i]['passwd'] in phpMyAdmin's config file. Before you do that though, look at the value for $cfg['Servers'][$i]['auth_type']. If it's "config", then go ahead and change the username and password to whatever you want. If it's "cookie" or "http", then you need to create a new MySQL user account before you change those values.
__________________
Michael "Oldiesmann" Eshom
SMF Webmaster
Archie Comics Fan Forum - Portal, Gallery, Arcade and much more!
SMF+Gallery2 - 1.0 now available! (includes SMF 2.0-2.0.2 support)
Reply With Quote
  #3  
Old 11-22-2005, 03:05 PM
sho sho is offline
TAZ Rookie
 
Join Date: Sep 2005
Admin Experience: Beginner
Posts: 26
sho is on a distinguished road
Default
thank you for replying, but unfortunately i have no idea how to use your info *cries*

when i say total tech newbie, i mean total tech newbie

*cough* where is the phpMyAdmin config file...?
sho
Reply With Quote
  #4  
Old 11-22-2005, 04:37 PM
sho sho is offline
TAZ Rookie
 
Join Date: Sep 2005
Admin Experience: Beginner
Posts: 26
sho is on a distinguished road
Default
i'm trying to dig around as much as i can, but i'm not getting any wiser

when i log into phpMyAdmin with the former owner's password and username i get: "Welcome to phpMyAdmin 2.2.6.
MySQL 3.23.54 running on localhost as [former owner]@localhost
when i go to [my domain].com/config.inc.php3 i get the message that "The requested URL was not found on this server".

i know it must be hard to even begin to explain things to me without wanting to , but i'd really appreciate it.
sho
Reply With Quote
  #5  
Old 01-04-2006, 10:41 PM
xxcite81 xxcite81 is offline
TAZ Rookie
 
Join Date: Jan 2006
Posts: 1
xxcite81 is on a distinguished road
Default
What you need to do is to look in the phpmyadmin folder to see if there is a config.default.php. if there is coopy it andd rename to config.inc.php, then u can edit as explained above.

If you cant a popup to ask for the password change the auth_type to http or change to cookie if u want a web login.
Reply With Quote
  #6  
Old 04-21-2010, 07:02 PM
teknohan teknohan is offline
TAZ Rookie
 
Join Date: Apr 2010
Posts: 3
teknohan is on a distinguished road
Default
I really need some help about phpmyadmin I changed name and password but problem it was cookie and it doesn`t wor
I changed like this

/*
* Generated configuration file
* Generated by: phpMyAdmin 3.2.2.1 setup script by Piotr Przybylski <piotrprz@gmail.com>
* Date: Wed, 21 Apr 2010 23:53:13 +0300
*/

/* Servers configuration */
$i = 0;

/* Server: localhost [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = '';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'teknohan';
$cfg['Servers'][$i]['password'] = '******';

/* End of servers configuration */

$cfg['blowfish_secret'] = '4bcf6571f30ef0.33299549';
$cfg['DefaultLang'] = 'en-utf-8';
$cfg['ServerDefault'] = 1;
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';

it was like that
<?php
/*
* Generated configuration file
* Generated by: phpMyAdmin 2.8.1 setup script by Michal Čihař <michal@cihar.com>
* Version: $Id: setup.php,v 1.23.2.8.2.2 2006/05/15 07:57:09 nijel Exp $
* Date: Sat, 27 May 2006 17:10:09 GMT
*/

/* Servers configuration */
$i = 0;

/* Server localhost (cookie) [1] */
$i++;
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['auth_type'] = 'cookie';

/* End of servers configuration */

$cfg['blowfish_secret'] = '44aswedwed232';
?>
Reply With Quote
  #7  
Old 04-24-2010, 11:01 PM
HostColor HostColor is offline
TAZ Regular
 
Join Date: Apr 2008
Posts: 63
HostColor is on a distinguished road
Default
If you are under shared hosting account, you can easily change your MySQL password through your control panel(the MySQL username's password is your phpMyAdmin password aswell).

Assuming you are on a VPS or a server without a control pane, then you can change your MySQL username through the phpMyAadmin, there is no need to change any configuration files. Just log in to your phpMyAadmin(reading your initial post I assume you have access) -> Select your forum database by clicking on its name on the left tab -> Privileges -> Locate the user from the table and lick on the icon under "action" tab(check the screen bellow for clearer orientation) -> On the new page that opens, scroll down a bit and you should see the fields under "Change Password" -> Enter your new password twice and click on the "Go" button.


Have in mind that by changing the MySQL username or password, you will need to edit your forum's configuration file which specifies the database info with the new credentials.

Please let us know if this helped you out.
__________________
Host Color - Dedicated Servers & Colocation
Data Centers in the U.S. and Europe
Higher standards in web hosting since 2000
Reply With Quote
  #8  
Old 04-26-2010, 03:30 AM
WebhostGIANT_Rob WebhostGIANT_Rob is offline
Tazmanian
 
Real Name: Rob
Join Date: Mar 2010
Posts: 365
WebhostGIANT_Rob is on a distinguished road
Default
Quote:
If you are under shared hosting account, you can easily change your MySQL password through your control panel(the MySQL username's password is your phpMyAdmin password aswell).
I'm absolutely agree with this statement. Moreover I'm sure you need to contact youe provider and ask them to help you. I'm seeing that is very vital for you so do not hesitate to contact them.
Reply With Quote
  #9  
Old 04-27-2010, 11:01 AM
teknohan teknohan is offline
TAZ Rookie
 
Join Date: Apr 2010
Posts: 3
teknohan is on a distinguished road
Default
if I don`t know that you would help me but I said I can`t enter to phpmyadmin but problem sold solition was about linux system they made a different way to have a password I use it and I use a inux system named pardus if you wonder I can help but not really good for php server or something like that
Reply With Quote
  #10  
Old 04-28-2010, 05:51 AM
WebhostGIANT_Rob WebhostGIANT_Rob is offline
Tazmanian
 
Real Name: Rob
Join Date: Mar 2010
Posts: 365
WebhostGIANT_Rob is on a distinguished road
Default
Quote:
Originally Posted by teknohan View Post
if I don`t know that you would help me but I said I can`t enter to phpmyadmin but problem sold solition was about linux system they made a different way to have a password I use it and I use a inux system named pardus if you wonder I can help but not really good for php server or something like that
If you do not know how exactly to do that why you offer your help in here?
Reply With Quote
  #11  
Old 04-29-2010, 04:27 AM
teknohan teknohan is offline
TAZ Rookie
 
Join Date: Apr 2010
Posts: 3
teknohan is on a distinguished road
Default
Quote:
Originally Posted by WebhostGIANT_Rob View Post
If you do not know how exactly to do that why you offer your help in here?
maybe I can't help you but there is an IRC system and they are really helping to users and they found the solution for me and it wasn't first.
Reply With Quote
  #12  
Old 02-20-2011, 01:03 AM
anu anu is offline
TAZ Rookie
 
Real Name: anu
Join Date: Feb 2011
Posts: 2
anu is on a distinguished road
Question how to find username and password
Quote:
Originally Posted by xxcite81 View Post
What you need to do is to look in the phpmyadmin folder to see if there is a config.default.php. if there is coopy it andd rename to config.inc.php, then u can edit as explained above.

If you cant a popup to ask for the password change the auth_type to http or change to cookie if u want a web login.
I follow ur instruction but in my config.default.php there is no password.... then can I dirctly write in that file or what is another way to set password???????
Reply With Quote
  #13  
Old 02-20-2011, 01:31 AM
anu anu is offline
TAZ Rookie
 
Real Name: anu
Join Date: Feb 2011
Posts: 2
anu is on a distinguished road
Default
Quote:
Originally Posted by HostColor View Post
If you are under shared hosting account, you can easily change your MySQL password through your control panel(the MySQL username's password is your phpMyAdmin password aswell).

Assuming you are on a VPS or a server without a control pane, then you can change your MySQL username through the phpMyAadmin, there is no need to change any configuration files. Just log in to your phpMyAadmin(reading your initial post I assume you have access) -> Select your forum database by clicking on its name on the left tab -> Privileges -> Locate the user from the table and lick on the icon under "action" tab(check the screen bellow for clearer orientation) -> On the new page that opens, scroll down a bit and you should see the fields under "Change Password" -> Enter your new password twice and click on the "Go" button.


Have in mind that by changing the MySQL username or password, you will need to edit your forum's configuration file which specifies the database info with the new credentials.

Please let us know if this helped you out.




Hurreeeeeeeeeeeeeeeeee
Its working thanks!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Reply With Quote
  #14  
Old 05-04-2012, 06:16 AM
yanique yanique is offline
TAZ Rookie
 
Real Name: Yanique
Join Date: May 2012
Posts: 1
yanique is on a distinguished road
Default Similar problem or reoccuring password changes, not fixable via phpMyAdmin
it seems to me like my situation cannot be fixed via phpMyAdmin.

I am not a techie - so maybe there is something I am missing.

The problem is I am sure that someone has hacked my site and changed the password. My site is still up, I just dont have access anymore, i cant login via wordpress.

So i;ve logged into my phpMyAdmin to try and change the password, but even when I do all the steps including making sure to check MD5, the saved password still goes back to a long string of characters that i never created.


can someone help me with this please!

or anyone with a similar problem?
Reply With Quote
  #15  
Old 05-04-2012, 02:48 PM
BHH BHH is offline
Tazmanian
 
Join Date: Feb 2010
Admin Experience: Guru
Posts: 196
BHH is a jewel in the rough
Default
Quote:
Originally Posted by yanique View Post
it seems to me like my situation cannot be fixed via phpMyAdmin.

I am not a techie - so maybe there is something I am missing.

The problem is I am sure that someone has hacked my site and changed the password. My site is still up, I just dont have access anymore, i cant login via wordpress.

So i;ve logged into my phpMyAdmin to try and change the password, but even when I do all the steps including making sure to check MD5, the saved password still goes back to a long string of characters that i never created.


can someone help me with this please!

or anyone with a similar problem?
Create a new thread instead of posting here.
Reply With Quote
  #16  
Old 07-28-2012, 02:21 PM
f3rv f3rv is offline
TAZ Rookie
 
Real Name: F3rv
Join Date: Jul 2012
Posts: 1
f3rv is on a distinguished road
Default
Hi, I need help, this is driving me crazy.

I have a backup of a Joomla website that I want to work on in MAMP PRO. When I launched phpmyadmin from MAMPís start page and I was creating the new database (I was automatically logged as root in localhost btw) I mistakenly unchecked all the privileges of the root user, and clicked go. Now I donít have any privileges at all, I cant see my other databases or see the other user I created, I donít even know how to change the user or log out so I can log in with another one, I donít know how to restore the privileges, Iím trapped just by a stupid mistake.

Please help.
Reply With Quote
Reply

  Admin Zone Forums > The Community Zone > Managing an Online Community > Servers and Hosting





Currently Active Users Viewing this Thread: 4 (0 members and 4 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


 

All times are GMT -4. The time now is 05:03 PM.


Powered by: vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Page generated in 0.10155010 seconds with 12 queries
The Admin Zone © copyright 2003-2014 All Rights Reserved. Content published on The Admin Zone requires permission for reprint.