mysql
Drink_hot_water
这个作者很懒,什么都没留下…
展开
-
linux安装mysql8.0
linux安装mysql8.0一、下载mysql安装包官网下载命令下载:wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.20-linux-glibc2.12-x86_64.tar.xz下载Mysql压缩包移动压缩包至mv /root/mysql-8.0.11-linux-glibc2.12-i686 /usr/local/mysql解压mysql压缩包tar zvjf mysql8020-linux-glibc原创 2021-11-29 15:41:59 · 388 阅读 · 0 评论 -
SET PASSWORD FOR ‘root‘@localhost=PASSWORD(‘XXXX‘);报错
原因:数据库版本较高老版本SET PASSWORD FOR ‘root’@localhost=PASSWORD(‘XXXXX’);新版本SET PASSWORD FOR root@localhost = ‘XXXXX’;oralter user ‘root’@‘localhost’ identified by ‘XXXXX’;原创 2021-11-02 11:42:06 · 1848 阅读 · 0 评论 -
mysql8.0初始化后找不到my.cnf文件
mysql初始化后未找到配置文件使用指令./mysql --help | grep my.cnf 查看配置文件的读取顺序,一般默认优先读取/etc/my.cnf若/etc/my.cnf文件不存在则需要新建该文件[mysqld] basedir = /usr/local/mysql datadir = /usr/local/mysql/data socket = /usr/local/mysql/mysql.sock character-set-server=utf8原创 2021-11-02 10:02:27 · 6211 阅读 · 0 评论