Error 1045 Phpmyadmin Wamp
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about
Wamp Phpmyadmin #1045 - Access Denied For User 'root'@'localhost'
Stack Overflow the company Business Learn more about hiring developers or posting ads with wamp phpmyadmin #1045 - access denied us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a
#1045 - Access Denied For User Phpmyadmin
community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Wamp phpMyAdmin error #1045 - Access denied for user 'root'@'localhost' up vote 7 down vote phpmyadmin #1045 - access denied for user 'root'@'localhost' (using password yes) favorite 2 This is quite common problem and I found a lot of tutorials to help me solve it, although, there is one additional problem with my case... This is my config settings in config.inc.php $cfg['Servers'][$i]['verbose'] = 'localhost'; $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'] = 'config'; $cfg['Servers'][$i]['user'] = 'root'; $cfg['Servers'][$i]['password'] = 'root'; $cfg['Servers'][$i]['AllowNoPassword'] = true; $cfg['Servers'][$i]['AllowNoPasswordRoot'] = true; When I wamp server access denied for user 'root'@'localhost' (using password no) try to log in via wamp main page, the error shows: 1045 - Access denied for user 'root'@'localhost' (using password: YES) AND this same is when I try to acces MyAdmin by CONSOLE! No matter what I type as password or just press enter, it shows me this same error, and because of that i cant 'flush priviliges'. What can I do? mysql phpmyadmin wamp root share|improve this question asked Nov 21 '13 at 20:54 MateuszC 90128 Are you absolutely sure that these credentials are correct? –Dan White Nov 21 '13 at 21:08 What do you mean? –MateuszC Nov 21 '13 at 21:09 Which part confused you? –Dan White Nov 21 '13 at 23:31 add a comment| 7 Answers 7 active oldest votes up vote 7 down vote Change the line: $cfg['Servers'][$i]['auth_type'] = 'config'; to $cfg['Servers'][$i]['auth_type'] = 'cookie'; Restart and you will be asked for the password the next access to the phpmyadmin page share|improve this answer edited Jul 25 '14 at 17:11 Bill the Lizard 222k138447737 answered Jul 25 '14 at 16:51 Javi Ps 8914 this is not working –DaniKR Nov 10 '14 at 13:25 I change the file C:\wamp\apps\phpmyadmin4.1.14\config.inc.php, this line $cfg['Servers'][$i]['password'] = 'new pass'; and worked! &nda
Du siehst YouTube auf Deutsch. Du kannst diese Einstellung unten ändern. Learn more You're viewing YouTube in German. You can change this preference below. Schließen Ja, ich möchte sie behalten Rückgängig machen Schließen Dieses Video
Phpmyadmin Using Password Yes
ist nicht verfügbar. WiedergabelisteWarteschlangeWiedergabelisteWarteschlange Alle entfernenBeenden Wird geladen... Wiedergabeliste Warteschlange __count__/__total__ wamp phpmyadmin wamp blank page phpMyAdmin error #1045 - Access denied for user root@locahost Fixed! locslikes AbonnierenAbonniertAbo beenden2.4932 Tsd. Wird geladen... Wird geladen... Wird
How To Update Phpmyadmin In Wamp
verarbeitet... Hinzufügen Möchtest du dieses Video später noch einmal ansehen? Wenn du bei YouTube angemeldet bist, kannst du dieses Video zu einer Playlist hinzufügen. Anmelden Teilen Mehr Melden Möchtest http://stackoverflow.com/questions/20131652/wamp-phpmyadmin-error-1045-access-denied-for-user-rootlocalhost du dieses Video melden? Melde dich an, um unangemessene Inhalte zu melden. Anmelden Transkript Statistik 35.347 Aufrufe 185 Dieses Video gefällt dir? Melde dich bei YouTube an, damit dein Feedback gezählt wird. Anmelden 186 4 Dieses Video gefällt dir nicht? Melde dich bei YouTube an, damit dein Feedback gezählt wird. Anmelden 5 Wird geladen... Wird geladen... Transkript Das interaktive Transkript https://www.youtube.com/watch?v=iA_UYg5MLZk konnte nicht geladen werden. Wird geladen... Wird geladen... Die Bewertungsfunktion ist nach Ausleihen des Videos verfügbar. Diese Funktion ist zurzeit nicht verfügbar. Bitte versuche es später erneut. Veröffentlicht am 04.08.2014This video shows one method of getting around the phpmyadmin error #1045 - access denied for user 'root@localhost'.thanks to the author of this site for the reference.http://www.programming-techniques.com... Kategorie Praktische Tipps & Styling Lizenz Standard-YouTube-Lizenz Mehr anzeigen Weniger anzeigen Wird geladen... Anzeige Autoplay Wenn Autoplay aktiviert ist, wird die Wiedergabe automatisch mit einem der aktuellen Videovorschläge fortgesetzt. Nächstes Video How to fix error #1045 - Access denied for user 'root' in phpmyadmin - Dauer: 4:31 E Angkor 59.666 Aufrufe 4:31 How to Fix MySQL/PHPMyAdmin #1045 Error - Dauer: 3:53 TNWProduction 43.727 Aufrufe 3:53 How to solve mysql_connect(): Access denied for user 'root'@'localhost' (using password: YES) - Dauer: 4:53 Mohammad Sheam 55.023 Aufrufe 4:53 How to remove phpMyAdmin Access denied Error #1045 in wamp server - Dauer: 2:46 Solution Cone 74.471 Aufrufe 2:46 how to solve #1045 - Access denied for user 'root'@'localhost' (using password: YES) - Dauer: 2:29 Abhishek Ga
password: NO) Here is a simple way to solve #1045 - Access denied for user ‘root'@'localhost' (using password: NO) error… Just follow the steps: Note: [WAMP_PATH] is http://www.ishaanrawat.com/solved-wampserver-1045-access-denied-for-user-rootlocalhost-using-password-no/ the path to the wampserver directory in your computer so it can be https://www.sitepoint.com/community/t/1045-access-denied-for-user-root-localhost-using-password-no/3809 anything. Default (C:\wamp). First, go to [WAMP_PATH] > apps > phpmyadmin3.5.1. Then find and open config.inc.php in your text editor Now find $cfg[‘Servers'][$i][‘password'] = "; and change it with $cfg[‘Servers'][$i][‘password'] = ‘admin'; (You can put anything in place of admin as your password, this is only a test password). Now find $cfg[‘Servers'][$i][‘AllowNoPassword'] = access denied true; and replace it by $cfg[‘Servers'][$i][‘AllowNoPassword'] = false;. Thats it now save that file. Now restart the wampserver. To do this left-click the wamp icon in the windows taskbar (Notification one), a box will pop up then just click on Restart all Services. Yeah! You have successfully resolved the error. If you face any error make sure to comment or email me. About the Author Ishaan Rawat #1045 - access is a Web Designer and Developer living in Jaipur. He loves to code and learn programming. He can be found solving public issues and problems on Experts-Exchange or Wordpress Forums. He is presently a Guru in Experts-Exchange having more than 150,000 points in HTML, CSS. You can find him on Google+, Twitter, LinkedIn and Facebook. Comments / Remarks ali on September 10, 2013 commented: Brilliant :) massi on September 25, 2013 commented: Bienvenue à phpMyAdmin Erreur MySQL a répondu:Documentation #1045 - Access denied for user 'root'@'localhost' (using password: NO) phpMyAdmin a tenté de se connecter au serveur MySQL, et le serveur a rejeté la connexion. Veuillez vérifier les valeurs de "host", "username" et "password" dans votre configuration et vous assurer qu'elles correspondent aux informations fournies par l'administrateur du serveur MySQL. Anuj Mishra on October 11, 2013 commented: Thank you. Syed Maqbul Hussain on October 22, 2013 commented: Even though i changed the setting in phpmyadmin its giving me the same error can you plz suggest me michael on October 23, 2013 commented: brilliant solution shashank somwanshi on October 29, 2013 commented: still get problem kunthea on November 29, 2013 commented: i did it already. i changed to $cfg['Servers'][$i]['AllowNoPassword']
which it now accepts each time I log on to sql console. However when I try to access mysqladmin it returns: 1045 - Access denied for user 'root'@'localhost' (using password: NO) Any help much appreciated.Thanks and kind regards,Dermot. Ruben_K 2008-04-02 09:03:34 UTC #2 I don't want to state the obvious but the login mysqladmin uses is wrong. it appears mysqladmin logs in using username 'root' and password '' (blank) derm_w 2008-04-02 11:08:07 UTC #3 Many thanks Ruben.When I first installed wamp2 I could access phpmyadmin. But once I created password in mysql console as it suggested I should for security reasons then phpmyadmin immediately hit me with above error.Do I need to reconfigure something somewhere?If so what and where?Sorry for being so slow.Kind regards,Dermot. longneck 2008-04-02 14:08:50 UTC #4 you have to specify the password in the config.inc.php file for phpmyadmin. derm_w 2008-04-02 22:48:28 UTC #5 Many thanks fellas.Thanks to you things are swimming again and everything is rosy.And Longneck I've left a pint of Guinness for you at the bar! For any other fellow newbies here is the whole fix:-mysql>UPDATE mysql.user ->SET Password=PASSWORD("*******") ->WHERE User="root";mysql>FLUSH PRIVILEGES; This is from Sitepoint's "Build your own Database Driven Website using PHP and MYSQL" And then as Longneck said specify the password in the config.inc.php file for phpmyadmin. Kind regards,Dermot. bbparis 2008-08-24 07:52:58 UTC #6 I'm just to confirm you that it's the solution. yesterday I tried to fix the problem, but the only think that was missing is the first line in MySQL command: UPDATE mysql.user I was writing ( UPDATE mysql ) : so please follow the next steps if you want to resolve your problem with ( #1045 - Access denied for user 'root'@'localhost' (using password: NO): 1 : go to your WAMP icon on your PC desktop screen and LEFT CLICK to open the menu, you will see MYSQL folder, CLICK to see MYSQL CONSOLE, open it. 2: now you have DOS screen ( a black screen ) : A: if you already set a password, type it B: if you did not do this step yet, write the following red text B1: use mysql; and click ENTER on your keyboard3: now write the follow