Databases Reference
In-Depth Information
Figure 2-12. Decompressing the compressed package
as shown in Figure 2-14. Under Windows, executable programs such as
mysqld-nt
have
the extension
.exe
. You can include the full name and extension, as in
mysqld-nt.exe
;
if you leave it out, Windows won't complain. If the program ends immediately, restart
it with the option
no-defaults
:
C:\mysql-5.0.22-win32>
bin\mysql-nt --no-defaults
This tells the server not to expect an options file. We discuss options files in Chapter 11
You may also be prompted by your firewall software to authorize the server to listen
for incoming connections from the network; unless you need to allow connections from
other computers, it's a good idea to keep blocking such connections.
Once the program's started, nothing exciting will happen: you'll just see a blinking
cursor; this command window will remain open as long as the server is running, so to
use any other MySQL command-line programs, you'll need to open another command-
prompt window.
Open another command-prompt window and change to the MySQL directory:
C:\>
cd
C:\mysql-5.0.22-win32
Now, set a password for the database root account (all on one line):
