Error after using password for 'root' user

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Error after using password for 'root' user

Postby ca4D » 12. September 2014 10:47

Hi,

I really hope you can help me here.

XAMPP version number: xampp-win32-1.8.3-4-VC11-installer.exe

Operating system version: Windows 7, 64 Bit-Betriebsystem, Service Pack 1

XAMPP installation path: C:\xampp\

Actions:
Installed xampp to run wordpress and create websites.
Installed and used Wordpress successfully for several days without establishing root user password.
Prompted (warning window) by xampp to create password for root user.
Created passwords for root user(s); host ‘127.0.0.1’; host '::01’ and host ‘localhost’ ( 3 passwords)
Opened file C:\xampp\phpMyAdmin\config.inc.php and changed line:
$cfg['Servers'][$i]['password'] = 'password entered in xampp using browser for host: 'localhost' - MySQL config button';
expected reactions: After saving config.inc.php file returned to xampp in browser and tried to start MySQL admin (button)

Received reactions: Error message:

MySQL said:
#2054 - The server requested authentication method unknown to the client
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.

MySQL Log below

Your help to solve this would be great,

thanks,
Chris

MySQL error log

2014-09-10 08:52:19 2592 [Note] Plugin 'FEDERATED' is disabled.
2014-09-10 08:52:19 a90 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.
2014-09-10 08:52:19 2592 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-09-10 08:52:19 2592 [Note] InnoDB: The InnoDB memory heap is disabled
2014-09-10 08:52:19 2592 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-09-10 08:52:19 2592 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-09-10 08:52:19 2592 [Note] InnoDB: Not using CPU crc32 instructions
2014-09-10 08:52:19 2592 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2014-09-10 08:52:19 2592 [Note] InnoDB: Completed initialization of buffer pool
2014-09-10 08:52:19 2592 [Note] InnoDB: Highest supported file format is Barracuda.
2014-09-10 08:52:26 2592 [Note] InnoDB: 128 rollback segment(s) are active.
2014-09-10 08:52:27 2592 [Note] InnoDB: Waiting for purge to start
2014-09-10 08:52:27 2592 [Note] InnoDB: 5.6.16 started; log sequence number 3537693
2014-09-10 08:52:27 2592 [Note] Server hostname (bind-address): '*'; port: 3306
2014-09-10 08:52:27 2592 [Note] IPv6 is available.
2014-09-10 08:52:27 2592 [Note] - '::' resolves to '::';
2014-09-10 08:52:27 2592 [Note] Server socket created on IP: '::'.
2014-09-10 08:52:29 2592 [Note] Event Scheduler: Loaded 0 events
2014-09-10 08:52:29 2592 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.6.16' socket: '' port: 3306 MySQL Community Server (GPL)
2014-09-10 23:33:33 2592 [Note] C:\xampp\mysql\bin\mysqld.exe: Normal shutdown

