How can I install MySQL and manage it?

webdevRefinery Forum: How can I install MySQL and manage it? - webdevRefinery Forum

Hide message

Show message

Welcome!

Mean coders suck. Learn from nice ones.

Join up (it's free!) whether you're just starting out or you're crazy advanced. Get tips from people who know what they're talking about, without being treated like the playground smelly kid. Because seriously, your school classes didn't teach you anything you wanted to know.

Hide message

View New Content
Pick a background

Cartoon Clouds Mountains Sunrise Clouds Green Clouds None

Page 1 of 1

You cannot start a new topic
You cannot reply to this topic

renewaltopics

Group: Members
Posts: 53
Joined: 25-March 12
Expertise:HTML,PHP,Javascript,SQL

Posted 12 May 2012 - 04:52 PM (#1)

How can I install MySQL and manage it?

What program do I use to manage a database?

Hi, I downloaded the MySQL installer from mysql.com . What im trying to do is create a database, create a table and connect the coding to webpage via
SQL codes. Do i use the workbench program that it installed? There is also a MySql Line command prompt. Which of these programs
can i use to create a database file and create a table in the database file? Then, how do I connect the database, via SQL codes?

I'm using IIS if that helps.

Thanks!

Qasim

Group: Members
Posts: 520
Joined: 25-October 10
LocationOntario, Canada
Expertise:HTML,CSS,PHP,Java,Javascript,Graphics

Posted 12 May 2012 - 04:59 PM (#2)

If you would like to access it from a webpage, you will need a server-side language also installed on whatever you are using to host your website. Do you have PHP or another language that supports MySQL installed? From there, we can help you

Qasim Iqbal
[HTML] [CSS] [JS] [PHP] [JAVA]
[ANDROID DEVELOPER] [CHROME WEB STORE DEVELOPER]
[WEBSITE] [FACEBOOK] [FORRST]

renewaltopics

Group: Members
Posts: 53
Joined: 25-March 12
Expertise:HTML,PHP,Javascript,SQL

Posted 12 May 2012 - 05:00 PM (#3)

Yes, i have PHP installed already.

On IIS

Nand

Group: Members
Posts: 36
Joined: 24-February 12
Expertise:PHP,SQL

Posted 12 May 2012 - 05:11 PM (#4)

I suggest you take a look at http://php.net/manua...book.mysql.php.

renewaltopics

Group: Members
Posts: 53
Joined: 25-March 12
Expertise:HTML,PHP,Javascript,SQL

Posted 12 May 2012 - 05:13 PM (#5)

That link is invalid

NeilHanlon

Group: Members
Posts: 884
Joined: 08-July 10
LocationRowley, Massachusetts
Expertise:HTML,CSS,PHP,Java,Graphics

Posted 12 May 2012 - 06:10 PM (#6)

And... you didn't notice to just remove the period from the end of it because...?

Anyways, don't use the mysql_ extension. It's outdated:

http://webdevrefiner...ysql-code-sucks

SapporoGuy

Group: Members
Posts: 911
Joined: 10-June 11
LocationSonyLand

Posted 12 May 2012 - 07:02 PM (#7)

Are you osx or windows?
Do you want to learn from the beginning or just interested and want to get your feet wet?

Daniel15

dan.cx

Group: Moderators
Posts: 3415
Joined: 17-April 10
LocationMelbourne, Australia
Expertise:HTML,CSS,PHP,Java,Javascript,Node.js,SQL

Posted 12 May 2012 - 11:59 PM (#8)

You can use the MySQL workbench, I think it's pretty good (although I last used it a few years ago). What server-side programming language do you want to use (for example, PHP, ASP.NET, Ruby, Python, etc.)?

Quote

Are you osx or windows?

They mentioned IIS so I assume it's on Windows.

Daniel15! :D

Repeat after me: jQuery is not JavaScript. It is not the answer to every JavaScript-related question. When you have to write some JavaScript, do not instantly react with "Oh, I'll do that with jQuery!"

Spoiler

javascript:alert((''+[][[]])[!+[]+!+[]]+(![]+[])[+!+[]]+(''+!+[]/[])[+!+[]]+([![]]+[][[]])[+!+[]+[+[]]]+(''+!![])[+!+[]+!![]+!![]]+(![]+[])[!+[]+!+[]]+(+!+[])+(!+[]+!+[]+!+[]+!+[]+!+[]))

Kyek, on 16 November 2011 - 11:14 AM, said: