首页 > Linux操作系统 > Linux操作系统 > mysql连接


原创 Linux操作系统 作者:yu5782647 时间:2013-11-23 14:00:42 0 删除 编辑

    communication protocols
    protocol                  types of connections             supported
    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 connection are supported any mysql server
   unless the server is started with --skip-networking option
   unix socket file connects are supported by all unix servers.
   named-pipe connections are support only on windows and only 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 --enable-named-pipe option.
   shared-memory connections are supported by all windows servers.but are disables by default to
   enable shared-memory connections,you must start the server with the --shared-momory option.
 mysql 常用客户端工具
  mysqlimport  proviides a command-line interfact to the load data infile statement.
  mysqldump  for dumping the contents of database and tables. it's useful for making backups or for copying database to other machines.
  mysql -uroot -p -h localhost -S /tmp/mysql3306.socket -P 3006

来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

上一篇: mysql 源码目录
下一篇: mysql查看帮助
请登录后发表评论 登录


  • 博文量
  • 访问量