1046 error

[erina1423074]

Hi,

I am also getting a 1046 no database selected error when I try to cut and paste the database in.

I tired to click on one of the options on the side, as advised in the post below, but it did not work. Mine looks totally different to the other guy who had the same problem...have I done something wrong?

E

[Jason Byrnes]

your screen shot is showing the tables of the information_schema database. The information_schema database is the MySQL system database.

click the home button to get out of the information_schema database and create a new one.

[erina1423074]

Thanks for your advice Jason.

This may seem like the dumbest question ever asked on the forum. But I clicked on the home button and don't see where/what I need to do to start a new database....can you help?

E

[Jason Byrnes]

is this your local testing server? Or is it a remote server?

If it is a remote server, contact the host for details on creating a new database.


If it is a local testing server, you will need to login using the root user to create a new database.

[erina1423074]

I'm so sorry....please excuse my noobie-ness

How do I know if I am on the local or remote?

[Jason Byrnes]

a local testing server is a server that you install on your local computer.


the remote server is your Hosts server, where your website will be installed for the world to access it.



If it is a local server, the domain used to access the database using PHPMyAdmin will be localhost.

[erina1423074]

OH....nevermind. I figured out it was local. I called my host and they helped me get back on the road.

Thanks so much Jason