搜索到
1
篇与
mysql
的结果
-
centos8安装mysql8 下载wget -c https://repo.mysql.com//mysql80-community-release-el8-1.noarch.rpm安装rpm -ivh mysql80-community-release-el8-1.noarch.rpm dnf -y install mysql-server修改配置需先创建目录mkdir -p /usr/local/mysql/data /usr/local/mysql/tmp把目录权限给mysql用户chown -R mysql:mysql /usr/local/mysql/data /usr/local/mysql/tmp修改配置如下，然后保存。vim /etc/my.cnf[mysqld] basedir=/usr/local/mysql datadir=/usr/local/mysql/data port=32456 socket=/usr/local/mysql/tmp/mysql.sock lower_case_table_names=1 [client] default-character-set=utf8 socket=/usr/local/mysql/tmp/mysql.sock [mysql] default-character-set=utf8 socket=/usr/local/mysql/tmp/mysql.sock 启动首次安装需要初始化，启动服务时间较长systemctl restart mysqld.service修改root密码首次登入无密码，直接回车 。mysql -u root -p ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password';允许root远程访问use mysql; update user set host="%" where user="root"; flush privileges;#刷新权限添加开启自启systemctl enable mysqld.service