2014-09-10 23:33:33 2592 [Note] Giving 0 client threads a chance to die gracefully
2014-09-10 23:33:33 2592 [Note] Event Scheduler: Purging the queue. 0 events
2014-09-10 23:33:33 2592 [Note] Shutting down slave threads
2014-09-10 23:33:33 2592 [Note] Forcefully disconnecting 0 remaining clients
2014-09-10 23:33:33 2592 [Note] Binlog end
2014-09-10 23:33:33 2592 [Note] Shutting down plugin 'partition'
2014-09-10 23:33:33 2592 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2014-09-10 23:33:33 2592 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2014-09-10 23:33:33 2592 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2014-09-10 23:33:33 2592 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2014-09-10 23:33:33 2592 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2014-09-10 23:33:33 2592 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2014-09-10 23:33:33 2592 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2014-09-10 23:33:33 2592 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2014-09-10 23:33:33 2592 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2014-09-10 23:33:33 2592 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2014-09-10 23:33:33 2592 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2014-09-10 23:33:33 2592 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2014-09-10 23:33:33 2592 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2014-09-10 23:33:33 2592 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2014-09-10 23:33:33 2592 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2014-09-10 23:33:33 2592 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2014-09-10 23:33:33 2592 [Note] Shutting down plugin 'INNODB_METRICS'
2014-09-10 23:33:33 2592 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2014-09-10 23:33:33 2592 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2014-09-10 23:33:33 2592 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2014-09-10 23:33:33 2592 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2014-09-10 23:33:33 2592 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2014-09-10 23:33:33 2592 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2014-09-10 23:33:33 2592 [Note] Shutting down plugin 'INNODB_CMPMEM'
2014-09-10 23:33:33 2592 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2014-09-10 23:33:33 2592 [Note] Shutting down plugin 'INNODB_CMP'
2014-09-10 23:33:33 2592 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2014-09-10 23:33:33 2592 [Note] Shutting down plugin 'INNODB_LOCKS'
2014-09-10 23:33:33 2592 [Note] Shutting down plugin 'INNODB_TRX'
2014-09-10 23:33:33 2592 [Note] Shutting down plugin 'InnoDB'
2014-09-10 23:33:33 2592 [Note] InnoDB: FTS optimize thread exiting.
2014-09-10 23:33:33 2592 [Note] InnoDB: Starting shutdown...
2014-09-10 23:33:36 2592 [Note] InnoDB: Shutdown completed; log sequence number 3537703
2014-09-10 23:33:36 2592 [Note] Shutting down plugin 'BLACKHOLE'
2014-09-10 23:33:36 2592 [Note] Shutting down plugin 'ARCHIVE'
2014-09-10 23:33:36 2592 [Note] Shutting down plugin 'MRG_MYISAM'
2014-09-10 23:33:36 2592 [Note] Shutting down plugin 'MyISAM'
2014-09-10 23:33:36 2592 [Note] Shutting down plugin 'MEMORY'
2014-09-10 23:33:36 2592 [Note] Shutting down plugin 'CSV'
2014-09-10 23:33:36 2592 [Note] Shutting down plugin 'sha256_password'
2014-09-10 23:33:36 2592 [Note] Shutting down plugin 'mysql_old_password'
2014-09-10 23:33:36 2592 [Note] Shutting down plugin 'mysql_native_password'
2014-09-10 23:33:36 2592 [Note] Shutting down plugin 'binlog'
2014-09-10 23:33:36 2592 [Note] C:\xampp\mysql\bin\mysqld.exe: Shutdown complete

2014-09-11 08:19:46 2056 [Note] Plugin 'FEDERATED' is disabled.
2014-09-11 08:19:46 820 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.
2014-09-11 08:19:46 2056 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-09-11 08:19:46 2056 [Note] InnoDB: The InnoDB memory heap is disabled
2014-09-11 08:19:46 2056 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-09-11 08:19:46 2056 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-09-11 08:19:46 2056 [Note] InnoDB: Not using CPU crc32 instructions
2014-09-11 08:19:46 2056 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2014-09-11 08:19:46 2056 [Note] InnoDB: Completed initialization of buffer pool
2014-09-11 08:19:46 2056 [Note] InnoDB: Highest supported file format is Barracuda.
2014-09-11 08:19:49 2056 [Note] InnoDB: 128 rollback segment(s) are active.
2014-09-11 08:19:49 2056 [Note] InnoDB: Waiting for purge to start
2014-09-11 08:19:49 2056 [Note] InnoDB: 5.6.16 started; log sequence number 3537703
2014-09-11 08:19:49 2056 [Note] Server hostname (bind-address): '*'; port: 3306
2014-09-11 08:19:49 2056 [Note] IPv6 is available.
2014-09-11 08:19:49 2056 [Note] - '::' resolves to '::';
2014-09-11 08:19:49 2056 [Note] Server socket created on IP: '::'.
2014-09-11 08:19:54 2056 [Note] Event Scheduler: Loaded 0 events
2014-09-11 08:19:54 2056 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.6.16' socket: '' port: 3306 MySQL Community Server (GPL)
2014-09-11 18:12:54 2056 [Note] C:\xampp\mysql\bin\mysqld.exe: Normal shutdown

