工作笔记-8月份

发布于:2023-01-18 ⋅ 阅读:(397) ⋅ 点赞:(0)

修改配置文件:#vim /etc/my.cnf
bind-address=0.0.0.0
port=3306
user=mysql
basedir=/usr/local/mysql
datadir=/data/mysql
socket=/tmp/mysql.sock
log-error=/data/mysql/mysql.err
pid-file=/data/mysql/mysql.pid
#character config
character_set_server=utf8mb4
symbolic-links=0
explicit_defaults_for_timestamp=true

解压tar包:#tar -zxvf mysql-8.0.27-linux-glibc2.12-x86_64.tar
检查MySQL服务:#service mysql start
检查mysql安装路径:#whereis mysql---###如果你安装好了mysql,就会显示文件安装的地址mysql: /usr/bin/mysql /usr/lib64/mysql /usr/include/mysql /usr/share/mysql /usr/share/man/man1/mysql.1.gz
登录mysql:#mysql -u root -p ---然后输入密码即可。
mysql设置远程:#grant all privileges on *.* to 'root'@'%' identified by '你的密码';

[xxx@localhost ~]$ df -h ---查看硬盘详情
[xxx@localhost ~]$ free -m ---查看内存
cat /proc/cpuinfo:查看CPU详细信息
[root@zijuan /]# hostname ---查看主机名命令
1.Linux查看当前操作系统版本信息 cat /proc/version
2.Linux查看版本当前操作系统内核信息 uname -a
3.linux查看版本当前操作系统发行信息 cat /etc/issue 或 cat /etc/centos-release
4.Linux查看cpu相关信息,包括型号、主频、内核信息等 cat /etc/cpuinfo
# cat /etc/redhat-release
CentOS Linux release 7.9.2009 (Core)

rm -rf zjdsp ---删除
cp -r zjdsp.jar back ---复制
whereis *** ---查找文件
whereis elasticsearch-5.6.15
which elasticsearch-5.6.15
cd /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/usr/java/jdk1.8.0_191/bin:/usr/java/jdk1.8.0_191/jre/bin:/root/bin
whereis elasticsearch-5.6.15.tar.gz

SQLyog连接Mysql 8.0.19版本数据库报错:错误号码2058 Plugin caching_sha2_password could not be loaded:
mysql -u root -p
修改账户密码加密规则并更新用户密码:
ALTER USER 'root'@'localhost' IDENTIFIED BY 'gtmap123456' PASSWORD EXPIRE NEVER;   #修改加密规则 
# 下面以gtmap123456作为密码为例
ALTER USER 'root'@'localhost' IDENTIFIED BY 'gtmap123456' PASSWORD EXPIRE NEVER;   #修改加密规则 
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'gtmap123456';   #更新一下用户的密码 
FLUSH PRIVILEGES; # Mysql权限刷新

虚拟机无法安装:
bcdedit /set hypervisorlaunchtype off


网站公告

今日签到

点亮在社区的每一天
去签到