ERROR 1045 28000 Access denied for user root localhost using password NO

Question

I lost the access onto MySQL v  5 6 14  I had access and suddenly I lost it  Looking for notes I found out the url below  I did the steps  but not success  http   dev mysql com doc refman 5 5 en resetting-permissions html  C  Program Files MySQL bin gt mysqld 2013-11-14 19 46 01 0  Warning  TIMESTAMP with implicit DEFAULT value is deprecated  Please use --explicit defaults for timestamp server option  see documentation for more details  C  Program Files MySQL bin gt mysql -u root mysql1 ERROR 1045  28000   Access denied for user  root   localhost   using password  NO   Notice  I don t have mysqld safe or safe mysqld files in MySQL version Could you please help me  Below you can see the dump file generated by the command  C  mysqld --init-file C   mysql-init txt   C  Program Files MySQL bin gt mysqld --init-file C   mysql-init txt --console  2013-11-14 17 57 20 0  Warning  TIMESTAMP with implicit DEFAULT value is deprecated      Please use --explicit defaults for timestamp server option  see documentation for more details   2013-11-14 17 57 20 5180  Note  Plugin  FEDERATED  is disabled  2013-11-14 17 57 20 5180  Note  InnoDB  The InnoDB memory heap is disabled 2013-11-14 17 57 20 5180  Note  InnoDB  Mutexes and rw locks use Windows interlocked     functions 2013-11-14 17 57 20 5180  Note  InnoDB  Compressed tables use zlib 1 2 3 2013-11-14 17 57 20 5180  Note  InnoDB  Not using CPU crc32 instructions 2013-11-14 17 57 20 5180  Note  InnoDB  Initializing buffer pool  size   128 0M 2013-11-14 17 57 20 5180  Note  InnoDB  Completed initialization of buffer pool 2013-11-14 17 57 20 5180  ERROR  InnoDB    ibdata1 can t be opened in read-write mode 2013-11-14 17 57 20 5180  ERROR  InnoDB  The system tablespace must be writable  2013-11-14 17 57 20 5180  ERROR  Plugin  InnoDB  init function returned error  2013-11-14 17 57 20 5180  ERROR  Plugin  InnoDB  registration as a STORAGE ENGINE failed  2013-11-14 17 57 20 5180  ERROR  Unknown unsupported storage engine  InnoDB 2013-11-14 17 57 20 5180  ERROR  Aborting 2013-11-14 17 57 20 5180  Note  Binlog end 2013-11-14 17 57 20 5180  Note  Shutting down plugin  partition  2013-11-14 17 57 20 5180  Note  Shutting down plugin  PERFORMANCE SCHEMA  2013-11-14 17 57 20 5180  Note  Shutting down plugin  INNODB SYS DATAFILES  2013-11-14 17 57 20 5180  Note  Shutting down plugin  INNODB SYS TABLESPACES  2013-11-14 17 57 20 5180  Note  Shutting down plugin  INNODB SYS FOREIGN COLS  2013-11-14 17 57 20 5180  Note  Shutting down plugin  INNODB SYS FOREIGN  2013-11-14 17 57 20 5180  Note  Shutting down plugin  INNODB SYS FIELDS  2013-11-14 17 57 20 5180  Note  Shutting down plugin  INNODB SYS COLUMNS  2013-11-14 17 57 20 5180  Note  Shutting down plugin  INNODB SYS INDEXES  2013-11-14 17 57 20 5180  Note  Shutting down plugin  INNODB SYS TABLESTATS  2013-11-14 17 57 20 5180  Note  Shutting down plugin  INNODB SYS TABLES  2013-11-14 17 57 20 5180  Note  Shutting down plugin  INNODB FT INDEX TABLE  2013-11-14 17 57 20 5180  Note  Shutting down plugin  INNODB FT INDEX CACHE  2013-11-14 17 57 20 5180  Note  Shutting down plugin  INNODB FT CONFIG  2013-11-14 17 57 20 5180  Note  Shutting down plugin  INNODB FT BEING DELETED  2013-11-14 17 57 20 5180  Note  Shutting down plugin  INNODB FT DELETED  2013-11-14 17 57 20 5180  Note  Shutting down plugin  INNODB FT DEFAULT STOPWORD  2013-11-14 17 57 20 5180  Note  Shutting down plugin  INNODB METRICS  2013-11-14 17 57 20 5180  Note  Shutting down plugin  INNODB BUFFER POOL STATS  2013-11-14 17 57 20 5180  Note  Shutting down plugin  INNODB BUFFER PAGE LRU  2013-11-14 17 57 20 5180  Note  Shutting down plugin  INNODB BUFFER PAGE  2013-11-14 17 57 20 5180  Note  Shutting down plugin  INNODB CMP PER INDEX RESET  2013-11-14 17 57 20 5180  Note  Shutting down plugin  INNODB CMP PER INDEX  2013-11-14 17 57 20 5180  Note  Shutting down plugin  INNODB CMPMEM RESET  2013-11-14 17 57 20 5180  Note  Shutting down plugin  INNODB CMPMEM  2013-11-14 17 57 20 5180  Note  Shutting down plugin  INNODB CMP RESET  2013-11-14 17 57 20 5180  Note  Shutting down plugin  INNODB CMP  2013-11-14 17 57 20 5180  Note  Shutting down plugin  INNODB LOCK WAITS  2013-11-14 17 57 20 5180  Note  Shutting down plugin  INNODB LOCKS  2013-11-14 17 57 20 5180  Note  Shutting down plugin  INNODB TRX  2013-11-14 17 57 20 5180  Note  Shutting down plugin  BLACKHOLE  2013-11-14 17 57 20 5180  Note  Shutting down plugin  ARCHIVE  2013-11-14 17 57 20 5180  Note  Shutting down plugin  MRG MYISAM  2013-11-14 17 57 20 5180  Note  Shutting down plugin  MyISAM  2013-11-14 17 57 20 5180  Note  Shutting down plugin  MEMORY  2013-11-14 17 57 20 5180  Note  Shutting down plugin  CSV  2013-11-14 17 57 20 5180  Note  Shutting down plugin  sha256 password  2013-11-14 17 57 20 5180  Note  Shutting down plugin  mysql old password  2013-11-14 17 57 20 5180  Note  Shutting down plugin  mysql native password  2013-11-14 17 57 20 5180  Note  Shutting down plugin  binlog  2013-11-14 17 57 20 5180  Note  mysqld  Shutdown complete  C  Program Files MySQL bin gt

