"did you select a database in the list of databases in PHPMyAdmin before going to the SQL tab and executing the SQL statement?"
No, I didn't. I selected test and the sql data is part of the test database. But I presume that isn't what is needed. I then went to MySQL localhost and created a new database called users. Next I selected the SQL tab and copied the users.sql table into the "Run SQL query/queries on server "localhost":" field and selected GO. users now shows up as a database. Is this the correct procedure?