Skip to main content

updgradeShell-ConnectDB

SQL connect my mac

mysql -u root -h 192.168.155.118 -p --ssl-mode=DISABLED

Run:

mysql --version

If you see something like:

mysql Ver 14.14 Distrib 5.5.xx

or

mysql Ver 15.1 Distrib 10.x-MariaDB

→ then it’s an old client that doesn’t support --ssl-mode.


🧩 Step 2: Use the old-style SSL flags

Before --ssl-mode existed, SSL control was done using these older options:

Modern (--ssl-mode)Legacy equivalent
--ssl-mode=DISABLEDDon’t use any SSL options
--ssl-mode=PREFERRED--ssl (try SSL if supported)
--ssl-mode=REQUIRED--ssl + server must support SSL
--ssl-mode=VERIFY_CA--ssl-ca=ca.pem
--ssl-mode=VERIFY_IDENTITY--ssl-ca=ca.pem --ssl-verify-server-cert

✅ To disable SSL (connect without TLS)

Use:

mysql -u root -h 192.168.155.118 -p --skip-ssl

If your version doesn’t recognize --skip-ssl, just omit all SSL flags:

mysql -u root -h 192.168.155.118 -p

That will try plain TCP (no encryption).


✅ To require SSL (if server supports it)

Use:

mysql -u root -h 192.168.155.118 -p --ssl

If you get the same “TLS/SSL error: SSL is required, but the server does not support it”, that confirms the server side isn’t configured for SSL.


TTY Shell

Basic way

python3 -c 'import pty; pty.spawn("/bin/bash")'
# (inside the nc session) CTRL+Z
stty size
stty raw -echo; fg
reset
export TERM=xterm
export SHELL=/bin/bash

Color terminal

export LS_OPTIONS='--color=auto'
eval "`dircolors`"
alias ls='ls $LS_OPTIONS'
export PS1='\[\e]0;\u@\h: \w\a\]\[\033[01;32m\]\u@\h\[\033[01;34m\] \w\$\[\033[00m\] '

Alternative way: Full-TTYs

Reload all source

tmux list-panes -a -F '#{session_name}:#{window_index}.#{pane_index}' \
|| while read pane; do tmux send-keys -t "$pane" "source ~/.zshrc" C-m; done

Tmux color with grc

proxychains curl -s https://ifconfig.me || proxychains4 curl -s https://ifconfig.me