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"