- 1.5 Installing MySQL from a noinstall Zip Archive
- 1.5.1 Extracting the Install Archive
- 1.5.2 Creating an Option File
- 1.5.3 Selecting a MySQL Server Type
- 1.5.4 Starting the Server for the First Time
- 1.5.5 Starting MySQL from the Windows Command Line
- 1.5.6 Starting MySQL as a Windows Service
- 1.5.7 Testing The MySQL Installation
You can test whether the MySQL server is working by executing any of the following commands:
C:\>"C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqlshow"C:\>"C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqlshow" -u root mysqlC:\>"C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqladmin" version status procC:\>"C:\Program Files\MySQL\MySQL Server 5.1\bin\mysql" test
Note
By default, mysqlshow will try to connect
using the ODBC user. This user is not
created by default. You should specify a valid user, or
root with the right password to check the
operation of the server.
If mysqld is slow to respond to TCP/IP
connections from client programs, there is probably a problem
with your DNS. In this case, start mysqld
with the --skip-name-resolve
option and use only localhost and IP numbers
in the Host column of the MySQL grant tables.
You can force a MySQL client to use a named-pipe connection
rather than TCP/IP by specifying the
--pipe or
--protocol=PIPE option, or by
specifying . (period) as the host name. Use
the --socket option to specify
the name of the pipe if you do not want to use the default pipe
name.
Note that if you have set a password for the
root account, deleted the anonymous account,
or created a new user account, then you must use the appropriate
-u and -p options with the
commands shown above in order to connect with the MySQL Server.
See Connecting to the MySQL Server.
For more information about mysqlshow, see mysqlshow.
