brew mysql install
Mysql文件路径 /opt/homebrew/Cellar/mysql/8.1.0/
查看相应的权限 ls -laF /opt/homebrew/Cellar/mysql/
给文件夹赋予相应的权限 sudo chown -R sean /opt/homebrew/Cellar/mysql/cnf文件地址
/opt/homebrew/etc/my.cnf
文件内容
# Default Homebrew MySQL server config
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-external-locking
key_buffer_size = 16K
pid-file=/var/run/mysqld/mysqld.pid
lower_case_table_names = 2
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
init_connect='SET NAMES utf8mb4'
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
# Only allow connections from localhost
[client]
default-character-set=utf8mb4
服务器托管网
[mysql]
default-character-set=utf8mb4
bind-address = 127.0.0.1设置命令行PATH
export PATH=${PATH}:/opt/homebrew/Cellar/mysql/8.1.0/bin/mysql的启动:
mysql.server start
mysql.server stop
mysql.server restar服务器托管网t设置密码
update user set authentication_string='' where user='root';
set password='1234';服务器托管，北京服务器托管，服务器租用 http://www.fwqtg.net
机房租用，北京机房租用，IDC机房托管， http://www.fwqtg.net
手机号检测 手机在网状态：支持传入三大运营商的号码，查询手机号在网状态，返回在网等多种状态。 手机号码在网时长 ： 查询手机号码的在网时长查询，支持三网手机号，返回从开户到目前使用的时间范围，有助于精准营销和风险控制。 手机号码归属地：可根据手机号码查询其省市…
