连接mysql

communication protocols

protocols	types of connections	supported oprating system
TCP/IP	local remote	all
unix socket file	local only	unix only
Named pipe	local only	windows only
shared memory	local only	windows only

TCP/IP connections are supported by any MYSQL server unless the server is started with the --skip-networking option
unix socket file connections are supported by all unix servers
named-pipe connections are supported only on windows if you use one of the servers that has -nt in its name (mysql -nt,mysql -max-nt) However,named pipes are disabled by default.To enable named-pipe connections,you must start the -nt server with the --enable-named-pipe option
shared memory connections are supported by all windows servers .but are disabled by default.To enable shared-memory
connections.you must start the server with the --shared-memory option

常用客户端工具：

mysql: is a general purpose command-line client for sending sql statements to the server.including those of on administrative nature
mysqladmin:is a administrative command-line client that helps you manage the server
mysqlimport:provides a command-line interface to the LOAD DATA INFILE statement it is used to load data files into tables without having to issue LOAD DATA INFILE statements yourself.
mysqldump:is a command-line client for dumping the contents of database and tables it is useful for making backups or for copying databases to other machines

ITPub博客

mysql的连接

最新文章