Can't connect to server on 'localhost' (10061) - Windows 10 MariaDB 11.2 - Source

Revision: 134248
User: David Bolton
Date: 2024-01-15 19:42

I have searched for a solution to this issue without success.  Background - Very new to MariaDB, migrating from Access.  I attempted to migrate the MariaDB database(s) from the default datadir (C:\Program Files\MariaDB 11.2\data) to drive E (E:\MariaDB\Data) by changing the "my.ini" file "datadir=" line.  To be clear, I first exited dbForge Studio for MySQL and HeidiSQL (both of which I have been using to explore, create, modify test databases) before starting this process. I copied the database folders to the newly created directory on E:, then saved the original "my.ini" file as "my.ini.original", then edited the .ini file and saved the edited .ini file as "my.ini" (all in C:\Program Files\MariaDB 11.2\data), then stopped mysql.exe from Task Manager.   BTW, stopping "mysql.exe" in Task Manager completely removed it from the services list, which I did not expect.  I thought it would just "stop" but in fact was removed from the list.  I am actually operating remotely via Chrome Remote Desktop but AFAIK this has never been an issue with MariaDB or any other programs that I run.

When I attempted to restart mysql from the default bin folder, I got that error msg.  I replaced the edited my.ini file with the original (by renaming both), but still received the same error.  I am logged in as Administrator and have checked Admin privileges of all relevant folders and have full control.  I tried starting mysql.exe and mariadb.exe from the bin folder as well as from a command prompt (as Administrator).  On command line, I get "ERROR 2002 (HY000): Can't connect to server on 'localhost' (10061)".  I have not rebooted the PC.  That is something I will try but since I am connected by Chrome Remote Desktop, I'm not sure that I will be able to reconnect.  That will put further testing off until I am back in the office tomorrow.

I'm sure this is something simple, but I am at a loss at this point. I appreciate any assistance any one can provide.

BTW, the error log file in the "new" directory shows the following after the attempt to restart mysql.exe:

2024-01-15 11:52:45 0 [Note] Starting MariaDB 11.2.2-MariaDB source revision 929532a9426d085111c24c63de9c23cc54382259 as process 904
2024-01-15 11:52:45 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-01-15 11:52:45 0 [Note] InnoDB: Using transactional memory
2024-01-15 11:52:45 0 [Note] InnoDB: Number of transaction pools: 1
2024-01-15 11:52:45 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2024-01-15 11:52:45 0 [Note] InnoDB: Initializing buffer pool, total size = 95.824GiB, chunk size = 1.497GiB
2024-01-15 11:52:45 0 [Note] InnoDB: Completed initialization of buffer pool
2024-01-15 11:52:47 0 [Note] InnoDB: File system buffers for log disabled (block size=4096 bytes)
2024-01-15 11:52:47 0 [Note] InnoDB: End of log at LSN=62431194948
2024-01-15 11:52:47 0 [Note] InnoDB: Opened 3 undo tablespaces
2024-01-15 11:52:47 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
2024-01-15 11:52:47 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
2024-01-15 11:52:47 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
2024-01-15 11:52:47 0 [Note] InnoDB: log sequence number 62431194948; transaction id 12187
2024-01-15 11:52:47 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-01-15 11:52:47 0 [Note] InnoDB: Loading buffer pool(s) from E:\MariaDB\Data\ib_buffer_pool
2024-01-15 11:52:47 0 [Note] mariadbd.exe: SSPI: using principal name 'localhost', mech 'Negotiate'
2024-01-15 11:52:47 0 [Note] Server socket created on IP: '::'.
2024-01-15 11:52:47 0 [Note] Server socket created on IP: '0.0.0.0'.
2024-01-15 11:52:47 0 [Note] mariadbd.exe: Event Scheduler: Loaded 0 events
2024-01-15 11:52:47 0 [Note] C:\Program Files\MariaDB 11.2\bin\mariadbd.exe: ready for connections.
Version: '11.2.2-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
2024-01-15 11:52:52 0 [Note] InnoDB: Buffer pool(s) load completed at 240115 11:52:52
2024-01-15 11:53:00 0 [Note] console_event_handler: received CTRL_CLOSE_EVENT event, terminating

Answer

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

Can't connect to server on 'localhost' (10061) - Windows 10 MariaDB 11.2 - Source

Answer

Products

Services

Pricing

Resources

About Us

Download MariaDB