Mysql Install Error 1045 Windows 7
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 Stack error no 1045 in mysql access denied for user root@localhost Overflow the company Business Learn more about hiring developers or posting ads with us Stack
Error No 1045 Access Denied For User
Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community error 1045 mysql using password yes windows of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Error No. 1045 : While trying to connect to MySql up vote 0 down vote favorite 1
Error 1045 Mysql Windows 8
I installed SQLYog Community edition for windows, a GUI tool for MySql. I had earlier installed MySql with XAMPP. Now when I am trying to connect , I see an error (as pointed): What could be the reason, I am getting this ? How do I connect to MySql and start using this GUI tool ? mysql windows sqlyog share|improve this question asked Jan 7 '13 at 16:25 Suhail Gupta 6,27938105190 mysql error no 1045 access denied for user "Access denied" seems pretty clear, doesn't it? Do you have a user account "suhail" set up? –Pekka 웃 Jan 7 '13 at 16:26 @Pekka How do I connect to MySql. No –Suhail Gupta Jan 7 '13 at 16:28 You need to connect with an existing account and set up users first. XAMPP creates a default mySQL user account, IIRC it's "root" with no password. –Pekka 웃 Jan 7 '13 at 16:29 @Pekka the same result –Suhail Gupta Jan 7 '13 at 16:31 you can usually manage the users and connection with phpmyadmin: 127.0.0.1/phpmyadmin - you have to start xampp-apache and xampp-mysql first unless it is installed as an active service –Adder Jan 7 '13 at 16:33 | show 2 more comments 6 Answers 6 active oldest votes up vote 1 down vote accepted The message says access denied for suhail @localhost . These could be the issues : The user suhail does not exist at locahost. The password specified is wrong. MySql Server is not started. If it is started the port number is not 3306. These are some of the troubleshoot techniques. Also follow the comments on your question. share|improve this answer answered Jan 10 '13 at 11:52 Y.E.P 46441132 add
Επιλέξτε τη γλώσσα σας. Κλείσιμο Μάθετε περισσότερα View this message in English Το YouTube εμφανίζεται στα
Mysql Error 1045 Access Denied For User 'root'@'localhost' Windows
Ελληνικά. Μπορείτε να αλλάξετε αυτή την
Error 1045 Mysql Using Password No
προτίμηση παρακάτω. Learn more You're viewing YouTube in Greek. error no 1045 sqlyog You can change this preference below. Κλείσιμο Ναι, θέλω να τη κρατήσω Αναίρεση Κλείσιμο Αυτό http://stackoverflow.com/questions/14199931/error-no-1045-while-trying-to-connect-to-mysql το βίντεο δεν είναι διαθέσιμο. Ουρά παρακολούθησηςΟυράΟυρά παρακολούθησηςΟυρά Κατάργηση όλωνΑποσύνδεση Φόρτωση... Ουρά παρακολούθησης Ουρά __count__/__total__ MySQL Error number:1045 Resolved RGN TAMIL ΕγγραφήΕγγραφήκατεΚατάργηση εγγραφής1.7241 χιλ. Φόρτωση... Φόρτωση... Σε λειτουργία... Προσθήκη σε... Θέλετε https://www.youtube.com/watch?v=BfnTSo5XM1A να το δείτε ξανά αργότερα; Συνδεθείτε για να προσθέσετε το βίντεο σε playlist. Σύνδεση Κοινή χρήση Περισσότερα Αναφορά Θέλετε να αναφέρετε το βίντεο; Συνδεθείτε για να αναφέρετε ακατάλληλο περιεχόμενο. Σύνδεση Μεταγραφή Στατιστικά στοιχεία 75.012 προβολές 410 Σας αρέσει αυτό το βίντεο; Συνδεθείτε για να μετρήσει η άποψή σας. Σύνδεση 411 16 Δεν σας αρέσει αυτό το βίντεο; Συνδεθείτε για να μετρήσει η άποψή σας. Σύνδεση 17 Φόρτωση... Φόρτωση... Μεταγραφή Δεν ήταν δυνατή η φόρτωση της διαδραστικής μεταγραφής. Φόρτωση... Φόρτωση... Η δυνατότητα αξιολόγησης είναι διαθέσιμη όταν το βίντεο είνα
Community Podcasts MySQL.com Downloads Documentation Section Menu: MySQL Forums :: Install & Repo :: Error Nr. 1045 Access denied for user 'root'@'localhost' http://forums.mysql.com/read.php?11,39440,62685 (Using password: NO) New Topic Advanced Search Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Posted by: mike gieson () Date: January 05, 2006 05:01PM To overcome this issue: 1. Use the MySQL installer again and don't do anything fancy, just click next, next, next, yes, yes, yes. This should install, set error 1045 up and start MySQL. 2. Open the port using the Windows Firewall. Start > Control Panels > Windows Firewall > Exceptions tab. 3. Click the "Add Port" button: Name: mysql Port: 3306 4. Click the "Add Program" button. Browse to MySQL ( C:/Programs Files/mysql 5.x.x/bin/mysql.exe ) 5. If you want, reboot your computer (this is error no 1045 what I did, just in case). 6. Download the the MySQL Administrator program: http://dev.mysql.com/downloads/administrator/ or http://mysql.he.net/downloads/administrator/ 7. After unzipping, launch "MySQLAdministrator.exe" directly out of the unzipped directory by double clicking on the MySQL Administrator.exe file. Server host: localhost Username: root Password: whatever Click "OK" 8. Click on the "Startup Variables" item on the left, then the "Security" tab. Check the checkbox for "Disable grant tables." 9. Click the "Service Control" item on the left and then the "Start/Stop Service" tab. 10. Click "Stop Service" -- once the services has stopped, click the button again to start the service. If you've got PHP installed on your system, I recommend using phpMyAdmin to maintain MySQL: http://www.phpmyadmin.net - mike www.wimpyplayer.com . Edited 1 time(s). Last edit at 01/05/2006 05:05PM by mike gieson. 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) hahahaha