Can't create database from sql file

[bddotnet]

I have an sql file that will create a database for me and populate it with some data I need, but phpMyAdmin gives me the error

#1044 - Access denied for user 'duncanr'@'10.%' to database 'okfqhr'

Why is this happening if I am logging into OPS, clicking on Services, then MySQL, then Administer? Shouldn't it just create the database for me and create the tables and import the data?

Please help! This is of EXTREME IMPORTANCE and needs done ASAP as the entries for the horse show are due October 13.

Thanks!

[bddotnet]

Hopefully they get it fixed soon. My client needs this database information! I submitted a Support Ticket, so hopefully that will resolve the issue.

[HalfaBee]

You can't CREATE a DB via a script, you need to do it in OPS.
The script can create tables etc

[bddotnet]

The sql file that the lady sent me creates the database then the table and then populates the table with the data she needs to retrieve.

How can I modify the sql file so that all it does is create the table and populate the data?

I get #1044 - Access denied for user 'okfqhr'@'10.%' to database 'okfqhr' when I try to import the data from the sql file.

[YvetteKuhns]

You must create a database table name in OPS first. Then you can use sql to create tables or insert data in tables. If you have an existing table and cannot insert (because you get a duplicate entry error, for example), you can drop the table and (re)create it.

[bddotnet]

OK. I opened the sql file in Word and copy/pasted the code into phpMyAdmin and it worked. Thanks everyone!