Page 1 of 1

Getting back in to admin account for PHPMyAdmin

PostPosted: 29. November 2010 20:59
by Fulcrum97
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?

Re: Getting back in to admin account for PHPMyAdmin

PostPosted: 30. November 2010 00:45
by Sharley
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.

Re: Getting back in to admin account for PHPMyAdmin

PostPosted: 06. December 2010 06:41
by Fulcrum97
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.

Re: Getting back in to admin account for PHPMyAdmin

PostPosted: 06. December 2010 09:32
by JonB
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)

Re: Getting back in to admin account for PHPMyAdmin

PostPosted: 21. February 2011 09:12
by AndreISRS
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. :?

No connection,

PostPosted: 25. February 2011 14:38
by gamma1791
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

Re: Getting back in to admin account for PHPMyAdmin

PostPosted: 26. February 2011 22:02
by bloohair
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?
:(

Re: No connection,

PostPosted: 26. February 2011 23:20
by WilliL
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

Re: Getting back in to admin account for PHPMyAdmin

PostPosted: 27. February 2011 13:51
by bloohair
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.

Re: Getting back in to admin account for PHPMyAdmin

PostPosted: 27. February 2011 20:54
by WilliL
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..