Error 10045 Mysql
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss mysql error 1045 access denied for user 'root'@'localhost' the workings and policies of this site About Us Learn more about mysql access denied for user using password yes Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow mysql access denied for user root Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each mysql drop anonymous user other. Join them; it only takes a minute: Sign up MySQL - ERROR 1045 - Access denied up vote 29 down vote favorite 23 In some way I have managed to get this error when I try to access into MySQL via the command line: [root@localhost ~]# mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for
Mysql Access Denied For User Using Password No
user 'root'@'localhost' (using password: YES) I have tried resetting the password without any luck using this HowTo. I have uninstalled mysql completley and reinstalled but I still get asked for a password. I have no idea why this is the case! Can someone please help me get a default install of MySQL. Environment Fedora Core 10, Full Root Access, Apache and PHP installed Thank you for any help!! EDIT To all those that would like to save themselves a few hours of "blood coughing" - when you uninstall MySQl completely delete everything that is left behind. If you don't do this, it will never be a FRESH install. mysql linux passwords mysql-error-1045 share|improve this question edited Jan 8 '10 at 5:28 OMG Ponies 198k36356415 asked Jan 28 '09 at 20:12 Abs 13.2k68208356 2 MySQL error 1045 explained here: webyog.com/faq/content/23/18/en/… –Man_k Aug 6 '12 at 11:01 add a comment| 6 Answers 6 active oldest votes up vote 63 down vote accepted If you actually have set a root password and you've just lost/forgot
communities company blog Stack Exchange Inbox Reputation and Badges sign up 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
#1045 Access Denied For User Localhost Using Password Yes
the company Business Learn more about hiring developers or posting ads with us Ask Ubuntu error 1045 sqlstate 28000 access denied for user 'root'@'localhost' Questions Tags Users Badges Unanswered Ask Question _ Ask Ubuntu is a question and answer site for Ubuntu users and developers. Join error 1045 mysql windows 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 ERROR 1045(28000) : Access denied for http://stackoverflow.com/questions/489119/mysql-error-1045-access-denied user 'root@localhost' (using password: no ) up vote 32 down vote favorite 10 I'm trying to install queXS cati app on my Ubuntu desktop and I installed MySQL server and PHP 5 and I cannot login into MySQL server as root without password: mysql -u root it says ERROR 1045(28000) : Access denied for user 'root@localhost' (using password: no ) But it's okay when I enter mysql -u root -p I can't figure out http://askubuntu.com/questions/401449/error-104528000-access-denied-for-user-rootlocalhost-using-password-no what the problem is. permissions mysql share|improve this question edited May 12 at 8:31 oerdnj 3,8461439 asked Jan 7 '14 at 10:42 user232705 161123 6 Try this: mysql -u root -p mysql Enter password: and you will get: mysql> –user273774 Apr 24 '14 at 18:47 add a comment| 3 Answers 3 active oldest votes up vote 28 down vote That is the normal behaviour. You set a root password for your database so from now on you can't access it without password. That is why it reports: Access denied for user 'root@localhost' (using password: no ) Obviously when you give the password with the -p switch you succeed. share|improve this answer answered Jan 7 '14 at 10:47 falconer 9,91721846 add a comment| up vote 2 down vote In simple words your "root" session do not know password to mysql root user. If you want to make easier to access your mysql create .my.cnf in /root/ and put in it [mysqladmin] user = root password = mysqlrootpassword [mysql] user = root password = mysqlrootpassword [mysqldump] user = root password = mysqlrootpassword where offcourse mysqlrootpassword is your password for mysql's root password so when you execute mysql it uses this password Remeber about safety of this file - put secure rights, so nobody on your server can read it! share|improve this ans
Du siehst YouTube auf Deutsch. Du kannst diese Einstellung unten ändern. Learn more You're viewing YouTube in German. You can https://www.youtube.com/watch?v=BfnTSo5XM1A change this preference below. Schließen Ja, ich möchte sie behalten Rückgängig machen Schließen Dieses Video ist nicht verfügbar. WiedergabelisteWarteschlangeWiedergabelisteWarteschlange Alle entfernenBeenden Wird geladen... https://rhcelinuxguide.wordpress.com/2008/08/25/mysql-error-1045-28000-access-denied-for-user-rootlocalhost-using-password-yes/ Wiedergabeliste Warteschlange __count__/__total__ MySQL Error number:1045 Resolved RGN TAMIL AbonnierenAbonniertAbo beenden1.7071 Tsd. Wird geladen... Wird geladen... Wird verarbeitet... Hinzufügen Möchtest du dieses Video später access denied 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 Transkript Statistik 74.215 Aufrufe 407 Dieses Video gefällt dir? Melde access denied for dich bei YouTube an, damit dein Feedback gezählt wird. Anmelden 408 16 Dieses Video gefällt dir nicht? Melde dich bei YouTube an, damit dein Feedback gezählt wird. Anmelden 17 Wird geladen... Wird geladen... Transkript Das interaktive Transkript konnte nicht geladen werden. 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 27.05.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 Kategorie Praktische Tipps & Styling 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
August 25, 2008 The other day I got this error on one of our servers. Fantastico module in cpanel was showing the error: Unable to connect to mysql database. While mysql service was running fine, the root user was unable to login to mysql database. I initially tried to reset the mysql root password like https://rhcelinuxguide.wordpress.com/2008/08/08/reset-mysql-root-password/ but that did not help. The real issue was permission on the folder /var/lib/mysql/mysql . It is supposed to be 711 , while it was 751. That fixed it. ================================================================== root@server1 [~]# mysql ERROR 1045 (28000): Access denied for user ‘root'@'localhost' (using password: YES) root@server1 [~]# root@server1 [/var/lib/mysql/mysql]# ls -lhd /var/lib/mysql drwxr-x-x 179 mysql mysql 12K Aug 25 01:44 /var/lib/mysql/ root@server1 [/var/lib/mysql/mysql]# chmod 711 /var/lib/mysql/mysql root@server1 [/var/lib/mysql/mysql]# ls -lhd /var/lib/mysql/mysql drwx-x-x 2 mysql mysql 4.0K Aug 25 01:32 /var/lib/mysql/mysql/ root@server1 [/var/lib/mysql/mysql]# service mysql restart Shutting down MySQL.. [ OK ] Starting MySQL [ OK ] root@server1 [/var/lib/mysql/mysql]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.0.51a-community MySQL Community Edition (GPL)Type ‘help;' or ‘\h' for help. Type ‘\c' to clear the buffer.
mysql> quit Bye root@server1 [/var/lib/mysql/mysql]# ================================================================== Worked for me ! If above steps does not work, you can try this: root@server1 [~]# /etc/init.d/mysqld stop root@server1 [~]# safe_mysqld -skip-grant-tables & root@server1 [~]# mysql root@server1 [~]# USE mysql mysql> UPDATE user SET password=password("new root passwd") WHERE user="root"; mysql> flush privileges; mysql> exit root@server1 [~]# killall mysqld mysql root@server1 [~]# /etc/init.d/mysqld start You can check the root mysql password in /root/.my.cnf ( assuming you have set