Where can I Find MYSQL ?

A

Anonymous

Guest
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
 
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
 
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.
 
You must log in or register to reply here.
Back
Top