SQL workbench Unable to connect to 127.0.0.1:3306 (2003)

hello all i am currently taking a course in database management and im to be using SQL workbench i have downloaaded it from this link:


and i want to create a SQL script but i cant connect to the local server to see if it runs properly on the database I keep getting this error “Unable to connect to 127.0.0.1:3306 (2003)”
aparently its a problem with configuring the database software on linux but i havent found any related articles on ask fedora
anyone know how to fix the error?

Hello,
Do you have running SQL daemon (systemctl status…)
Try in console: telnet 127.0.0.1 3306

Regards.

1 Like

so i rans systemctl and used grep to find this:
@roberts-computer-privatehost-privatedomain ~]$ systemctl status mysqld
● mysqld.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: failed (Result: exit-code) since Wed 2020-10-14 11:49:26 MDT; 3h 1min ago
Docs: man:mysqld(8)
http://dev.mysql.com/doc/refman/en/using-systemd.html
Process: 912212 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
Process: 912262 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS (code=exited, status=1/FAILURE)
Main PID: 912262 (code=exited, status=1/FAILURE)
Status: “Data Dictionary upgrade from MySQL 5.7 in progress”
CPU: 7.916s

Oct 14 11:49:07 roberts-computer-privatehost-privatedomain systemd[1]: Starting MySQL Server...
Oct 14 11:49:26 roberts-computer-privatehost-privatedomain systemd[1]: mysqld.service: Main process exited, code=exited, status=1/FAILURE
Oct 14 11:49:26 roberts-computer-privatehost-privatedomain systemd[1]: mysqld.service: Failed with result 'exit-code'.
Oct 14 11:49:26 roberts-computer-privatehost-privatedomain systemd[1]: Failed to start MySQL Server.
Oct 14 11:49:26 roberts-computer-privatehost-privatedomain systemd[1]: mysqld.service: Consumed 7.916s CPU time.
1 Like