79625

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.6\bin\mysqlshow"

C:\>"C:\Program Files\MySQL\MySQL Server 5.6\bin\raysqlshow" -u root mysql

C:\>"C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqladmin" version status proc

C:\>"C:\Program Files\MySQL\MySQL Server 5.6\bin\raysql" test

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 mysąld with the —skip-name-resolve [454] option and use

only localhost and IP addresses 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 --

pipę [221] or --protocol=PIPE [221] option, or by specifying . (period) as the host name. Use

the —socket [221] option to specify the name of the pipę if you do not

want to use the default pipę

name.

Notę 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 to connect with the MySQL Server. See Section 4.2.2, “Connecting to the MySQL Sewer”.

For morę information about mysqlshow, see Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”.

Wyszukiwarka

Podobne podstrony:
Using SMF to manage your MySQL installation Once installed, you can start and stop your MySQL server
Choosing a Distribution Format After choosing which version of MySQL to install, you should decide w
mysąid— The MySQL Server mysqld, also known as MySQL Server, is the main program that does most of t
print setup Print Setup Configure printer 0 Portrait Q Landscape You can specify how much each page
skanowanie0014 (47) • The communicative teaching is marked by an atmosphere of using and working wit
MySQL Cluster Overview MySQL Cluster is a technology that enables clustering of in-memory databases
27 (218) Modeling Workflows 73 First, the complaint is evaluated by a complaint manager of depart-me
skanowanie0014 (47) • The communicative teaching is marked by an atmosphere of using and working wit
.łve image • Image Matę The solution(s) to a pair of simultaneous linear equations is ali pairs (if
Extracting the Install Archive To install MySQL manually, do the following: 1.    If
Installing ActiveState Perl on Windows On Windows, you should do the following to install the MySQL
Installing MySQL on Mac OS X Using Native Packages You can install MySQL on Mac OS X 10.3.x (“Panthe
Perl Installation Notes The Perl dbi module provides a generic interface for database access. You ca
Running MySQL in ANSI Modę You can tell mysąldto run in ANSI modę with the --ansi[428] startup optio
MySQL Proxy Command Options To start MySQL Proxy, you can run it directly from the command linę: she
Using MySQL Proxy There are a number of different ways to use MySQL Proxy. At the most basie level,
Slip Stitch Patterns Whether the are worked in 4 the same or difTerent colors, you can aeate

więcej podobnych podstron