ITPub博客

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

mysql连接

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

--连接mysql
    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 常用客户端工具
  mysql
  mysqladmin
  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博客 ” ,链接:http://blog.itpub.net/24577884/viewspace-777407/,如需转载,请注明出处,否则将追究法律责任。

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

注册时间:2013-05-15

  • 博文量
    32
  • 访问量
    221019