Basic MySQL Question

[rcresume]

How do I create tables in MySQL?

I see you have MySQL here at x10hosting and I would like to use it. I'm fairly experienced with MySQL from using it in the past. I found the cPanel area for creating MySQL databases and users and that was very straightforward to use. However, I don't see any way to create tables within the databases, populate the tables, query the tables and so forth.

Am I supposed to create tables, etc.via php programs or is there some way to access my new database via a command prompt or other interface?

Also, what version of MySQL is x10hosting running? I'd love to create a database or two to support my website so I'd appreciate any information you can give me on accessing my new databases so that I can build their tables.

 

[descalzo]

phpMyAdmin will allow you to add/modify/drop tables to a database.
You can also us SQL to query, etc the databases there.
And add rows manually.
If you have data from a mysql "dump", you can import it there.


It is located on the cPanel.

It shows that they are running 5.0.87 on the server

 

[rcresume]

Thank you!

Is there any way to get to a MySQL command prompt for my new database on x10hosting?

 

[descalzo]

Nope. Shell access is not allowed.
phpMyadmin or your PHP/Perl/Python script will have to do.