MySQL Bugs: #116898: could not connect to the database server

Bug #116898	could not connect to the database server
Submitted:	6 Dec 2024 20:36	Modified:	9 Jan 11:00
Reporter:	Lior Bin	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server: Connection Handling	Severity:	S7 (Test Cases)
Version:	8.0.40	OS:	Windows (Microsoft Windows 10 Enterprise)
Assigned to:		CPU Architecture:	Any
Tags:	WBBugReporter

Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\user\AppData\Roaming\MySQL\Workbench\log\wb.log]

$host="localhost";
$port=3306;
$socket="";
$user="root";
$password="";
$dbname="";

$con = new mysqli($host, $user, $password, $dbname, $port, $socket)
	or die ('Could not connect to the database server' . mysqli_connect_error());

//$con->close();

How to repeat:
Ive being trying to put the password in the server settings but couldn't connect to the server

Hi Mr. Bin,

Thank you for your bug report.

Are you reporting a bug in MySQL Workbench, or on the server ???

Why don't you try to connect with mysql command-line client and see whether it works ......

Hi,

Why don't you try with our mysql command line client ....

Find where mysql.exe binary is and then run the following command:

mysql.exe  -uroot -pPassWord -P3306  dbname 

Please replace 'root', 'PassWord' , '3306' and 'dbname' with appropriate value ...

If mysql.exe does not manage to connect, that means that your server was not started.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".