个人实用小笔记

Mysql

开启mysql

sudo /usr/local/mysql/support-files/mysql.server start

找回密码过程

        停服务：sudo /usr/local/mysql/support-files/mysql.server stop

        安全模式启动（登录不需要密码了）：sudo /usr/local/mysql/bin/mysqld_safe --skip-grant-tables

        修改密码：　./mysql -u root

　　　　　　UPDATE mysql.user SET authentication_string=PASSWORD('abc123') WHERE User='root';

　　　　　　FLUSH PRIVILEGES;

        再停掉安全模式：sudo /usr/local/mysql/support-files/mysql.server stop

        正常模式启动：sudo /usr/local/mysql/support-files/mysql.server start

        root用户登陆：./mysql -u root -p

查看进程并杀死

sudo lsof -i tcp:port

kill -9 PID

sntinel

java -Dserver.port=8718 -Dcsp.sentinel.dashboard.server=localhost:8718 -jar /usr/local/sentinel-dashboard-1.8.6.jar

服务器里mysql授权

进入文件夹里面mysql/bin/

mysql -u root -p
​
123456
​
GRANT ALL PRIVILEGES ON *.* TO 'root'@'117.136.26.18' IDENTIFIED BY '123456' WITH GRANT OPTION;
​

​

postgreSQL

systemctl restart postgresql-15.service

//setenforce 0

因为防火墙没输这个命令一直没法从外部访问

服务器中进入pgsql

su - postgres
psql 

本机JDK配置(MacOS\Linux)

export JAVA_HOME=/Users/xxx/Library/Java/JavaVirtualMachines/openjdk-18.0.2.1/Contents/Home

export PATH=$JAVA_HOME/bin:$PATH

export CLASS_PATH=$JAVA_HOME/lib

Maven MacoS中配置

        下载

        配置

•  打开终端输入命令，打开配置文件

        vim ~/.zshrc

•  添加Maven路径        

export M2_HOME=/usr/local/ApacheMaven export PATH=$PATH:$M2_HOME/bin

source ~/.zshrc

Brew 更换清华源

export HOMEBREW_BREW_GIT_REMOTE="https://mirrors.tuna.tsinghua.edu.cn/git/homebrew/brew.git"
export HOMEBREW_CORE_GIT_REMOTE="https://mirrors.tuna.tsinghua.edu.cn/git/homebrew/homebrew-core.git"
export HOMEBREW_BOTTLE_DOMAIN="https://mirrors.tuna.tsinghua.edu.cn/homebrew-bottles"