Where can I Find MYSQL ?

Installation and configuration iussues

Moderators: macek, egami, gesf

heri
New php-forum User
New php-forum User
Posts: 16
Joined: Sat Mar 13, 2004 6:56 am
Location: Philippines
Contact:

Where can I Find MYSQL ?

Postby heri » Sat Mar 13, 2004 7:57 am

I have installed MySQL / Apache / PHP in my XP Machine. However i cannot find MySQL in the programs how can i ran it ? I am using SQL and I just click Enterprise Manager or Querry Analyzer and its okay. Is MYSQL the same as SQL that there are menus to choose from ? Like to create Database etc .... Thanks

User avatar
Redcircle
Moderator
Moderator
Posts: 830
Joined: Tue Jan 21, 2003 10:42 pm
Location: Michigan USA
Contact:

Postby Redcircle » Tue Mar 16, 2004 1:49 am

mysql runs as a service.. it is not a normal program you are probably used to.

On installation it installes itself into the c:\mysql dir. from there you need to run c:\mysql\bin\mysqld -install

to install it as a service.

What I do is manage my sql database with a script through the webserver called phpmyadmin.. http://www.phpMyAdmin.net or http://phpmyadmin.sourceforge.net

User avatar
swirlee
Moderator
Moderator
Posts: 2272
Joined: Sat Jul 05, 2003 1:18 pm
Location: A bunk in the back
Contact:

Postby swirlee » Tue Mar 16, 2004 8:42 am

If you're using WinXP and have admin priveleges, you can go to Settings > Administrative Tools > Services to start, stop or restart any installed service.

Once the service is started, you have to access your database via MySQL client. The distribution comes with one called mysql.exe, which is a command line client. Really this is all you need and I recommend using it for awhile just to get used to writing good SQL (CREATE TABLE is an SQL query, not a menu option, and all checkboxes, drop-downs, and radio buttons are going to get you is an inefficient table structure). Once you've gotten good at writing SQL by hand, then you can graduate to a more robust client, such as phpMyAdmin or (my personal preference) MySQLCC.


Return to “MySQL Installation”

Who is online

Users browsing this forum: No registered users and 0 guests