After setting up the computer and installing the Web server, you’re ready to
install MySQL. You need to install MySQL before installing PHP because you
need to provide the path to the MySQL software when you install PHP.
But before installing MySQL, be sure that you actually need to install it. It
might already be running on your computer, or it might be installed but not
running. For instance, many Linux distributions automatically install MySQL.
Here’s how to check whether MySQL is currently running:
 Linux/Unix/Mac: At the command line, type the following:
ps –ax

The output should be a list of programs. Some operating systems (usually
flavors of Unix) have different options for the ps command. If the
above comment does not produce a list of the programs that are running,
type man ps to see which options you need to use.
In the list of programs that appears, look for one called mysqld.
 Windows: If MySQL is running, you should see it in your system tray at
the bottom of your screen, possibly as a traffic signal with a green light.
If you cannot find an icon for it, it’s probably not running.
Even if MySQL isn’t currently running, it might be installed, just not started.
Here’s how to check to see whether MySQL is installed on your computer:
 Linux/Unix/Mac: Type the following:
find / -name “mysql*”
If a directory named mysql is found, MySQL has been installed.
 Windows: Look for a program called WinMySQLadmin, which starts and
stops MySQL, among other functions. You might be able to find it on the
Start menu (choose Start➪Programs). If not, look for it in a MySQL directory,
which is probably at c:\mysql\bin.
If MySQL is installed but not started, here’s how to start it:

1. Change to the directory mysql/bin.
This is the directory that you should have found when you were
checking whether MySQL was installed.
2. Type safe_mysqld &.
When this command finishes, the prompt is displayed.
3. Check that the MySQL server started by typing ps -ax.
In the list of programs that appears, look for one called mysqld.
1. Start the WinMySQLadmin program.
If you can’t find it on the menu, navigate to the program, which is
probably at c:\mysql\bin\winmysqladmin.exe, and then
double-click it.
2. Right-click in the WinMySQLadmin window.
A submenu appears.
3. Select the menu item for your operating system — Win 9x or Win
NT (which includes Win 2000 and XP).
4. Click Start the Server.

Post By Editor (2,827 Posts)

Website: →