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

Richard233

Registered
Mar 17, 2011
2
0
51
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

Well-Known Member
May 20, 2003
17,076
523
613
Pennsylvania
cPanel Access Level
Root Administrator
Twitter
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

Registered
Mar 17, 2011
2
0
51
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.