This applies to xampp-1.5.3a:
(don’t know about other versions since I only have this one. It works also for xampplite)
Yes, after a fresh install of a xampp program you are welcomed with a xampp pseudo website which is located in <path of xampp installation>/htdocs/xampp/. Clicking security you are given some important points to secure your website. That includes changing the root password. But alas, after changing it you’ll not be given a chance to use the ever-friendly phpMyAdmin.
Find <path of xampp installation>/htdocs/xampp/phpmyadmin/config.inc.php
$cfg['Servers'][$i]['password'] = ”; // MySQL password
Change this so that it’ll reflect your current mysql password.
$cfg['Servers'][$i]['password'] = ‘your_password_here‘; // MySQL password
Don’t forget to save it aight?!
And if you read furthermore you can see that you can also restrict/assign a mysql user with just enough privilege to access the database. :)
Pingback: restrict access to phpMyAdmin by authentication « me looking so small in this world
It worked for me too.. Only 3 simple steps.
1) Go to the directory C:\xampp\phpMyAdmin and open the file config.inc.php
2) Then find the line 21 and change it to (123456 is my mysql root password)
$cfg['Servers'][$i]['password'] = ‘123456′;
3) Then find the line 34 and change it to
$cfg['Servers'][$i]['controlpass'] = ‘123456′;
4) Save the file. Then try to refresh the mysql page. This must work in most cases..
Simple and Precise, two thumbs up…
I hv same problem, im linux user, the director config.inc.php is found in <my computer/file system/etc/phpmyadmin/config.inc.php.
i saw $cfg['Server'][$i]['password'] written that $cfg['Server'][$i]['AllowNopassword'] =True
I tried to put mine and save there is massage displaye"acces denied" what can i do now pls hep me!
can anyone tell me how i can reset root password?
someone accidentaly change the password withing phpmyadmin and of course that did not match with mysql password which is empty by default on root….
i tried this http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html but it kinda hangs…
a step by step would be helpful…PLEASE HELP!!!!!!!!!
find the config.inc.php with the installation of your phpmyadmin and set the $cfg[’Servers’][$i][’password’] = ‘your_password_here‘; your_password_here to blank if your root password is still blank.
if this didn’t work please describe your problem in detail.
you can change the root password in phpmyadmin by visiting the url of your phpmyadmin installation and clicking privileges.. after that find the user root and click the edit icon to the part of that line.. then you can change the password and privileges with the root..
English is not my native tounge so if you still have questions please do reply again.
Hope that helps.
this is my problem:
my college tried to secure databases in phpmyadmin by putting a password via phpmyadmin. the root was blank.
even if we still know the password, when i try to login with that password i get this error:
#1045 – Access denied for user ‘pma’@'localhost’ (using password: NO)
i went to config-inc.php to try to redifine the password but no success.
so i don’t know how to access my databases anymore.
is there anyway to restore that password or is there a workaround for this so that i don’t lose my data.
PS: i can still open my pages and produce my reports ….so that database are still accessible with my php codes but i can SEE the databases!!
hope you understand now…otherwise let me know…HEEEELP!
Hey i got an answer…
i put the same password in $cfg['Servers'][$i]['controlpass'] and it worked….
apparently the password that was changed was ‘pma’ password… by default it’s empty in config.inc.php……..remember i am new in php and mysql stuff,,,,
thanks for trying to help
There you go.. some searching and creativity would bring forth success.. thanks again for commenting..
I am using xampp for linux 1.5.5a.
Do you have any ideas why in phpMyAdmin I cannot create any new databases?
Create new database:
No Privileges
Thanks
do you own the database/os that it is running on? or is it on hosting?
have installed it on linux with no problems at all
have you changed root password for mysql?
if so check this /opt/lampp/phpmyadmin/config.inc.php
Hi Rudy
I am kind of new to Linux and Lampp. I installed puppy linux and lampp. I haven’t created any new users, but changed all the passwords. When i go to phpMyAdmin, I dont see any previleges to create database. I am trying to install mambo and mambo couldn’t create the database using the default username, pma. Any ideas? PS: I did changed the root password for mysql going to the file, config.inc.php
Thanking you
Jerry
Thanks Jerry for visiting.
Try setting
$cfg['Servers'][$i]['auth_type'] = ”;
to
$cfg['Servers'][$i]['auth_type'] = ‘cookie’;
It will then ask for your username and password and enter the necessary credentials.
Hit back again if this didn’t solve the problem.
Hey, Its worked for me in my Windows pc with wamp..
I tried hard to get solution and u gave me..thanks a lot dear ..
Thanks a million, i tried everything and that finally did it!
Thankyou rudy for your reply. I resolved it creating a new mysql user name and password using the GRANT command, giving full previleges.
how to change root password in phpmyadmin with mysql server.
when i changed the password then phpmyadmin shows an error :
#1045-Access denied for user: ‘root@localhost’ (Using password: Yes)
please reply the solution
into the sql tab on phpmyadmin or in console:
UPDATE user SET Password=PASSWORD(’newrootpassword’) WHERE User=’root’;FLUSH PRIVILEDGES;
great job man, it worked
Plz help me .. i was deleting pma account from xampp(phpmyadmin pannel) ,when i enter to d phpmyadmin showed me error is :
#1045 – Access denied for user ‘pma’@'localhost’ (using password: NO)
Otherway how can i creating database without phpmyadmin in xampp ?
i am begineer.
You can still use the command prompt to create databases.
More information for this here: http://dev.mysql.com/doc/refman/5.1/en/database-use.html
Basically there are 3 database instances which holds data for PHPMyAdmin which did you deleted?
Can you still log in mysql? If so go to your installation directory(I am assuming you are using windows in command line.
Issue this command:
mysql -uroot -p
Paste this:
/*Data for the table `user` */
insert into `user`(`Host`,`User`,`Password`,`Select_priv`,`Insert_priv`,`Update_priv`,`Delete_priv`,`Create_priv`,`Drop_priv`,`Reload_priv`,`Shutdown_priv`,`Process_priv`,`File_priv`,`Grant_priv`,`References_priv`,`Index_priv`,`Alter_priv`,`Show_db_priv`,`Super_priv`,`Create_tmp_table_priv`,`Lock_tables_priv`,`Execute_priv`,`Repl_slave_priv`,`Repl_client_priv`,`Create_view_priv`,`Show_view_priv`,`Create_routine_priv`,`Alter_routine_priv`,`Create_user_priv`,`ssl_type`,`ssl_cipher`,`x509_issuer`,`x509_subject`,`max_questions`,`max_updates`,`max_connections`,`max_user_connections`) values (‘localhost’,'pma’,”,’N',’N',’N',’N',’N',’N',’N',’Y',’N',’N',’N',’N',’N',’N',’N',’N',’N',’N',’N',’N',’N',’N',’N',’N',’N',’N',”,”,”,”,0,0,0,0),(‘localhost’,'root’,”,’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',”,”,”,”,0,0,0,0);
flush priviledges;
Hope that helps. It’ll also reset your root password to blank.
Thanks you, now i got it ,
(’localhost’,’pma’,”,’N’,’N’,’N’,’N’,’N’,’N’,’N’,’Y’,’N’,’N’,’N’,’N’,’N’,’N’,’N’,’N’,’N’,’N’,’N’,’N’,’N’,’N’,’N’,’N’,’N’,’N’,”,”,”,”,0,0,0,0)
zawkosan, glad to be of help.
how to change in root password.my reason for come back i will missed and i dontknow my computer root password in linux.,so how to change in my computer linux root password.please give your solution.i dont know english well .please uinderstand.ok thank you.iam waiting for ur answer
root password how to change i dont know.i k dont know linux root password in my computer
Guide to resetting root password on linux box.
http://linuxgazette.net/107/tomar.html
Hope that helps.
What is the default password for lampp
Henry X/LAMPP in default has no password instead for security you should run this command (as root) to set all of it:
/opt/lampp/lampp security
Cheers.
Hey I’m new to php myadmin and I just got the bad luck of the draw but luckily in these past couple days I have gotten down to the last step and it just so happens I don’t feal like changing my root password to nothing and even using root for phpmyadmin… So I created a new user on mysql called ‘pma’@'localhost’ with password ‘w/epassis’, but how do I configure phpmyadmin to use that connection?
” phpMyAdmin can manage a whole MySQL server (needs a super-user) as well as a single database. ” – http://phpmyadmin.sourceforge.net/documentation/
What I would be suggesting is you to try create another super-user (is that even possible?!) and use that account. And possibly use these values here in config.inc.php(haven’t tried this and i won’t take law suits for this ):
$cfg['Servers'][$i]['user'] = ‘another-supr-root’;
$cfg['Servers'][$i]['password'] = ‘your-strongest-passw0rd-ever’;
Yeah I already have the ‘super-user’ created but those variables don’t change anything. =\
I had the same issue after changing the root password…did as said here….
$cfg[’Servers’][$i][’password’] = ‘your_password_here‘; // MySQL password
and saved. Bingo! now my PhpMyAdmin is working!!!!!! thanks a lot, Rudy.
I am glad that I have helped rajesh.. thanks for visiting. Cheers.
Hey guys, i have a problem. I’m using XAMPP, with phpmyadmin version 2.8.1. I change the root password and suddenly i can’t access the phpmyadmin!
I tried doing the “$cfg[’Servers’][$i][’password’] = ‘your_password_here‘; // MySQL password” instruction posted here but to no avail.
Pls. help me as soon as possible i need to access my database. What shall i do?
Thanks in advance!
What happens when you access:
http://localhost/phpmyadmin/
Anyway you have to restart mysql for the new password to take effect.
You probably need to set your: $cfg['Servers'][$i]['auth_type'] to
$cfg['Servers'][$i]['auth_type'] = ‘config’;
instead of `cookie’ or `http’
Hope that helps.
Might I add that it has been my experience that I had to turn off my McAfee Security Suite to get the database connection to work with XAMPP running.
Thanks ATinsley for visiting.
I have no personal acquaintance with McAfee Suite but there should be a setting there to allow programs to access ports. Just the same as any other software firewalls in the market.
Cheers!
Hey Rudy, hope u can assist man. I’ve installed MAMP, but havin’ issues seeing MAMP startup page, this is the message I get. Then I also have a problem logging onto phpMyAdmin, and this what I get there: #1045 – Access denied for user ‘root’@'localhost’ (using password: YES).
I’m basically trying to setup a website using CMS made simple and kinda need to get the above sorted before I can go any further.
Thanks a stack man
OOOOPPPSSS! that error message : Error: Could not connect to MySQL server!-I’m almost the problem is related
im trying to serve from my home pc and the server is running, ppl can connect, i could connect to the database i created a new user with a password and i also created 2 databases, installed some stuff like a php boards and a php based vdeck. I could access database successfully with both apps, then looking around I see that in phpmyadmin i need to change the settings to a config.inc.php, did the proper adjustment according to the guide. But since then i cannot access my database anymore; it says access is forbidden to phpmyadmin. I had changed only root to my loginname i created earlier added the pass, and i changed the port to the port im using for the server had to use something different than port 80 to make it work. So i went back and run EDIT again and put it back like it was, but even that didnt seem to fix it! I’m clueless, need some help please, thx in advance any advice would be greatly appreciated.
@Sedick and Tuvok: Afaik, you need to set the password in the config file to the root(or another user with sufficient privileges)’s password. So long since I touch this part of my config. Tell me if this helps.
How to start creating a database in phpmyadmin?
I have xampp version 1.6.6 on red hat linux.
After running /opt/lampp/lampp security and setting password,
the phpmyadmin create new database utility is showing “No privilges”.
In my phpmyadmin/config.inc.php file there is no line for changing mysql password.
here is the file. please help me what to do so that i can browse my databases.
I keep doing what’s repeated in all these messages: Change Root password in phpMyAdmin, then change it in config.inc.php… And still get the same message: “#1045 – Access denied for user ‘root’@'localhost’”!
I’ve tried with the controluser pw, changing between http/cookie/config, etc.
I also get “phpMyAdmin was unable to read your configuration file!” and via the link, the message “syntax error, unexpected T_VARIABLE in xxx\config.inc.php on line 1 (there’s only 1 line, but when I split it up, it seems to be in “$cfg['blowfish_secret'] = ‘xampp’;” … which I never changed!
Any ideas?
hi i have installed wamp server and i created a password for my root user and which was empty at the first. I used the above steps to create password. It worked fine for me. In command prompt i get to login with the password i created. But when i open my phpMyAdmin page it shows the same error as “#1045 – Access denied for user ‘root’@'localhost’ (using password: YES)”
If there is a solution to recover from this.. LET ME KNOW..
Thanks in advance.
Hi…I’ve tried all sorts of combos to get rid of my “Error: Could not connect to MySQL server!” that appears when I try to log on to myphpadmin home page. I was building a php page that connected to my database when I realized that I either needed to reset, or create a password. I don’t remember the password I entered when I originally installed MAMP.
So I reset it in two places in myphpadmin. The first was lower down on the permissions page and it seemed wrong (sorry that’s poorly described, but I can’t access the page any more, hence the problem). Then I changed it somewhere in the middle of the page and that worked – the php page I was building worked. And the weird thing is that it STILL WORKS.
So, I’ve added the password I use in that php page to the config.inc.php page, but nothing works. I’ve tried setting the password to blank. I’ve restarted MAMP every itme. I’ve set the user to blank. I’ve added a controluser. Nothing works. What am I doing wrong, and why is my php page still working, but not myphpadmin?
Thanks!
thanks for the info, basically the same though, yet using nano to edit the file. anyway, this post attempts to be neutral in OS choice and in editor. cheers and smile.
Iirc, you need not create a config.inc.php, rather it’s located here: C:\xampp\phpMyAdmin\config.inc.php on Windows installation.
Open http://localhost/ or http://localhost:/ and select English when asked for language. There’s a security link on the left part of the web page, I suggest checking that for configuration or security check for xampp.
Please give us further info, such as, did you changed any of the password on xampp etc. This will give us further links to the issue.
Try to change the password for root in the config file of phpMyAdmin.
How about re-installing? Sorry, I am using a Windows machine.
Is randomUser a legitimate user in MySQL? Remember that it should be one of the user. Also may I have the complete error message?
Thank You very much. PhpMyAdmin keeps warning that a password has not been set, but then as soon as the problem is fixed it gives no information on how to gain access again. Anyway, I appreciate your helpful post, problem solved.
-Nathan
Thanks.
wohaaaa!! yeppeee i had the same prob mentioned above and this is the first page i entered looking for the answer and i GOT it!!! yoooooooooo. thanks alot my friend….
@Nathan, Kelvin, Achin: You are most welcome.
@Cheved: Basically it’s the same, try to set mysql root password first then follow above instructions.
you saved my life! Thanks!
Hello all,
after I installed phpmyadmin , I’ve been trying to login but I have an error message
“#1045 – Access denied for user ‘ahmed’@'localhost’ (using password: YES)”
Note : there is another user ‘root’ with respective password , but I get the same error message when trying logging in using ‘root’ user name ans password
hai
i installed wamp server… wen i try to take localhost its asking username and password… and phpmyadmin is not working…
Just wanted to say thanks for your help on this one! :)
Obrigado ! ! !
OMG thanks. Man, all the other forums were like spilling crap out of their mouths. I feel like an idiot after reading your two line solution! you’re the best!
THANKS YOU!:]
Many thanks, after hours of searching this actually worked, just had to stop and then restart the service and it worked.
It worked for me too.. Only 3 simple steps.
1) Go to the directory C:\xampp\phpMyAdmin and open the file config.inc.php
2) Then find the line 21 and change it to (123456 is my mysql root password)
$cfg['Servers'][$i]['password'] = ’123456′;
3) Then find the line 34 and change it to
$cfg['Servers'][$i]['controlpass'] = ’123456′;
4) Save the file. Then try to refresh the mysql page. This must work in most cases..
Pingback: How to Install WordPress on your Computer - Gadget Cage
Hi All,
Although the information above are much helpful, still it does not solve my problem.
One day last month or so, I accidentally got the way out & of course it was bravo!!!!!!!! But again today i’m stuck at the same problem.
Actually I don’t want to hardcode the password in the phpmyadmin ini file, rather i’d like to enter the login datails everytime I start a session with the phpmyadmin page.
Now my Question is just that what should I enter in the url so that it asks for the password and doesn’t show up the error message.
However the default url is something like : [http://127.0.0.1/phpmyadmin/]
Hope you all understand my problem.
Thank you, that’s just what I needed. I was in a loop on “syncing” the two passwords, thanks for letting me move on.
Hi can you please give me some advice on how i should do to fix this problem? this is what it says:
[17/05/2010 15:28:12] >> Loading config (config.lua
[17/05/2010 15:28:12] > Using plaintext encryption
[17/05/2010 15:28:12] >> Currently Version Feragon Online Server 0.1.1 ( Ethno ) Beta Would You Like To Continue?
[17/05/2010 15:28:12]
[17/05/2010 15:28:12] >> Loading RSA key
[17/05/2010 15:28:12] >> Starting SQL connection
[17/05/2010 15:28:12] Failed connecting to database – MYSQL ERROR: Access denied for user ‘root’@'localhost’ (using password: NO) (1045)
[17/05/2010 15:28:12] > ERROR: Couldn’t estabilish connection to SQL database!
You sir win teh internets. One fruitless hour of looking until I found this
Corbs
Rudy – Many thanks. Problem exactly as you describe. Solution exactly as you describe. The user needs to refresh their phpmyadmin browser session of course!
Pingback: QNAP NAS – Porting a Joomla Site - Donner's Daily Dose of Drama
Many thanks
You saved my day, after I received the “#1045 – Access denied for user ‘root’@'localhost’ (using password: NO)”
Very simple solution. entered a pass word in htdocs/xampp/phpmyadmin/config.inc.php
Hats off to you
ATB
Polite
I’ve read through all these posts/comments and having a similar issue with the root password in MYSQL.
I too changed the mysql root password to plug a security hole, and now when going to the phpmyadmin web page I am greeted with the error “MySQL said #0145 – Access denied for user ‘root’@'localhost’ (using password: NO)”
I have followed the suggestion of changing the password field for the root user in the config.inc.php file to match the new root password, and restarted Apache and MySQL through the XAMPP console with no luck. I still get the same error. Am i missing a step somewhere?
I had a choise to buy either Joomla tutorial or Cackephp’s one. So I bought some tutorial called “Building a CMS with CakePHP 1.2″ what I would not do if I knew before.
Just starting the lesson one and doing the same exact things that the tutor himself brings 2 differents results! Looks like Fake or this Cake is a mistaken app.
Still while trying to make a model the error comes that acces denied for user root bla bla und blah…
Change username and pswd,, leave empty or do whatever u want brings only headaches.. Works fine only for the Tutor himself..
I hate broken things when its presented like Good to the public!!
In my opinion MAMP is retarded, badly made package. Imagine you car worked that well. That says it – find something else to use.
I fought with this for a good hour. Don’t forget to clear your browser history so that the modified version of config.inc.php gets loaded into the phpmyadmin index page. I think Firefox was loading a cashed version and consequently the password reset didn’t seem to be working.
Thanks very much this thread really helped me out. Thanks for taking the time to save us poor noobs.
Thank u for ur solution……..
yeah….Finally my problem resolve.. thanks…
Hi,
Case Sensitivity Must Be Considered: localhost/phpMyAdmin NOT localhost/phpmyadmin.
heyyyyyyyyyyyyyyyyyyyyy! is anyone still there….im using xampp o windows. im trying to install joomla under htdocs bt in later steps it says “unable to connect to database”, only then i realize that it asks for a password for database same as the database passowrd under phpmyadmin…..but dueing installation of phpmyadmin i nver had to enter any password.
so i followed your steps to setup a passowrd in config.php file an also the same password in controlpas an then refreshed the xampp control panel BUT OF NO USE…whtever i try i get the error at phpmyadmin page that says
#1045 – Access denied for user ‘root’@'localhost’ (using password: YES)
PLEASE HELP
coz otherwise my joomla isnt going to work..without a password my phpmyadmin works fine bt not joomla
Hey Naj, read my comment #79 below for your answer. May it be of some help to you.
Hey Naj…
I suppose you have installed XAMPP with all default settings. And entered no passwords anywhere!
If that’s right, then You can install joomla directly as following:
1. Launch your browser, and navigate to “http://localhost/phpmyadmin”, where joomla is the directory of joomla files in “htdocs”.
2. Create a new database “joomladb” by entering the database name. Do nothing else there.
3. Now Navigate to “http://localhost/joomla”, where [joomla] is the directory of joomla files in “htdocs”.
4. Click next until you get to the step where joomla installation asks for the mysql database information.
5. enter the values :
Database Type: mysql
Host Name : localhost
UserName : root
Password :
Database name: joomladb
6. Click Next to reach FTP settings page. Here you need to have a FTP account set up for joomla.
To create a FTP account, launch XAMPP Control panel. Ensure that the Filezilla is running.
Click the Admin button next to Filezilla. Click Ok if any window pops up to ask any password
like Administrator password etc.
7. Goto Edit Menu > Users > Click on Add Button.
8. Type the new user name e.g. “joomlaftp” > click OK
9. Check the password check box and enter the password for this new Account.
10. Click on SHARED FOLDERS in the Page Section of the window.
11. Click ADD > Browse to the location where the Joomla Directory is located. This is generally
“C:\xampp\htdocs\joomla” or may be anything else depending on your system settings.
12. Check all check boxes : Read, Write, Delete, Append Under Files section
13. Check all check boxes : Create, Delete, List, +subdirs Under Directories section.
14. Click on the Button “SET AS HOME DIR”
15. Now click OK to close the window.
16. Now you can close FileZilla window and XAMPP Control Panel also.
17. Back to Joomla installation now.
18. Enter the FTP User name and password you just created.
19. Leave FTP root path blank.
20. Click AUTOFIND FTP PATH
21. A message will tell you that the FTP settings are valid.
22. Go to next step, may be Joomla Session has expired because, creating FTP account has taken a lot of time. In such case restart Joomla installation from step 3, and use same FTP account details this
time.
23. Enter the SITE Name, Your email address, and your admin password. IMPORTANT: This IS THE ADMIN PASSWORD THAT YOU WILL USE TO LOGIN TO JOOMLA BACKEND, THE USERNAME IS ALWAYS “Admin”.
24.Click INSTALL SAMPLE DATA to install a sample website to work on.
25. Then Click next.
26. Now Delete the “installation directory” from the joomla directory. THIS IS COMPULSORY.
27. And you are ready to use your joomla installation
===============================================================
IF YOU GET ANY TROUBLE, POST HERE OR CONTACT ME AT
izhar_aazmi[at]yahoo.co.in
I CAN ALSO GIVE YOU A VIDEO TUTORIAL IF YOU NEED. OR REQUEST A
REMOTE ASSISTANCE ONLINE, IN CASE YOU NEED.
===============================================================
HAPPY DEVELOPMENT WITH JOOMLA… GOOD LUCK…
===============================================================
rudyegenias,
A word of thanks. I spent a lot of time trying to fix this problem and you gave me the answer.
Thank you. Zach Wiesner
I have installed xampp on Ubuntu 10.10.But on phpmyadmin I could not create database.There is a message under CREATE NEW DATABASES ,no previlage is seen.How can I am able to create new databases on phpmyadmin
I am new to ubuntu and new to xampp
Please help me
Thanks in advance
#1045 – Access denied for user ‘root’@'localhost’ (using password: YES)
I’m already install joomla and it works, but my when i try to get in localhost/phpmyadmin i see that
Error
MySQL said:
#1045 – Access denied for user ‘root’@'localhost’ (using password: YES)
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.
Somewhere i put password “root” in the settings, and after that, this is happend. I already tried to type this password in config.ini.php i still have the same problem.
Thanks so much for this solution. Was just about to uninstall and reinstall Xampp. Was already having problems installing joomla (though have done it a number of times before). Thinking the password might be the problem I created a new password in PhpMyadmin. Then was locked and just got the error message. Found the installation>/htdocs/xampp/phpmyadmin/config.inc.php
and did what you said.
At the same time I then found what was causing the installation problem. In the servers extension area the database had been changed to ‘mysqli’ instead of ‘mysql’.
I corrected this and was then able to install joomla. This is what I changed other than the password :
$cfg['Servers'][$i]['extension'] = ‘mysql’;
so now looks like this:
/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = ‘config’;
$cfg['Servers'][$i]['user'] = ‘root’;
$cfg['Servers'][$i]['password'] = ‘mypassword’;
$cfg['Servers'][$i]['AllowNoPassword'] = true;
/* Server parameters */
$cfg['Servers'][$i]['host'] = ‘localhost’;
$cfg['Servers'][$i]['connect_type'] = ‘tcp’;
$cfg['Servers'][$i]['compress'] = false;
/* Select mysqli if your server has it */
$cfg['Servers'][$i]['extension'] = ‘mysql’;
THANK YOU AGAIN. Saved me a lot of time and energy.
Care to share what you see when you run “xampp-portcheck.exe”?
#1045 – Access denied for user ‘root’@'localhost’ (using password: YES) my password is root i try to connect but i can’t connect it shows Connection for controluser as defined in your configuration failed.
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.how to solve this problem.please help me.
am trying to access phpmyadmin but i have failed. i have read several posts from your page but i have failed to rectify where my problem is. when i try to login, it brings this message:
Error
MySQL said
#1045 – Access denied for user ‘root’@'localhost’ (using password: NO)
Connection for controluser as defined in your configuration failed.
i changed my password in security settings to 12345 and i have also done the same in config.inc.php on line 21 and 34. i also set the authentication method to http and then cookie but still it failed. what can i do?
anybody to help me.
just write ‘pma’ in user field and leave password field ……..nd press enter. :)
Thanks heaps. Point one worked first off for me.
Wamp users can generally find the configuration file located at C:\wamp\apps\phpmyadmin3.3.9\config.inc.php
Didn’t work for me. I am using XAMP 1.7.4
http://rudyegenias.wordpress.com/2006/09/15/enabling-phpmyadmin-once-you-change-permission-or-privileges-on-mysql-database/#comment-form-load-service:Facebook
It finally work by changing
$cfg['Servers'][$i]['AllowNoPassword'] = true;
to
$cfg['Servers'][$i]['AllowNoPassword'] = false;
Thanks you very much, it’s work for me.
hello,pls help
By mistake i have changed the password privileges to NO from phpmyadmin becos of this my phpmyadimin window show this error
Error
MySQL said:
#1045 – Access denied for user ‘root’@'localhost’ (using password: NO)
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.
how cud i correct this error?
Pingback: pc.casey.jp » Ubuntu でXAMPP を使う