2014-09-11 18:12:55 2056 [Note] Giving 0 client threads a chance to die gracefully
2014-09-11 18:12:55 2056 [Note] Event Scheduler: Purging the queue. 0 events
2014-09-11 18:12:55 2056 [Note] Shutting down slave threads
2014-09-11 18:12:55 2056 [Note] Forcefully disconnecting 0 remaining clients
2014-09-11 18:12:57 2056 [Note] Binlog end
2014-09-11 18:13:01 2056 [Note] Shutting down plugin 'partition'
2014-09-11 18:13:01 2056 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2014-09-11 18:13:01 2056 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2014-09-11 18:13:01 2056 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2014-09-11 18:13:01 2056 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2014-09-11 18:13:01 2056 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2014-09-11 18:13:01 2056 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2014-09-11 18:13:01 2056 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2014-09-11 18:13:01 2056 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2014-09-11 18:13:01 2056 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2014-09-11 18:13:01 2056 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2014-09-11 18:13:01 2056 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2014-09-11 18:13:01 2056 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2014-09-11 18:13:01 2056 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2014-09-11 18:13:01 2056 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2014-09-11 18:13:01 2056 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2014-09-11 18:13:01 2056 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2014-09-11 18:13:01 2056 [Note] Shutting down plugin 'INNODB_METRICS'
2014-09-11 18:13:01 2056 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2014-09-11 18:13:01 2056 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2014-09-11 18:13:01 2056 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2014-09-11 18:13:01 2056 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2014-09-11 18:13:01 2056 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2014-09-11 18:13:01 2056 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2014-09-11 18:13:01 2056 [Note] Shutting down plugin 'INNODB_CMPMEM'
2014-09-11 18:13:01 2056 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2014-09-11 18:13:01 2056 [Note] Shutting down plugin 'INNODB_CMP'
2014-09-11 18:13:01 2056 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2014-09-11 18:13:01 2056 [Note] Shutting down plugin 'INNODB_LOCKS'
2014-09-11 18:13:01 2056 [Note] Shutting down plugin 'INNODB_TRX'
2014-09-11 18:13:01 2056 [Note] Shutting down plugin 'InnoDB'
2014-09-11 18:13:01 2056 [Note] InnoDB: FTS optimize thread exiting.
2014-09-11 18:13:01 2056 [Note] InnoDB: Starting shutdown...
2014-09-11 18:13:07 2056 [Note] InnoDB: Shutdown completed; log sequence number 4760483
2014-09-11 18:13:07 2056 [Note] Shutting down plugin 'BLACKHOLE'
2014-09-11 18:13:07 2056 [Note] Shutting down plugin 'ARCHIVE'
2014-09-11 18:13:07 2056 [Note] Shutting down plugin 'MRG_MYISAM'
2014-09-11 18:13:07 2056 [Note] Shutting down plugin 'MyISAM'
2014-09-11 18:13:07 2056 [Note] Shutting down plugin 'MEMORY'
2014-09-11 18:13:07 2056 [Note] Shutting down plugin 'CSV'
2014-09-11 18:13:07 2056 [Note] Shutting down plugin 'sha256_password'
2014-09-11 18:13:07 2056 [Note] Shutting down plugin 'mysql_old_password'
2014-09-11 18:13:07 2056 [Note] Shutting down plugin 'mysql_native_password'
2014-09-11 18:13:07 2056 [Note] Shutting down plugin 'binlog'
2014-09-11 18:13:07 2056 [Note] C:\xampp\mysql\bin\mysqld.exe: Shutdown complete