User · Answer

I had the same problem  mysql -u root -p worked for me  It later asks you for a password  You should then enter the password that you had set for mysql  The default password could be password  if you did not set one  More info here

User · Answer

Follow the steps given below    Stop your MySQL server completely  This can be done by accessing the Services window inside Windows XP and Windows Server 2003  where you can stop the MySQL service   Open your MS-DOS command prompt using  cmd  inside the Run window  Inside it navigate to your MySQL bin folder  such as C  MySQL bin using the cd command   Execute the following command in the command prompt  mysqld exe -u root --skip-grant-tables  Leave the current MS-DOS command prompt as it is  and open a new MS-DOS command prompt window   Navigate to your MySQL bin folder  such as C  MySQL bin using the cd command   Enter mysql and press enter   You should now have the MySQL command prompt working  Type use mysql  so that we switch to the  mysql  database   Execute the following command to update the password    UPDATE user SET Password   PASSWORD  NEW PASSWORD   WHERE User    root       However  you can now run any SQL command that you wish    After you are finished close the first command prompt and type exit  in the second command prompt windows to disconnect successfully  You can now start the MySQL service

User · Answer

The following steps are to reset the password for a user in case you forgot  this would also solve your mentioned error   First  stop your MySQL   sudo  etc init d mysql stop   Now start up MySQL in safe mode and skip the privileges table   sudo mysqld safe --skip-grant-tables  amp    Login with root   mysql -uroot   And assign the DB that needs to be used   use mysql    Now all you have to do is reset your root password of the MySQL user and restart the MySQL service   update user set password PASSWORD  YOURPASSWORDHERE   where User  root    flush privileges    quit and restart MySQL   quit   sudo  etc init d mysql stop sudo  etc init d mysql start Now your root password should be working with the one you just set  check it with   mysql -u root -p

User · Answer

Your problem is here   2013-11-14 17 57 20 5180  ERROR  InnoDB    ibdata1 can t be opened in read-write mode   There s some problem with the ibdata1 file - maybe the permissions have changed on it  Perhaps some other process has it open  Does it even exist   Fix this and possibly everything else will fall into place

User · Answer

I encountered the same problem  probably when I uninstalled it and tried to install it again  This happens because of the database file containing login details is still stored in the pc  and the new password will not match the older one   So you can solve this by just uninstalling mysql  and then removing the left over folder from the C  drive  or wherever you must have installed

[mysql] ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

Examples related to mysql