Mysql Server Instance Configuration Error Nr. 1045
Contents |
Επιλέξτε τη γλώσσα σας. Κλείσιμο Μάθετε περισσότερα View this message in English Το YouTube εμφανίζεται στα Ελληνικά. Μπορείτε να αλλάξετε αυτή την προτίμηση παρακάτω. Learn error 1045 mysql windows 7 more You're viewing YouTube in Greek. You can mysql error number 1045 access denied for user using password yes change this preference below. Κλείσιμο Ναι, θέλω να τη κρατήσω Αναίρεση Κλείσιμο
Error 1045 Mysql Access Denied For User Root@localhost
Αυτό το βίντεο δεν είναι διαθέσιμο. Ουρά παρακολούθησηςΟυράΟυρά παρακολούθησηςΟυρά Κατάργηση όλωνΑποσύνδεση Φόρτωση... Ουρά παρακολούθησης Ουρά __count__/__total__ MySQL Error number:1045 Resolved
Error No 1045 Access Denied For User
RGN TAMIL ΕγγραφήΕγγραφήκατεΚατάργηση εγγραφής1.7241 χιλ. Φόρτωση... Φόρτωση... Σε λειτουργία... Προσθήκη σε... Θέλετε να το δείτε ξανά αργότερα; Συνδεθείτε για να προσθέσετε το βίντεο σε playlist. Σύνδεση Κοινή χρήση Περισσότερα Αναφορά Θέλετε να αναφέρετε το βίντεο; Συνδεθείτε για να αναφέρετε ακατάλληλο error 1045 mysql windows 8 περιεχόμενο. Σύνδεση Μεταγραφή Στατιστικά στοιχεία 75.012 προβολές 410 Σας αρέσει αυτό το βίντεο; Συνδεθείτε για να μετρήσει η άποψή σας. Σύνδεση 411 16 Δεν σας αρέσει αυτό το βίντεο; Συνδεθείτε για να μετρήσει η άποψή σας. Σύνδεση 17 Φόρτωση... Φόρτωση... Μεταγραφή Δεν ήταν δυνατή η φόρτωση της διαδραστικής μεταγραφής. Φόρτωση... Φόρτωση... Η δυνατότητα αξιολόγησης είναι διαθέσιμη όταν το βίντεο είναι ενοικιασμένο. Αυτή η λειτουργία δεν είναι διαθέσιμη αυτήν τη στιγμή. Δοκιμάστε ξανά αργότερα. Δημοσιεύτηκε στις 27 Μαΐ 2012Its the perfect solution for MySQL Error number 1045.. All u have to do is just follow the video and do the same.. u'll be succeeded.. if not just inform through comments i'll provide u a better solution Κατηγορία Οδηγίε
2:49 Reporter: bhodi sol Email Updates: Status: Can't repeat Impact on me: None Category:MySQL Server: Config Wizard Severity:S2 (Serious) Version:5.1.54 OS:Microsoft Windows (2008 R2)
Error 1045 Mysql Using Password Yes Windows
Assigned to: View Add Comment Files Developer Edit Submission View Progress Log mysql error no 1045 access denied for user Contributions [7 Feb 2011 15:42] bhodi sol Description: Apply security is the problem in the configuration wizard. I have the security settings could not be applied mysql error 1045 tried by opening the port and uninstall & did a fresh installation by deleting the old mysql directory but I still get the error. Is there any permanent patch for this https://www.youtube.com/watch?v=BfnTSo5XM1A because this is a common error where most of the mysql users getting this error in common. How to repeat: mysql instance configuration wizard> error when applying security settings > Error Nr : 1045 - Access denied for user root@localhost (using password YES) Suggested fix: I have tried by opening the port and uninstall & did a fresh installation by deleting the https://bugs.mysql.com/bug.php?id=59988 old mysql directory but I still get the error. Is there any permanent patch for this because this is a common error where most of the mysql users getting this error in common. [7 Feb 2011 15:49] Miguel Solorzano Could you please look for a file on your data install directory with your hots_name_computer.err and print here the error messages. Thanks in advance. [7 Feb 2011 16:25] bhodi sol There is no hots_name_computer.err in the installation directory, program files>Mysql>Mysql server 5.1> contains bin,Doc,lib,share directories in this there is no such .err file in any of these. [7 Feb 2011 16:37] Miguel Solorzano Please open in the installation directory the file my.ini and look the datadir variable which has the data directory, then in that datadir directory look for the *.err file. [8 Feb 2011 2:02] bhodi sol Apologize datadir was in the hidden folder, here is the error in the .err file when I initiated the configuration wizard. 110208 7:21:44 [Note] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Normal shutdown 110208 7:21:44 [Note] Event Scheduler: Purging the queue. 0 events 110208 7:21:44 InnoDB: Starting shutdown...
2004 18:56 Reporter: [ name withheld ] Email Updates: Status: Can't repeat Impact on me: None Category:MySQL Server: https://bugs.mysql.com/bug.php?id=6891 Installing Severity:S3 (Non-critical) Version:mysql-4.1.7-essential-win.msi OS:wxp pro latest sp etc. Assigned to: https://www.sitepoint.com/community/t/1045-access-denied-for-user-root-localhost-using-password-no/3809 View Add Comment Files Developer Edit Submission View Progress Log Contributions [30 Nov 2004 10:44] [ name withheld ] Description: When I install mysql-4.1.7-essential-win.msi it always end up with the following screen : ********************************************** MySQL Server Instance Configuration Wizard MySQL Server Instance Configuration error 1045 Configure the MySQL Server 4.1 server instance. Processing configuration... / Prepare configuration / Write configuration file (c:\Program ... \my.ini) / Start service x Apply Security settings The security settings could not be applied. Error Number 1045. Access denied for user 'root'@'localhost' (using password:NO) ********************************************** Interestingly enough I do provide a password but it seems it error 1045 mysql is not used by the wizard. How to repeat: Install mysql-4.1.7-essential-win.msi under win xp pro. Keep all default values. I get a 100% success rate on this one :-( Suggested fix: Apply security settings or else explain how to apply manually. [30 Nov 2004 18:56] Miguel Solorzano I wasn't able to repeat on my XP box. Yeah, you can resolve the issue manually, please go to: http://dev.mysql.com/doc/mysql/en/Windows_installation.html and then you read the below items: 2.3.10 Starting the Server for the First Time 2.3.11 Starting MySQL from the Windows Command Line 2.3.12 Starting MySQL as a Windows Service 2.3.13 Testing The MySQL Installation 2.3.14 Troubleshooting a MySQL Installation Under Windows [28 Feb 2005 19:37] [ name withheld ] I have this same issue. When I go through the installer, I enter the root pw and then it tells me that it cannect to the server to configure it using root@localhost using password = NO. Note: Was upgrading from 4.0 to 4.1 whe
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 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 )