2014-09-11 18:14:10 1408 [Note] Plugin 'FEDERATED' is disabled.
2014-09-11 18:14:10 a80 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.
2014-09-11 18:14:10 1408 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-09-11 18:14:10 1408 [Note] InnoDB: The InnoDB memory heap is disabled
2014-09-11 18:14:10 1408 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-09-11 18:14:10 1408 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-09-11 18:14:10 1408 [Note] InnoDB: Not using CPU crc32 instructions
2014-09-11 18:14:10 1408 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2014-09-11 18:14:10 1408 [Note] InnoDB: Completed initialization of buffer pool
2014-09-11 18:14:10 1408 [Note] InnoDB: Highest supported file format is Barracuda.
2014-09-11 18:14:13 1408 [Note] InnoDB: 128 rollback segment(s) are active.
2014-09-11 18:14:14 1408 [Note] InnoDB: Waiting for purge to start
2014-09-11 18:14:14 1408 [Note] InnoDB: 5.6.16 started; log sequence number 4760483
2014-09-11 18:14:14 1408 [Note] Server hostname (bind-address): '*'; port: 3306
2014-09-11 18:14:14 1408 [Note] IPv6 is available.
2014-09-11 18:14:14 1408 [Note] - '::' resolves to '::';
2014-09-11 18:14:14 1408 [Note] Server socket created on IP: '::'.
2014-09-11 18:14:17 1408 [Note] Event Scheduler: Loaded 0 events
2014-09-11 18:14:17 1408 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.6.16' socket: '' port: 3306 MySQL Community Server (GPL)
2014-09-11 23:32:09 1408 [Note] C:\xampp\mysql\bin\mysqld.exe: Normal shutdown

2014-09-11 23:32:10 1408 [Note] Giving 0 client threads a chance to die gracefully
2014-09-11 23:32:10 1408 [Note] Event Scheduler: Purging the queue. 0 events
2014-09-11 23:32:10 1408 [Note] Shutting down slave threads
2014-09-11 23:32:10 1408 [Note] Forcefully disconnecting 0 remaining clients
2014-09-11 23:32:10 1408 [Note] Binlog end
2014-09-11 23:32:11 1408 [Note] Shutting down plugin 'partition'
2014-09-11 23:32:11 1408 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2014-09-11 23:32:11 1408 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2014-09-11 23:32:11 1408 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2014-09-11 23:32:11 1408 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2014-09-11 23:32:11 1408 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2014-09-11 23:32:11 1408 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2014-09-11 23:32:11 1408 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2014-09-11 23:32:11 1408 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2014-09-11 23:32:11 1408 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2014-09-11 23:32:11 1408 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2014-09-11 23:32:11 1408 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2014-09-11 23:32:11 1408 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2014-09-11 23:32:11 1408 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2014-09-11 23:32:11 1408 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2014-09-11 23:32:11 1408 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2014-09-11 23:32:11 1408 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2014-09-11 23:32:11 1408 [Note] Shutting down plugin 'INNODB_METRICS'
2014-09-11 23:32:11 1408 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2014-09-11 23:32:11 1408 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2014-09-11 23:32:11 1408 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2014-09-11 23:32:11 1408 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2014-09-11 23:32:11 1408 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2014-09-11 23:32:11 1408 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2014-09-11 23:32:11 1408 [Note] Shutting down plugin 'INNODB_CMPMEM'
2014-09-11 23:32:11 1408 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2014-09-11 23:32:11 1408 [Note] Shutting down plugin 'INNODB_CMP'
2014-09-11 23:32:11 1408 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2014-09-11 23:32:11 1408 [Note] Shutting down plugin 'INNODB_LOCKS'
2014-09-11 23:32:11 1408 [Note] Shutting down plugin 'INNODB_TRX'
2014-09-11 23:32:11 1408 [Note] Shutting down plugin 'InnoDB'
2014-09-11 23:32:11 1408 [Note] InnoDB: FTS optimize thread exiting.
2014-09-11 23:32:11 1408 [Note] InnoDB: Starting shutdown...
2014-09-11 23:32:18 1408 [Note] InnoDB: Shutdown completed; log sequence number 4765733
2014-09-11 23:32:18 1408 [Note] Shutting down plugin 'BLACKHOLE'
2014-09-11 23:32:18 1408 [Note] Shutting down plugin 'ARCHIVE'
2014-09-11 23:32:18 1408 [Note] Shutting down plugin 'MRG_MYISAM'
2014-09-11 23:32:18 1408 [Note] Shutting down plugin 'MyISAM'
2014-09-11 23:32:18 1408 [Note] Shutting down plugin 'MEMORY'
2014-09-11 23:32:18 1408 [Note] Shutting down plugin 'CSV'
2014-09-11 23:32:18 1408 [Note] Shutting down plugin 'sha256_password'
2014-09-11 23:32:18 1408 [Note] Shutting down plugin 'mysql_old_password'
2014-09-11 23:32:18 1408 [Note] Shutting down plugin 'mysql_native_password'
2014-09-11 23:32:18 1408 [Note] Shutting down plugin 'binlog'
2014-09-11 23:32:18 1408 [Note] C:\xampp\mysql\bin\mysqld.exe: Shutdown complete

