Getting back in to admin account for PHPMyAdmin

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Getting back in to admin account for PHPMyAdmin

Postby Fulcrum97 » 29. November 2010 20:59

When installing xampp, I got it done successfully and the /xampp folder had me lock it down, along with MySQL and phpmyadmin.

All is fine with that, accept now, with PHPmyadmin, I can only login to certain databases (such as the default user it forces you to make 'pma').

I can no longer login to create new SQL databases or anything.

Anyone know how to resolve this?
Fulcrum97
 
Posts: 5
Joined: 29. November 2010 20:48

Re: Getting back in to admin account for PHPMyAdmin

Postby Sharley » 30. November 2010 00:45

Try and access it using the default super user root with no password.

Type root in the username box and leave the password blank.

If you can get in then return to the Security page and set a password for user root.

Then make sure you can access again using root and the password you set.

When ever you change anything server related please restart the server and try again.
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: Getting back in to admin account for PHPMyAdmin

Postby Fulcrum97 » 06. December 2010 06:41

Hmm, here is what I got:

#2003 - Can't connect to MySQL server on 'localhost' (10061)

#1045 - Access denied for user 'root'@'localhost' (using password: NO)

I do remember being able to get in earlier though and then it asked me to lock it down. Unfortunately, I can no longer login as "root". I can only login based on the separate databases themselves. Very weird.
Fulcrum97
 
Posts: 5
Joined: 29. November 2010 20:48

Re: Getting back in to admin account for PHPMyAdmin

Postby JonB » 06. December 2010 09:32

Try this tip (it resets the root and pmauser passwors to null) to fix:

http://bravo.newnetenterprises.com/word ... -password/

It's a fix for 'resetroot.bat' + explanatory notes.

Good Luck
8)
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: Getting back in to admin account for PHPMyAdmin

Postby AndreISRS » 21. February 2011 09:12

Thanks for getting back to me Jon.

Unfortunately it still does not work. After resetting my password (even used command prompt for this) it shows in xampp security -
"The MySQL admin user root has no longer no password SECURE" , still secure...

The same error as above (first post) still shows when I try and use phpMyAdmin.

Is there any way to remove the root entirely and then re-install xampp where I can set the passwords again? When I re-installed xampp yesterday, it does not take me to the 'Set super user' screen where I can set the password. I can only do this via the xampp screen under security, which still does not change the password.

I don't mind loosing all the data, it is all new and are only used for testing, so I can re-install everything. :?
AndreISRS
 
Posts: 2
Joined: 20. February 2011 14:20

No connection,

Postby gamma1791 » 25. February 2011 14:38

I followed a complete tutorial from youtube of Mr rivercitygraphix.
It seemed to me all quite simple. I have connection to xampp page, but on the security page it referred to a xampp security file, which does not exist on my HD, so I could not set my new password, plus the page itself showed a simple mysql_connect.php content like this


$db_host = "localhost";
$db_username = "root";
$db_pass = "root";
$db_name = "test_database";

@mysql_connect("$db_host","$db_username","db_pass") or die ("Connection failed, could not connect to the mysql.");
@mysql_select_db("$db_name") or die ("could not find the database.");

echo " The connection is successfully working, and the database is found.";


But neither the xampp nor MAMP/Netbean could not show me the required result.
the database is properly created through the phpadmin.
Any idea????
Thnx in advance
gamma1791
 
Posts: 1
Joined: 25. February 2011 14:22

Re: Getting back in to admin account for PHPMyAdmin

Postby bloohair » 26. February 2011 22:02

I am having the same problem.
I'm actually not very impressed with XAMPP at the moment. I have been doing web design for 11 years and have over 20 years setting up and installing programmes, so I am completely flummoxed and getting very frustrated.
I set up XAMPP fine, put all the passwords in place and went into localhost/phpmyadmin for the fitst time and it said that I hadn't given MySQL protection (I had) but to go back and put the security in place. So I did this and now cannot get into phpmyadmin for love nor money.
I downloaded XAMPP 2.1 today.
I've been getting error "1045 using password YES and NO" whether I put the password in or leave it blank.
I found a tip online to enter the password manually into the config.inc.php file which I did, but this didn't work either.
I have just tried the tip here to type 'root' as user name and leave the password blank - still didn't work.
Please can someone help?
:(
bloohair
 
Posts: 3
Joined: 26. February 2011 21:47

Re: No connection,

Postby WilliL » 26. February 2011 23:20

gamma1791 wrote:$db_host = "localhost";
$db_username = "root";
$db_pass = "root";
$db_name = "test_database";

@mysql_connect("$db_host","$db_username","db_pass") or die ("Connection failed, could not connect to the mysql.");
@mysql_select_db("$db_name") or die ("could not find the database.");

i don't think it's a good idea to hide error messeges on developing ..
@ is an order to hide errors!
after looking in xamp_folder/apache/logs/php_error.log I would try
Code: Select all
$db_host =  "localhost";
$db_username =  "root";
$db_pass =  "root";
$db_name =  "test_database";

mysql_connect("$db_host","$db_username","db_pass"); // or die ("Connection failed, could not connect to the mysql.");
echo "<br> erg - ".mysql_errno(). ": " . mysql_error()."<br>";

mysql_select_db("$db_name"); // or die ("could not find the database.");
echo "<br> erg - ".mysql_errno(). ": " . mysql_error()."<br>";

then you should find a hint where to look
Willi
WilliL
 
Posts: 661
Joined: 08. January 2010 10:54
Operating System: Win7Home Prem 64 SP1

Re: Getting back in to admin account for PHPMyAdmin

Postby bloohair » 27. February 2011 13:51

WilliL, thanks for the help. I have actually uninstalled XAMPP - fortunately I have an Apple Mac, so I'm going to do the whole thing again on there and hope I don't come across any other issues.

As a web designer of 11 years standing, I think I need to join the crowd producing WordPress and other sites along side my hand-crafted (beautiful and unique) websites in case I get left behind.

This problem installing passwords for XAMPP has been a huge disappointment and wasted so much of my time, that I would beg the programme developers to try and rectify this problem as it seems I am not alone.
bloohair
 
Posts: 3
Joined: 26. February 2011 21:47

Re: Getting back in to admin account for PHPMyAdmin

Postby WilliL » 27. February 2011 20:54

bloohair wrote:As a web designer of 11 years standing, I think I need to join the crowd producing WordPress and other sites along side my hand-crafted (beautiful and unique) websites in case I get left behind.

This problem installing passwords for XAMPP has been a huge disappointment and wasted so much of my time, that I would beg the programme developers to try and rectify this problem as it seems I am not alone.

OMO it's a big difference between web design and server design - and xampp is a server package with own/other rules..
Whenn I downloaded XAMPP, I would like to do some web design with php. But most time I had to learn sth about server parts to get my local scripts working: apache, mercury/sendmail, mysql, filezilla and seurity..
Willi
WilliL
 
Posts: 661
Joined: 08. January 2010 10:54
Operating System: Win7Home Prem 64 SP1


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 52 guests