MySQL Workbench "Failed to connect"?

[SoftwareNinja]

Hey there, so I am new to SQL and wondering why my connection failed when testing?

 

This is the message that popped up while testing:

 

[dannytech357]

Are you attempting to use SQL or MySQL? In your description, you reference trying to connect to a SQL server, but the app you're using is for MySQL, and they are not the same thing.

[jj9987]

To be clear....are you running a MySQL server in your PC?

[SoftwareNinja]

1 minute ago, dannytech357 said:

Are you attempting to use SQL or MySQL? In your description, you reference trying to connect to a SQL server, but the app you're using is for MySQL, and they are not the same thing.

I'm completely new to MySQL, SQL. Literally I have no fucking idea what I'm doing but trying to learn!

[SoftwareNinja]

2 minutes ago, jj9987 said:

To be clear....are you running a MySQL server in your PC?

I have no clue what I am doing man, if you can point me in the right direction please do.

[dannytech357]

If you want to use SQL, download SQL Server, and that's pretty much all you need to be able to learn SQL, if you want to learn MySQL (which is generally used in things like web applications and such), download MySQL, and use a MySQL client like the one in the picture you posted.

[SoftwareNinja]

Just now, dannytech357 said:

If you want to use SQL, download SQL Server, and that's pretty much all you need to be able to learn SQL, if you want to learn MySQL (which is generally used in things like web applications and such), download MySQL, and use a MySQL client like the one in the picture you posted.

Which would be best creating game Login Data bases?

[dannytech357]

Up to you, they are both performant, and it really depends on what you're writing the backend in. If you are using something like PHP, go with MySQL, or if you're using a .NET backend like with C#, use SQL.

[TickleForce]

If you're new to SQL, you could try using SQLite. It simply reads/writes using a file and doesn't require an extra process to be running like other databases do. If you don't expect for the database to have a heavy load, you probably don't need a big database like MySQL.

Many programming languages have support for SQLite built in. Python, for example, has it built in so you don't need to install anything extra. PHP does as well.

[Organized]

Install XAMPP, it includes a MySQL Server. You can then use MySQL Workbench or phpmyadmin.