Where can I Find MYSQL ?

Installation and configuration iussues

Moderators: egami, macek, gesf

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

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
Posts: 826
Joined: Tue Jan 21, 2003 10:42 pm
Location: Michigan USA

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
Posts: 2257
Joined: Sat Jul 05, 2003 1:18 pm
Location: A bunk in the back

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.

Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 0 guests