CentOS MySQL 5.7编译安装步骤详细说明

2019-10-13 11:59:09王冬梅

初始化数据库

注:

之前版本mysql_install_db是在mysql_basedir/script下,5.7放在了mysql_install_db/bin目录下,且已被废弃 "--initialize"会生成一个随机密码(~/.mysql_secret),而"--initialize-insecure"不会生成密码 --datadir目标目录下不能有数据文件

启动数据库

/usr/local/mysql/bin/mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql

设置数据库密码

dbrootpwd=oneinstack #数据库root密码
/usr/local/mysql/bin/mysql -e "grant all privileges on *.* to root@'127.0.0.1' identified by "$dbrootpwd" with grant option;"
/usr/local/mysql/bin/mysql -e "grant all privileges on *.* to root@'localhost' identified by "$dbrootpwd" with grant option;"

 

 感谢阅读,希望能帮助到大家,谢谢大家对本站的支持!