title: MYSQL ERROR: Cannot connect: invalid settings
body: <p>I'm Receiving this ERROR on MY SQL :</p>
  
  <p>Error
  MySQL said: Documentation</p>
  
  <p>Cannot connect: invalid settings. 
   phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.</p>
  
  <p>I tried everything but still getting this error. </p>
  
  <p>here is the ERROR LOG from MYSQL:</p>
  
  <pre><code>2017-01-18 14:46:01 10496 [Note] Plugin 'FEDERATED' is disabled.&lt;br&gt;&lt;br&gt;
  2017-01-18 14:46:01 2558 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.&lt;br&gt;&lt;br&gt;
  2017-01-18 14:46:01 10496 [Note] InnoDB: Using atomics to ref count buffer pool pages&lt;br&gt;&lt;br&gt;
  2017-01-18 14:46:01 10496 [Note] InnoDB: The InnoDB memory heap is disabled&lt;br&gt;&lt;br&gt;
  2017-01-18 14:46:01 10496 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions&lt;br&gt;&lt;br&gt;
  2017-01-18 14:46:01 10496 [Note] InnoDB: Memory barrier is not used&lt;br&gt;&lt;br&gt;
  2017-01-18 14:46:01 10496 [Note] InnoDB: Compressed tables use zlib 1.2.3&lt;br&gt;&lt;br&gt;
  2017-01-18 14:46:01 10496 [Note] InnoDB: Not using CPU crc32 instructions&lt;br&gt;&lt;br&gt;
  2017-01-18 14:46:01 10496 [Note] InnoDB: Initializing buffer pool, size = 16.0M&lt;br&gt;&lt;br&gt;
  2017-01-18 14:46:01 10496 [Note] InnoDB: Completed initialization of buffer pool&lt;br&gt;&lt;br&gt;
  2017-01-18 14:46:02 10496 [Note] InnoDB: Highest supported file format is Barracuda.&lt;br&gt;&lt;br&gt;
  2017-01-18 14:46:02 10496 [Note] InnoDB: The log sequence numbers 0 and 0 in ibdata files do not match the log sequence number 59818 in the ib_logfiles!&lt;br&gt;&lt;br&gt;
  2017-01-18 14:46:02 10496 [Note] InnoDB: Database was not shutdown normally!&lt;br&gt;&lt;br&gt;
  2017-01-18 14:46:02 10496 [Note] InnoDB: Starting crash recovery.&lt;br&gt;&lt;br&gt;
  2017-01-18 14:46:02 10496 [Note] InnoDB: Reading tablespace information from the .ibd files...&lt;br&gt;&lt;br&gt;
  2017-01-18 14:46:02 10496 [Note] InnoDB: Restoring possible half-written data pages &lt;br&gt;&lt;br&gt;
  2017-01-18 14:46:02 10496 [Note] InnoDB: from the doublewrite buffer...&lt;br&gt;&lt;br&gt;
  2017-01-18 14:46:02 10496 [Note] InnoDB: 1 rollback segment(s) are active.&lt;br&gt;&lt;br&gt;
  2017-01-18 14:46:02 10496 [Note] InnoDB: Waiting for purge to start&lt;br&gt;&lt;br&gt;
  2017-01-18 14:46:02 10496 [Note] InnoDB: 5.6.26 started; log sequence number 59818&lt;br&gt;&lt;br&gt;
  2017-01-18 14:46:02 10496 [Note] InnoDB: !!! innodb_force_recovery is set to 1 !!!&lt;br&gt;&lt;br&gt;
  2017-01-18 14:46:02 10496 [Note] Server hostname (bind-address): '*'; port: 3306&lt;br&gt;&lt;br&gt;
  2017-01-18 14:46:02 10496 [Note] IPv6 is available.&lt;br&gt;&lt;br&gt;
  2017-01-18 14:46:02 10496 [Note]   - '::' resolves to '::';&lt;br&gt;&lt;br&gt;
  2017-01-18 14:46:02 10496 [Note] Server socket created on IP: '::'.&lt;br&gt;&lt;br&gt;
  </code></pre>
  
  <p>And I tried also using NAVICAT and SQLYOG but once I tried to Connect my MYSQL keep on FORCE CLOSE</p>
  
  <p>Any Answer on how to handle this?</p>