Creating a Mysql database

[fahim]

Hi all!

I wish to learn mysql database as it is a must to have working knowledge of database in case of database driven web sites. As a beginner everything is a matter of confusion to me. I searched online to know about how to create a database. I saw different ways. But which is the best way to create a Mysql database? What ways(PhpMyadmin, CLI etc) the professional mysql developer naturally use to create databases in their work? Hope to be helped.

Thanks in advance.

[Wickham]

MySQL is often used with PHP and you can't test PHP on your computer unless you upload everything to your server or unless you install Apache server and PhpMyAdmin on your computer to test locally. I use WampServer http://www.wampserver.com/en/ but you can also use XAMPP, both for Windows PCs. Both give you MySQL and PhpMyAdmin so that you can test locally. PhpMyAdmin will give you access to MySQL.

 

Use a tutorial like http://www.w3schools.com/php/default.asp or http://www.tizag.com/phpT/index.php for PHP and http://dev.mysql.com/doc/refman/5.0/en/tutorial.html for MySQL

[benjaminmorgan]

Have you started learning or know PHP? MySQL, like Wickham said, is more often used with PHP than not.

[fahim]

I am already able to make web application with basic php and trying to grasp OOP in it. I would like to learn about database web application by Mysql along with php. Simply I use phpmyadmin to test my simple application in local server(it is WAMP). But I wish to learn about how professional developers create their database application in web servers generally in their daily job. Which way(phpmyadmin, CLI etc) they use to create their databases?

Thanks.

[benjaminmorgan]

With MySQL PHPMyAdmin is easiest. I haven't learned how to do it the other ways.