2014-09-12 07:56:49 1620 [Note] Plugin 'FEDERATED' is disabled.
2014-09-12 07:56:49 76c 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.
2014-09-12 07:56:49 1620 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-09-12 07:56:49 1620 [Note] InnoDB: The InnoDB memory heap is disabled
2014-09-12 07:56:49 1620 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-09-12 07:56:49 1620 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-09-12 07:56:49 1620 [Note] InnoDB: Not using CPU crc32 instructions
2014-09-12 07:56:49 1620 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2014-09-12 07:56:49 1620 [Note] InnoDB: Completed initialization of buffer pool
2014-09-12 07:56:49 1620 [Note] InnoDB: Highest supported file format is Barracuda.
2014-09-12 07:56:55 1620 [Note] InnoDB: 128 rollback segment(s) are active.
2014-09-12 07:56:55 1620 [Note] InnoDB: Waiting for purge to start
2014-09-12 07:56:55 1620 [Note] InnoDB: 5.6.16 started; log sequence number 4765733
2014-09-12 07:56:55 1620 [Note] Server hostname (bind-address): '*'; port: 3306
2014-09-12 07:56:55 1620 [Note] IPv6 is available.
2014-09-12 07:56:55 1620 [Note] - '::' resolves to '::';
2014-09-12 07:56:55 1620 [Note] Server socket created on IP: '::'.
2014-09-12 07:56:57 1620 [Note] Event Scheduler: Loaded 0 events
2014-09-12 07:56:57 1620 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.6.16' socket: '' port: 3306 MySQL Community Server (GPL)
2014-09-12 09:01:58 1620 [Note] C:\xampp\mysql\bin\mysqld.exe: Normal shutdown

