Keep Getting ERROR When Creating New DB???

[kev100]

I'm all logged in just fine. I can see my current db on the list...edit it etc.

However, when entering anything in the "create a new database" field and click Create....I keep gettting:

#1044 - Access denied for user: 'myusername@%'


Don't know why....I'm already logged in. But...I do noticed that in the error message, there is a @% added to the end of my user name.

Am I using the wrong process....wrong area....etc?

Thanks

[FAK3R]

I don't think you have acess to creat a new databse on phpmyadmin, you have to use ops center to do that.
But if what you meant was creating tables, then I guess it's a permissions problem that needs to be dealt with :confused:

[BerksWebGuy]

Create another DB through OPS...under the billing tab...then give it a user under the MySQL tab.

[kev100]

Thanks....I think I got it....

But...to be sure I'm not doing more that I need.......

I have to set up a whole new sql "area" for each database.....and then create users for it (login name(s) and passwords(s))...etc?


Thanks

[BerksWebGuy]

Well...the area is actually another database with unique space, data, users, etc.

If you want the same space, data, users, etc...just make another table in your current DB.

[kev100]

Yes....I see......thanks.

I'm pretty familar with flat databases (basically an sql db with just 1 table), but, I'd like to better understand the application and logic of a relational database (which I assume is 1 sql db with multiple tables...which are used in sort of a 3-dimensional manner).

Do you know of a good tut / reference site for learning the basics and advantages of the *relational* aspect of sql?

Thanks Much !