Setting up a MySQL database for a website . [control pane] [google]
Q: I am trying how to setup a database for a web-based database type thing, where applications can stuff into the database and will be posted on the web to learn.
For start Im just trying to learn how to setup just a basic Web page to access a database. My current hosting company is Dreamhost and I made an SQL database via their control alredy pane.
Now I looked at a few online tutorials with Google, but they do not really seem to be web-based it seems. They were more for the development of local applications.
I am a programmer, but have not done before DB stuff (opted not in class at school), but I touched MySQL school for a few weeks, but that was a few years ago. So can anyone point me in the direction that will tell me how I can set the MySQL database I created at DreamHost with a webpage Im trying to do just to test it out?
Thanks.
Best Answer: Create a database using mySQL wizard that is given in control panel. Then do the respective coding to connect to the respective database. www.w3schools.com contains great tutorials that can assist you with coding.
Re:Originally posted by: guy
http://www.freewebmasterhelp.com/tutorials/phpmysql
Try that. First link that popped up when you googled mySQL and php.
Thanks I'm going to check it out right now.
Re:http://www.freewebmasterhelp.com/tutorials/phpmysql
Try that. First link that popped up when you googled mySQL and php.
Re:It seems like you've already set up the database. In order to create tables within that database, you can click on the direct link in your Goodies > MySQL page. This link is usually dbname.domainname.com. After logging in you should have access to basically anything you need to create a table. In order to access that database and allow users to manipulate data, you should just check up on some basic mySQL tutorials. Straight out of the box mySQL will not be able to do what you want it to do in terms of having users be able to enter data etc etc.
Re:Originally posted by: SofaKing
do you have cPanel?
http://demodemo.com/1/tutorials/cpanel_xskin_mysql.htm
edit: ah, didn't see you had dreamhost.
hmm, do they have phpmyadmin installed?
Okay well I just looked at that demo. I have already created the actual database through the control panel of dreamhost as well as created an account.
I guess my main question is how do I go about linking the mySQL database to an actual webpage. or where can I find a tutorial how to do that. for now I just want to do a simple link w/like one field, then display everything in the DB on the webpage that I entered the information from.
Re:Originally posted by: guy
if the host doesn't have phpmyadmin, you can try mysqlcc http://sunsite.mff.cuni.cz/MIRRORS/ftp.mysql.com/downloads/mysqlcc.html
To install that on my webspace, will I have to download it and upload it to my webspace, then somehow connect to my webspace through a command prompt and set it up that way?
Re:I don't think it has phpmyadmin with dreamhost … I don't see it in the control panel anywhere.
Re:if the host doesn't have phpmyadmin, you can try mysqlcc http://sunsite.mff.cuni.cz/MIRRORS/ftp.mysql.com/downloads/mysqlcc.html
Re:do you have cPanel?
http://demodemo.com/1/tutorials/cpanel_xskin_mysql.htm
edit: ah, didn't see you had dreamhost.
hmm, do they have phpmyadmin installed?
Related posts
Tags: control pane, google