Error No 1045 Access Denied For User Root@localhost
Contents |
Выбрать другой язык можно в списке ниже. Learn more You're viewing YouTube
Error Number 1045 Access Denied For User Root
in Russian. You can change this 1045 access denied for user root localhost using password yes preference below. Закрыть Да, сохранить Отменить Закрыть Это
Mysql #1045 - Access Denied For User 'root'@'localhost' (using Password No)
видео недоступно. Очередь просмотраОчередьОчередь просмотраОчередь Удалить всеОтключить Загрузка... Очередь просмотра Очередь __count__/__total__ How to fix how to fix #1045 - access denied for user 'root'@'localhost' (using password yes) error #1045 - Access denied for user 'root' in phpmyadmin E Angkor ПодписатьсяПодписка оформленаОтменить подписку1 0211 тыс. Загрузка... Загрузка... Обработка... Добавить в Хотите сохраните это видео? Войдите в аккаунт и добавьте его how to solve access denied for user 'root'@'localhost' (using password yes) в плейлист. Войти Поделиться Ещё Пожаловаться Пожаловаться на видео? Выполните вход, чтобы сообщить о неприемлемом контенте. Войти Статистика 61 108 просмотров 59 Понравилось? Войдите в аккаунт, чтобы поставить отметку. Войти 60 22 Не понравилось? Войдите в аккаунт, чтобы поставить отметку. Войти 23 Загрузка... Загрузка... Загрузка... Оценка становится доступна после аренды видео- В данный момент эта функция недоступна. Повторите попытку позже. Опубликовано: 17 окт. 2015 г.#1045 - Access denied for user 'root'@'localhost' (using password: NO or YES), if have problem like this , please try Категория Об
Выбрать другой язык можно в списке ниже. Learn more You're viewing YouTube in Russian. You can
How To Solve Access Denied Problem In Mysql
change this preference below. Закрыть Да, сохранить mysql error 1045 28000 access denied for user root localhost using password no Отменить Закрыть Это видео недоступно. Очередь просмотраОчередьОчередь просмотраОчередь Удалить всеОтключить
Got Error 1045 Access Denied For User Root Localhost
Загрузка... Очередь просмотра Очередь __count__/__total__ how to solve #1045 - Access denied for user 'root'@'localhost' (using https://www.youtube.com/watch?v=oz6BTvpn3qY password: NO) Maxamed Xuseen ПодписатьсяПодписка оформленаОтменить подписку4040 Загрузка... Загрузка... Обработка... Добавить в Хотите сохраните это видео? Войдите в аккаунт и добавьте его в плейлист. Войти Поделиться Ещё Пожаловаться Пожаловаться на видео? Выполните вход, чтобы сообщить https://www.youtube.com/watch?v=dTZZGJbNkR0 о неприемлемом контенте. Войти Статистика 131 896 просмотров 176 Понравилось? Войдите в аккаунт, чтобы поставить отметку. Войти 177 208 Не понравилось? Войдите в аккаунт, чтобы поставить отметку. Войти 209 Загрузка... Загрузка... Загрузка... Оценка становится доступна после аренды видео- В данный момент эта функция недоступна. Повторите попытку позже. Опубликовано: 8 февр. 2013 г.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): Категория Люди и блоги Лицензия Стандартная лицензия YouTube Ещё Свернуть Загрузка... Автовоспроизведение Если функция
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the http://superuser.com/questions/603026/mysql-how-to-fix-access-denied-for-user-rootlocalhost 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 Super User Questions Tags https://www.sitepoint.com/community/t/1045-access-denied-for-user-root-localhost-using-password-no/14685 Users Badges Unanswered Ask Question _ Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute: Sign up Here's access denied how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top mysql how to fix Access denied for user 'root'@'localhost' up vote 52 down vote favorite 31 Before I screw up something, when login using $ mysql -u root -p, and show databases: +--------------------+ | Database | +--------------------+ | information_schema access denied for | | mysql | | performance_schema | | game_data | | test | +--------------------+ Then I try to create a new user and notice something is wrong with the PRIVILEGES. So I deleted the new users, and I guess I removed the 'root' and 'Admin' accidentally. Then I try to create 'root' again, but get Access denied error when doing grant all privileges. mysql> CREATE USER 'root'@'localhost' IDENTIFIED BY 'password'; mysql> grant all privileges on *.* to 'root'@'localhost' identified by 'password' with grant option; ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) If I login mysql again using $ mysql -u root -p, and show databases, +--------------------+ | Database | +--------------------+ | information_schema | +--------------------+ All the other databases are gone. How do I fix mysql now? I cannot cannot find the database 'mysql', cannot create database, create user, anything I try to do will get an error ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES). Should I reinstall mysql using macports? If reinstall, I will lost the database 'game_data', right? mysql user-acco
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 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 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 ( 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 learning PHP and I found a lot on this website helped me, so I'm trying also to help you. But in the Mysql console: i stuck with the following imagehttp://imageshack.us/photo/my-images...ysqldaube.jpg/ I have no i