Install dependent software

This topic describes how to install a MySQL client and netcat.

Install a MySQL client

MySQL clients are used to access OceanBase Database. You must install a MySQL client on each host in which you want to deploy OceanBase Database.

1. To install a MySQL client, run the following command as the root user:

   yum install mysql -y
   

2. Run the following command to connect to the server, so as to check whether the client is installed:

   mysql -h<HostIP> -u<UserName> -p<password> -P<Port>
   

Install netcat

netcat is used to check the status of OBProxy. You must install netcat on each host in which you want to deploy OBProxy.

1. To install netcat, run the following command as the root user:

   yum install -y nc
   

2. Run the following commands to check whether netcat is installed:

   nc -h
   
   ## output
   Ncat 6.40 ( http://nmap.org/ncat )
   Usage: ncat [options] [hostname] [port]
   
   Options taking a time assume seconds. Append 'ms' for milliseconds,
   's' for seconds, 'm' for minutes, or 'h' for hours (e.g. 500ms).
     -4                         Use IPv4 only
     -6                         Use IPv6 only
     -U, --unixsock             Use Unix domain sockets only
     -C, --crlf                 Use CRLF for EOL sequence
     -c, --sh-exec <command>    Executes the given command via /bin/sh
     -e, --exec <command>       Executes the given command
         --lua-exec <filename>  Executes the given Lua script
     -g hop1[,hop2,...]         Loose source routing hop points (8 max)
     -G <n>                     Loose source routing hop pointer (4, 8, 12, ...)
     -m, --max-conns <n>        Maximum <n> simultaneous connections
     -h, --help                 Display this help screen
     -d, --delay <time>         Wait between read/writes
     -o, --output <filename>    Dump session data to a file
     -x, --hex-dump <filename>  Dump session data as hex to a file
     -i, --idle-timeout <time>  Idle read/write timeout
     -p, --source-port port     Specify source port to use
     -s, --source addr          Specify source address to use (doesn't affect -l)
     -l, --listen               Bind and listen for incoming connections
     -k, --keep-open            Accept multiple connections in listen mode
     -n, --nodns                Do not resolve hostnames via DNS
     -t, --telnet               Answer Telnet negotiations
     -u, --udp                  Use UDP instead of default TCP
         --sctp                 Use SCTP instead of default TCP
     -v, --verbose              Set verbosity level (can be used several times)
     -w, --wait <time>          Connect timeout
         --append-output        Append rather than clobber specified output files
         --send-only            Only send data, ignoring received; quit on EOF
         --recv-only            Only receive data, never send anything
         --allow                Allow only given hosts to connect to Ncat
         --allowfile            A file of hosts allowed to connect to Ncat
         --deny                 Deny given hosts from connecting to Ncat
         --denyfile             A file of hosts denied from connecting to Ncat
         --broker               Enable Ncat's connection brokering mode
         --chat                 Start a simple Ncat chat server
         --proxy <addr[:port]>  Specify address of host to proxy through
         --proxy-type <type>    Specify proxy type ("http" or "socks4")
         --proxy-auth <auth>    Authenticate with HTTP or SOCKS proxy server
         --ssl                  Connect or listen with SSL
         --ssl-cert             Specify SSL certificate file (PEM) for listening
         --ssl-key              Specify SSL private key (PEM) for listening
         --ssl-verify           Verify trust and domain name of certificates
         --ssl-trustfile        PEM file containing trusted SSL certificates
         --version              Display Ncat's version information and exit
   
   See the ncat(1) manpage for full options, descriptions and usage examples