2014-09-12 09:01:58 1620 [Note] Giving 0 client threads a chance to die gracefully
2014-09-12 09:01:58 1620 [Note] Event Scheduler: Purging the queue. 0 events
2014-09-12 09:01:58 1620 [Note] Shutting down slave threads
2014-09-12 09:01:58 1620 [Note] Forcefully disconnecting 0 remaining clients
2014-09-12 09:01:58 1620 [Note] Binlog end
2014-09-12 09:01:58 1620 [Note] Shutting down plugin 'partition'
2014-09-12 09:01:58 1620 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2014-09-12 09:01:58 1620 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2014-09-12 09:01:58 1620 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2014-09-12 09:01:58 1620 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2014-09-12 09:01:58 1620 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2014-09-12 09:01:58 1620 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2014-09-12 09:01:58 1620 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2014-09-12 09:01:58 1620 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2014-09-12 09:01:58 1620 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2014-09-12 09:01:58 1620 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2014-09-12 09:01:58 1620 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2014-09-12 09:01:58 1620 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2014-09-12 09:01:58 1620 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2014-09-12 09:01:58 1620 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2014-09-12 09:01:58 1620 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2014-09-12 09:01:58 1620 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2014-09-12 09:01:58 1620 [Note] Shutting down plugin 'INNODB_METRICS'
2014-09-12 09:01:58 1620 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2014-09-12 09:01:58 1620 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2014-09-12 09:01:58 1620 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2014-09-12 09:01:58 1620 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2014-09-12 09:01:58 1620 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2014-09-12 09:01:58 1620 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2014-09-12 09:01:58 1620 [Note] Shutting down plugin 'INNODB_CMPMEM'
2014-09-12 09:01:58 1620 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2014-09-12 09:01:58 1620 [Note] Shutting down plugin 'INNODB_CMP'
2014-09-12 09:01:58 1620 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2014-09-12 09:01:58 1620 [Note] Shutting down plugin 'INNODB_LOCKS'
2014-09-12 09:01:58 1620 [Note] Shutting down plugin 'INNODB_TRX'
2014-09-12 09:01:58 1620 [Note] Shutting down plugin 'InnoDB'
2014-09-12 09:01:58 1620 [Note] InnoDB: FTS optimize thread exiting.
2014-09-12 09:01:58 1620 [Note] InnoDB: Starting shutdown...
2014-09-12 09:02:00 1620 [Note] InnoDB: Shutdown completed; log sequence number 5290632
2014-09-12 09:02:00 1620 [Note] Shutting down plugin 'BLACKHOLE'
2014-09-12 09:02:00 1620 [Note] Shutting down plugin 'ARCHIVE'
2014-09-12 09:02:00 1620 [Note] Shutting down plugin 'MRG_MYISAM'
2014-09-12 09:02:00 1620 [Note] Shutting down plugin 'MyISAM'
2014-09-12 09:02:00 1620 [Note] Shutting down plugin 'MEMORY'
2014-09-12 09:02:00 1620 [Note] Shutting down plugin 'CSV'
2014-09-12 09:02:00 1620 [Note] Shutting down plugin 'sha256_password'
2014-09-12 09:02:00 1620 [Note] Shutting down plugin 'mysql_old_password'
2014-09-12 09:02:00 1620 [Note] Shutting down plugin 'mysql_native_password'
2014-09-12 09:02:00 1620 [Note] Shutting down plugin 'binlog'
2014-09-12 09:02:00 1620 [Note] C:\xampp\mysql\bin\mysqld.exe: Shutdown complete

2014-09-12 09:02:08 10300 [Note] Plugin 'FEDERATED' is disabled.
2014-09-12 09:02:08 20b0 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.
2014-09-12 09:02:08 10300 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-09-12 09:02:08 10300 [Note] InnoDB: The InnoDB memory heap is disabled
2014-09-12 09:02:08 10300 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-09-12 09:02:08 10300 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-09-12 09:02:08 10300 [Note] InnoDB: Not using CPU crc32 instructions
2014-09-12 09:02:08 10300 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2014-09-12 09:02:08 10300 [Note] InnoDB: Completed initialization of buffer pool
2014-09-12 09:02:08 10300 [Note] InnoDB: Highest supported file format is Barracuda.
2014-09-12 09:02:11 10300 [Note] InnoDB: 128 rollback segment(s) are active.
2014-09-12 09:02:11 10300 [Note] InnoDB: Waiting for purge to start
2014-09-12 09:02:11 10300 [Note] InnoDB: 5.6.16 started; log sequence number 5290632
2014-09-12 09:02:11 10300 [Note] Server hostname (bind-address): '*'; port: 3306
2014-09-12 09:02:11 10300 [Note] IPv6 is available.
2014-09-12 09:02:11 10300 [Note] - '::' resolves to '::';
2014-09-12 09:02:11 10300 [Note] Server socket created on IP: '::'.
2014-09-12 09:02:14 10300 [Note] Event Scheduler: Loaded 0 events
2014-09-12 09:02:14 10300 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.6.16' socket: '' port: 3306 MySQL Community Server (GPL)
ca4D
 
Posts: 1
Joined: 12. September 2014 10:08
Operating System: Windows 7, SP 1, 64 Bit

Re: Error after using password for 'root' user

Postby fafster » 27. September 2014 21:45

In the config.inc.php file, have you changed the line to something like this -

$cfg['Servers'][$i]['password'] = 'myNewPassword';

- where 'myNewPassword' matches the password that you've given the user "root" in phpMyAdmin?
fafster
 
Posts: 1
Joined: 27. September 2014 20:25
Operating System: Windows 7


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 120 guests