Mysql Error Nr. 1045 Access Denied For User
Contents |
Επιλέξτε τη γλώσσα σας. Κλείσιμο Μάθετε περισσότερα View this message in English Το YouTube εμφανίζεται στα Ελληνικά. Μπορείτε να αλλάξετε αυτή την προτίμηση παρακάτω. Learn
Mysql Administrator
more You're viewing YouTube in Greek. You can error 1045 (28000): access denied for user 'root'@'localhost' (using password: yes) change this preference below. Κλείσιμο Ναι, θέλω να τη κρατήσω Αναίρεση Κλείσιμο Αυτό το βίντεο δεν είναι διαθέσιμο. Ουρά παρακολούθησηςΟυράΟυρά παρακολούθησηςΟυρά Κατάργηση όλωνΑποσύνδεση Φόρτωση... Ουρά παρακολούθησης Ουρά __count__/__total__ Mysql 4.1 error : Error Nr. 1045 access denied for user 'root'@'localhost' Ambar Hasbiyatmoko ΕγγραφήΕγγραφήκατεΚατάργηση εγγραφής8686 Φόρτωση... Φόρτωση... Σε λειτουργία... Προσθήκη σε... Θέλετε να το δείτε ξανά αργότερα; Συνδεθείτε για να προσθέσετε το βίντεο σε playlist. Σύνδεση Κοινή χρήση Περισσότερα Αναφορά Θέλετε να αναφέρετε το βίντεο; Συνδεθείτε για να αναφέρετε ακατάλληλο περιεχόμενο. Σύνδεση Στατιστικά στοιχεία 1.862 προβολές 2 Σας αρέσει αυτό το βίντεο; Συνδεθείτε για να μετρήσει η άποψή σας. Σύνδεση 3 0 Δεν σας αρέσει αυτό το βίντεο; Συνδεθείτε για να μετρήσει η άποψή σας. Σύνδεση 1 Φόρτωση... Φόρτωση... Φόρτωση... Η δυνατότητα αξιολόγησης είναι διαθέσιμη όταν το βίντεο είναι ενοικιασμένο. Αυτή η λειτουργία δεν είναι διαθέσιμη αυτήν τη στιγμή. Δοκιμάστε ξανά αργότερα. Δημοσιεύτηκε στις 3 Ιαν 2016in this video i will show you how to solving the error : "Error Nr. 1045 access denied for user 'root'@'localhost' (using password no)" when installing mysql 4.1 on windows 7 Κατηγορία Πρόσωπα και ιστολόγια Άδεια Τυπική άδεια YouTube Εμφάνιση περισσότερων Εμφάνιση λ
Community Podcasts MySQL.com Downloads Documentation Section Menu: MySQL Forums :: Install & Repo :: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) New Topic Advanced Search Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Posted by: l mh () Date: August 13, 2005 10:14PM Hi everybody.. I'm having a problem while meddling with the Instance Configuration Wizard. I had came across this a couple of https://www.youtube.com/watch?v=ACLDXkqFmBY times.. <<<< The security settings could not be applied to the database because the connection has failed with the following error. Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) If a personal firewall is running on your machine, please make sure you have opened the TCP port 3306 for connections. http://forums.mysql.com/read.php?11,39440,39440 Otherwise no client application can connect to the server. After you have opened the port please press [Retry] to apply the security settings. If you are re-installing after you just uninstalled the MySQL server please note that the data directory was not removed automatically. Therefore the old password from your last installations is still needed to connect to the server. In this case please select skin now and re-run the Configuration Wizard from the start menu. >>>> I had reinstall mysql quite a number of times and it prompts me this error again. Please help.. Thank you very much regards, lmh Navigate:Previous Message•Next Message Options:Reply•Quote Subject Written By Posted Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) l mh 08/13/2005 10:14PM Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) hahahaha268 10/29/2005 06:52AM Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) mega yasa 04/16/2007 01:5
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 http://superuser.com/questions/603026/mysql-how-to-fix-access-denied-for-user-rootlocalhost more about hiring developers or posting ads with us Super User Questions Tags Users Badges Unanswered https://coderanch.com/t/306302/JDBC/databases/Access-denied-user-root-localhost 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 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 access denied down vote favorite 31 Before I screw up something, when login using $ mysql -u root -p, and show databases: +--------------------+ | Database | +--------------------+ | information_schema | | 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 access denied for '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-accounts login privileges share|improve this question edited Dec 31 '15 at 11:36 Eric Leschinski 2,73742642 asked Jun 3 '13 at 7:32 Vogelsire 363146 migrated from stackoverflow.com Jun 3 '13 at 8:32 This question came from our site for professional and enthusiast programmers. Try accesing the server with 'root'@'127.0.0.1' which is diferent from 'root'@'localhost'. Then issue a command to create the user 'root'@'localhost' and grant all privileges to it. –Gimmy Jun 3 '13 at 8:06 Also see How to have MySQL entitle the root user? on Super User. It attempts to avoid resetting passwords. –jww Apr 2 at 11:28 add
Certification Databases Caching Books Engineering Languages Frameworks Products This Site Careers Other all forums Forum: JDBC and Relational Databases Access denied for user 'root@localhost' (using password:NO) error in MySQL Raghavan Muthu Ranch Hand Posts: 3381 I like... posted 8 years ago Dear All, This is regarding an error i get during the configuration of MySQL. If its not the appropriate forum, moderators please move this thread to the one. I have been trying to install MySQL 5.0 in Windows XP. The installation was successful but during the final step of configuration i had been getting this error, Error Nr 1045. Access denied for user 'root@localhost' (using password:NO). I have been searching in google and mysql forums as well. As someone else suggested i have opened the TCP/IP Port 3306 (where MySQL gets installed as a service and listens to any connection request) through the Windows Personal Firewall (inside Control Panel) . I verified the same in command prompt through 'netstat -a' command also. When the same issue arose in my home pc, i got it resolved through excluding the port through Personal Firewall The only difference is i am inside a corporate network here at office. Can anyone help me out in resolving this issue? Am i missing something here? Thank you in advance. [ December 03, 2007: Message edited by: Raghavan Muthu ] Everything has got its own deadline including one's EGO! [CodeBarn] [Java Concepts-easily] [Corey's articles] [SCJP-SUN] [Servlet Examples] [Java Beginners FAQ] [Sun-Java Tutorials] [Java Coding Guidelines] Bindesh Nair Greenhorn Posts: 12 posted 8 years ago Few quick things that I would check for are : 1. Is the current user a local admin on the box, else you wont have permissions to set the firewall (to the best i know) 2. Take an output of netstat - aon and see which process is binded to what .. If possible paste it here too 3. Did you give a password at the time of configuration ? 4. Are you able to do a telnet to p