A few basic questions. Begining usage of MySQL database and connecting with ASP.Net

[Richard233]

I'm sure some of these have been asked before, so please bear with me as I'm new
to working this way.

I was able to use the wizard to create the database and user.
How do I go about actually working with it now? Things like creating the tables and stored procedures
and viewing the structure of the database, simple queries and so forth.

After I have the database, how would I go about accessing it from the asp.net code?
Usually I have an ODBC connection on a windows machine that I use to refer to the database,
but that is on a company machine for company work. Now I'll be accessing it on server I do not have direct
access to, with a different OS, etc.

I have no problem creating a localized version of the database first if that is what is needed, but I would
consider that a sub-optimal solution since I do intend that the database will have some tables that get modified
via use.

Thank you in advance for you time, effort, and patience.

Richard

 

[Infopro]

Re: A few basic questions. Begining usage of MySQL database and connecting with ASP.

To work with a MySQL database in cPanel you'd use phpMyAdmin. There's a link for this in your cPanel.

You might want to do some digging on the forums here for ASP.Net threads to see if any of those is helpful.

 

[Richard233]

Re: A few basic questions. Begining usage of MySQL database and connecting with ASP.

Thanks. The admin panel info helped a bit. Thought it was just an alternative to the other link.
Running very slow though, not sure why.

I'm still seeking a good example of a simple connection but have not found one yet. :-(

To work with a MySQL database in cPanel you'd use phpMyAdmin. There's a link for this in your cPanel.

You might want to do some digging on the forums here for ASP.Net threads to see if any of those is helpful.