Error Number 1045 Access Denied For User
Contents |
Du siehst YouTube auf Deutsch. Du kannst diese Einstellung unten ändern. Learn more You're viewing YouTube in German. You can change error 1045 (28000) access denied for user this preference below. Schließen Ja, ich möchte sie behalten
Mysql Error 1045 (28000) Access Denied For User
Rückgängig machen Schließen Dieses Video ist nicht verfügbar. WiedergabelisteWarteschlangeWiedergabelisteWarteschlange Alle entfernenBeenden Wird geladen... Wiedergabeliste mysql error 1045 sqlstate 28000 access denied for user Warteschlange __count__/__total__ How to fix error #1045 - Access denied for user 'root' in phpmyadmin E Angkor AbonnierenAbonniertAbo beenden1.0211 Tsd. Wird geladen... Wird error 1045 (28000) access denied for user (using password yes) geladen... Wird 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 du dieses Video melden? Melde dich an, um unangemessene Inhalte zu melden. Anmelden Statistik 61.111
Connect Error (1045) Access Denied For User 'root'@'localhost' (using Password Yes)
Aufrufe 59 Dieses Video gefällt dir? Melde dich bei YouTube an, damit dein Feedback gezählt wird. Anmelden 60 22 Dieses Video gefällt dir nicht? Melde dich bei YouTube an, damit dein Feedback gezählt wird. Anmelden 23 Wird geladen... 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 17.10.2015#1045 - Access denied for user 'root'@'localhost' (using password: NO or YES), if have problem like this , please try Kategorie Bildung 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 MySQL said: Cannot connect invalid settings error | XAMPP Phpmyadmin - Dauer: 3:28 Abdel Tutors 8.967 Aufrufe 3:28 How to solve mysql_connect(): Access denied
here for a quick overview of the site Help Center Detailed error 1045 access denied for user 'root'@'localhost' windows answers to any questions you might have Meta Discuss error 1045 access denied for user ''@'localhost' to database 'mysql' the workings and policies of this site About Us Learn more about Stack Overflow the
Mysql Error 1045 Using Password Yes
company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss https://www.youtube.com/watch?v=oz6BTvpn3qY Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up #1045 - Access denied for user 'root'@'localhost' (using password: YES) up vote 11 down vote favorite 5 This might seem http://stackoverflow.com/questions/16845715/1045-access-denied-for-user-rootlocalhost-using-password-yes redundant but I was unable to find a correct solution. I was unable to login to mysql using the mysql console.It is asking for a password and I have no clue what I actually entered.(Is there a way to get the password or change it?) This is how my config.inc look. When I try to open phpmyadmin I get this error(#1045 - Access denied for user 'root'@'localhost' (using password: YES))
on other post that is as follow: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 https://www.sitepoint.com/community/t/1045-access-denied-for-user-root-localhost-using-password-no/14685 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: http://dba.stackexchange.com/questions/38803/mysql-error-1045-28000-access-denied-for-user 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 access denied you have DOS screen ( a black screen ) : A: if you already set a password, type itB: if you did not do this step yet, write the following red textB1: use mysql; and click ENTER on your keyboard3: now write the following red text and click ENTER : UPDATE mysql.user->SET Password=PASSWORD("*******")->WHERE User="root"; don't worry about this sign ( -> ) , because for example when you write ( access denied for UPDATE mysql.user ) and you click ENTER on your keyboard, a new line appear with this sign ( -> ), your command will execute when you write this sign ( ; ) at the end of your text and click ENTER. NOTE: replace the password ******* by your password. 4: now write the following red text and click ENTER : FLUSH PRIVILEGES; 5: and to exit the black DOS screen now, write exit and click enter. ------------------------- we are finished from MySQL now -------------- 6: go to WAMP folder ( open your My Computer, click on C driver, and you will see WAMP folder ), click on APPS folder, and than click on your PHPMYADMIN folder ( e.g my folder called phpmyadmin2.11.6 ) and find the config.inc.php 7: open config.inc.php and find the following orange text: $cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed and add your password now that you used in step number 3 like that : $cfg['Servers'][$i]['password'] = 'yourpasswordhere'; // MySQL password (only needed 8: now save this modification, and close config.inc.php 9: go to your web browser and type the following link : http://localhost/phpmyadmin/ and enjoy, this is what happened with me. NB: I wrote all this explications, because I'm also learn
log in tour help Tour Start 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 Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top MySQL - ERROR 1045 (28000): Access denied for user up vote 5 down vote favorite 3 I just installed a fresh copy of Ubuntu 10.04.2 LTS on a new machine. I logged into MySQL as root: david@server1:~$ mysql -u root -p123 I created a new user called repl. I left host blank, so the new user can may have access from any location. mysql> CREATE USER 'repl' IDENTIFIED BY '123'; Query OK, 0 rows affected (0.00 sec) I checked the user table to verify the new user repl was properly created. mysql> select host, user, password from mysql.user; +-----------+------------------+-------------------------------------------+ | host | user | password | +-----------+------------------+-------------------------------------------+ | localhost | root | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 | | server1 | root | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 | | 127.0.0.1 | root | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 | | ::1 | root | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 | | localhost | | | | server1 | | | | localhost | debian-sys-maint | *27F00A6BAAE5070BCEF92DF91805028725C30188 | | % | repl | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 | +-----------+------------------+-------------------------------------------+ 8 rows in set (0.00 sec) I then exit, try to login as user repl, but access is denied. david@server1:~$ mysql -u repl -p123 ERROR 1045 (28000): Access denied for user 'repl'@'localhost' (using password: YES) david@server1:~$ mysql -urepl -p123 ERROR 1045 (28000): Access denied for user 'repl'@'localhost' (using password: YES) david@server1:~$ Why is access denied? mysql share|improve this question edited May 16 at 18:59 culix 1035 asked Mar 28 '13 at 19:44 davidjhp 2141313 have you tried creating this user with a specific host to debu