8 mysql支持的连接协议及操作过程

本章主要讲述mysql支持的几种连接方式，也将对这几种方式进行操作演示

补充一点，mysql启动没有

mysql启动没有
ywx@ywx:~$ cd /opt/mysql5151/
ywx@ywx:/opt/mysql5151$ ./bin/mysqld_safe --defaults-file=./my.cnf --user=ywx &
[1] 8333
ywx@ywx:/opt/mysql5151$ 110804 08:40:52 mysqld_safe Logging to

'/opt/mysql5151/data/ywx.err'.
110804 08:40:52 mysqld_safe Starting mysqld daemon with databases from /opt/mysql5151/data

ywx@ywx:/opt/mysql5151$ ./bin/mysqladmin --defaults-file=./my.cnf ping
mysqld is alive

1. 首先看看mysql支持的连接协议
   在linux OS上，只支持 TCP/IP 和 socket 协议
   TCP/IP ：  支持所有的OS
   socket ： 只支持 本地连接，只支持类unix linux OS


 几种协议的具体介绍




linux，下面将对 TCP/IP 和 socket 协议进行操作


首先启动 mysql 服务

ywx@ywx:/opt/mysql5151$./bin/mysqld_safe --defaults-file=./my.cnf --user=ywx &

1. 对 socket协议进行操作

  1. cd /tmp/  下
  2. 查看内容，注意有个 mysql.sock，这就是我们需要连接的文件

ywx@ywx:/tmp$ ls
keyring-qBd4di  pulse-PKdhtXMmr18n  VMwareDnD
mysql.sock      pulse-vW0CAOZ7PouR  vmware-root
orbit-gdm       ssh-pogBWO1710      vmware-ywx
orbit-ywx       virtual-ywx.E2YEf7

   3.操作

ywx@ywx:/tmp$ /opt/mysql5151/bin/mysql --defaults-file=/opt/mysql5151/my.cnf -S
./mysql.sock --protocol=xx  //敲入一个随便的，提示只能有4中连接方式
Unknown option to protocol: xx
Alternatives are: 'TCP','SOCKET','PIPE','MEMORY'
ywx@ywx:/tmp$

ywx@ywx:/tmp$ /opt/mysql5151/bin/mysql --defaults-file=/opt/mysql5151/my.cnf -S
./mysql.sock --protocol=socket 敲入socket，成功连接
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.1.51bbk Source distribution

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

 2. tcp连接方式
 

ywx@ywx:/tmp$ /opt/mysql5151/bin/mysql --defaults-file=/opt/mysql5151/my.cnf -h localhost
--protocol=tcp
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.1.51bbk Source distribution

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

 远程tcp连接方式

-u[用户名] -p(密码) -h [主机名，也可以是IP地址] -P [端口号]
-u root -p -h localhost -P 3306

ywx@ywx:/opt/mysql5151$ ./bin/mysql --defaults-file=./my.cnf -u root -p -h localhost -P 3306
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 13
Server version: 5.1.51bbk Source distribution

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>