Monday, December 19, 2011

MySQL database question!!?

OK - I'm building a website at the moment, and I want it to send the info to a MySQL database (you get 10 from GoDaddy), but (and this is probably a stupid question, because this the first ever time I've tried this), I don't have any database software onmy PC - I don't have Access.





Can you tell me if I need one, or is the database online? Like GoogleDocs, but not?





I don't think I'm very good at explaining so: Is the MySQL database with all of the data, accessed on the internet?





Please help!|||Most administration menu's ive used contain phpMyAdmin. I think godaddy uses cPanel for all it's user's admin. You should have been given a URL you can visit to access yours - if not 9 times out of 10 you can get to it by visiting:


yourdomain.com/cpanel





Once your in this menu click "MySQL Databases".





This screen allows you to create a new database, a new database user and then assign the user to a specific database (you need to do this).





At the bottom of that page you can also click "phpMyAdmin", which will open the database administration panel. The options on this screen allow you to setup tables and column/fields to store your data.





Once you have a database setup you need some server-side software that can handle data you wish to store/retrieve (PHP recommended). Through this you can connect to your database with your username and password and run queries using PHPs mysql functionality.


http://uk3.php.net/mysql








Of course all this has assumed you know a little about server-side scripting, databases and how to structure them and their queries?





If not you need to read up on some php/mysql tutorials (or get someone else to do it) - theres too much information to even give a "general" outline on the whole process in this answer -of course if you get stuck on something specifically you can always ask another question :-)





Hope this helps.|||If you're building a website that accesses the online database, you should have some way of updating the database via the website administration pages. Presumably you're using some sort of content management system, so you can use the CMS to update the database.





Access wouldn't help you. If you create the data on your home computer, you will somehow need to get it into the online database. Really, the best way is via your CMS.|||I don't know if you read your own question but you just aid "you get 10 from GoDaddy". This implies that "the MySQL database with all of the data, accessed on the internet"





GoDaddy should offer some kind of web interface, probably PhpMyAdmin. If not, you could use Open Source software to connect remotely to the databases, if that's allowed.





I recommend you check out GoDaddy's FAQs, I'm sure they have a whole section on MySQL.





Good luck, MySQL is sensational :)

No comments:

Post a Comment