I am so very lost.

Thinking I might finally try to figure out how to use MySQL as a replacement for Access2007; I think I downloaded everything I needed, including VB support for C++. I'm pretty sure, but not certain.

But for the sake of this likely very absurd question, suppose I am an intelligent being from another planet. Fairly intelligent, just completely ignorant about MySQL. And suppose I've downloaded everything I was supposed to. Now What?

I am in Windows 8.1
I go to RUN, look for All Programs, find MySQL folder, click on it.
This takes me to a selection of 5 alternatives, and I chose MySQL Server 5.6 (not sure why I pick this, but I do)
I choose MySQL Server 5.6 Command Line Client (shows twice, and no other alternatives?)

I am taken to what appears to be an old-school DOS command line black box, and it just says "Enter Password: " with no quotation marks.

Passwords - who knows? A few years ago I tried the same thing and became overwhelmed and gave up. At that time I created (and most importantly recorded) various passwords as I created them for this product. I key in the rather lengthy password, it thinks, then shows an ERROR before blinking out of sight.

I don't have the slightest clue how to get past the Password screen; as I've tried every single word/phrase that resembles a password in my password rolodex.

Suppose I am from the constellation of Orion.
Please tell me exactly how to:
#1 - Eliminate all MySQL files and start over, using Add/Remove Programs in Windows (which I know how to do already). If I need to. How do I know if I should even do this step?
#2 - Make certain I have the correct MySQL version for just one person. (I just want to experiment with import/export with MS Access) Should I download/use Installer, Connector, Workbench, Notifier, for Visual Studio?? I don't have any idea, I'm from Orion, how could I know? I think I might try Visual Studio as a web page design tool; and it is desired that I could use Visual Studio and MySQL together to form a great catalog website - but clearly that is WAY in the future.
#3- How do I start the program? I see no typical Windows icon to click.
#3a - If I have to use the RUN Program via Windows, what program do I select and where should it likely be if it installed into the "default" location?
#4 - How do I create and save an empty MySQL database?
#5 - Once I've saved the empty database and closed it, how do I retrieve it for next time? (Icon? Pathname? If a Pathname, any idea what that might be?

NEVERMIND those fun and games from earlier today..........

I will never be able to accomplish my experimentations without being able to even see the product, let alone open it up and test it's very basic import/export table features.

I've tried to inject a little humor into my note to hide the extreme frustration my ignorance is causing me.

In a flash of inspiration, I checked my "downloads" folder and located:
MySQL-Workbench-Community 6.3.9; with about 29MB of stuff; I clicked and it seems to install MySQL Workbench 6.3 CE; once complete I "Launch Now" to see what happens next!

Well now I have a virgin database. Next, I want to extract info from my Access database. I entered the Access database and did an ODBC export to file.

However, I cannot retrieve/use this file -not yet anyway; and the help here: https://dev.mysql.com/doc/workbench/en/wb-admin-export-import.html makes me .....unpleasant. I am this way because I see no menu linkages that will take me to these menu options. I look further for help here; https://dev.mysql.com/doc/workbench/en/wb-develop-sql-editor-table-export-import.html which refers me back to where I just was - a circular dance of no more help.

I have my new "model" open, I have a table I've named "world" and another virgin table under a different "schema" named "blanker" with the idea of importing my Access table into the shell currently known as "blanker".

I don't know how to enable wizards, or if this is even possible. Regardless, I am beginning to fondly recall why I junked this in the first place a few years ago, as my experience today has been less than great.

Life shouldn't be so hard.

After 5 hours, I have 2 empty tables staring me in the face, with no apparent way to populate them with data I've exported to files from Access. AND the help I've found on Oracles website is not helpful and moreover a circular dance of hopelessness.

Now, the only thing I want to know how to do is get data that has come from one table in an Access 2000/2007 database into a table in a MySQL database that is completely non-formatted.

Can you tell me the keystrokes to accomplish this seemingly infantile task?

Plain English that an intelligent but woefully ignorant alien from another planet could understand would be fantasic. Pretty please?

mysql> CREATE TABLE demo (empno INT);
ERROR 1046 (3D000): No database selected

mysql> create database asktom;
Query OK, 1 row affected (0.01 sec)
mysql> use asktom;
Database changed

mysql> CREATE TABLE demo (empno INT);
Query OK, 0 rows affected (0.06 sec)

mysql> ALTER TABLE demo ADD COLUMN ename VARCHAR(40);
Query OK, 0 rows affected (0.11 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> ALTER TABLE demo ADD COLUMN salary int;
Query OK, 0 rows affected (0.10 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> LOAD DATA INFILE "c:\temp\data.csv"
    -> INTO TABLE demo
    -> COLUMNS TERMINATED BY ','
    -> OPTIONALLY ENCLOSED BY '"'
    -> LINES TERMINATED BY '\n';
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement

mysql> LOAD DATA LOCAL INFILE "C:\temp\data.csv"
    -> INTO TABLE demo
    -> COLUMNS TERMINATED BY ','
    -> OPTIONALLY ENCLOSED BY '"'
    -> LINES TERMINATED BY '\n';
ERROR 2 (HY000): File 'C:       empdata.csv' not found (Errcode: 2 - No such file or directory)

mysql> LOAD DATA LOCAL INFILE "C:\\temp\\data.csv"
    -> INTO TABLE demo
    -> COLUMNS TERMINATED BY ','
    -> OPTIONALLY ENCLOSED BY '"'
    -> LINES TERMINATED BY '\n';
Query OK, 14 rows affected (0.01 sec)
Records: 14  Deleted: 0  Skipped: 0  Warnings: 0

mysql> select * from demo;
+-------+--------+--------+
| empno | ename  | salary |
+-------+--------+--------+
|  7369 | SMITH  |    800 |
|  7499 | ALLEN  |   1600 |
|  7521 | WARD   |   1250 |
|  7566 | JONES  |   2975 |
|  7654 | MARTIN |   1250 |
|  7698 | BLAKE  |   2850 |
|  7782 | CLARK  |   2450 |
|  7788 | SCOTT  |   3000 |
|  7839 | KING   |   5000 |
|  7844 | TURNER |   1500 |
|  7876 | ADAMS  |   1100 |
|  7900 | JAMES  |    950 |
|  7902 | FORD   |   3000 |
|  7934 | MILLER |   1300 |
+-------+--------+--------+
14 rows in set (0.00 sec)