First time using MySQL on my windows laptop, what is the proper configuration?
Do I need to (can I) enable key based ssh login to use MySQL on my laptop? Why would I or wouldn't I need/want to? Is this just a Linux thing? I will be building an ASP .NET 3.5/4.0 application, using visual studio. I will be hosting it on GoDaddy and one of the techs highly recommended MySQL vs. MS SQL (which I'm more familiar with, but I'm sure I can figure out MySQL)
Dave Baldwin
If it is local on your laptop, you don't need a shell login to MySQL. It has a command line program called 'mysql' that you can use. You can also install MySQL WorkBench which is roughly like SSMS. Access to MySQL is thru accounts that specify username, password, and host (source). There are a lot of MySQL tutorials on the web. The SQL part is like SQL Server but the management and user set up is different.
ASKER
@DaveBaldwin: Thank you. So, (and I will research the specifics), to get started, do I need to install the MySQL cluster (which I'm currently in the middle of installing, but stopped to ask about enabling key based SSH login etc.) and the MySQL Workbench? Or another way to put it is: What minimum components would I need on my laptop to get started?
When you are done with dev/testing on your laptop, and are ready to move everything over to the production server, it might be a good idea to use SSH at that point
Nobody can brute-force-password their way into the MySQL side of things if the MySQL server does not allow any kind of password authentication in the first place
Nobody can brute-force-password their way into the MySQL side of things if the MySQL server does not allow any kind of password authentication in the first place
ASKER
@Kaffiend: Thank you. Same question to you: What are the minimum components that I need on my laptop to get started? MySQL Workbench? Anything else?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you for your help / input.
You're welcome, glad to help.