Board index   FAQ   Search  
Register  Login
Board index php forum :: Database MySQL Installation

Where can I Find MYSQL ?

Installation and configuration iussues

Moderators: macek, egami, gesf

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
heri
New php-forum User
New php-forum User
 
Posts: 16
Joined: Sat Mar 13, 2004 6:56 am
Location: Philippines

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

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.
User avatar
swirlee
Moderator
Moderator
 
Posts: 2272
Joined: Sat Jul 05, 2003 1:18 pm
Location: A bunk in the back


Return to MySQL Installation

Who is online

Users browsing this forum: No registered users and 0 guests

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.

cron