下载链接:
https://pan.baidu.com/s/1ynaeq9e8lugxc8ebkyegwa
提取码:ienf
tar xzvf mysql-5.7.11-linux-glibc2.5-x86_64.tar.gz
mv mysql-5.7.11-linux-glibc2.5-x86_64 mysql
mkdir mysql/arch mysql/data mysql/tmp
vi /etc/my.cnf
groupadd -g 101 dba
useradd -u 514 -g dba -g root -d /usr/local/mysql mysqladmin
usermod -u 514 -g dba -g root -d /usr/local/mysql mysqladmin
vi mysql/.bash_profile
export mysql_base=安装路径 export path=${mysql_base}/bin:$path unset username set umask to 022 umask 022 ps1=`uname -n`":"'$user'":"'$pwd'":>"; export ps1
chown mysqladmin:dba /etc/my.cnf
chmod 640 /etc/my.cnf
chown -r mysqladmin:dba /usr/local/mysql
chmod -r 755 /usr/local/mysql
cd /usr/local/mysql
cp support-files/mysql.server /etc/rc.d/init.d/mysql
chmod +x /etc/rc.d/init.d/mysql
chkconfig --del mysql
chkconfig --add mysql
chkconfig --level 345 mysql on
yum -y install libaio
sudo su - mysqladmin
usr/local/mysql 下执行
bin/mysqld \ --defaults-file=/etc/my.cnf \ --user=mysqladmin \ --basedir=/usr/local/mysql/ \ --datadir=/usr/local/mysql/data/ \ --initialize
在初始化时如果加上 –initial-insecure,则会创建空密码的 root@localhost 账号,否则会创建带密码的 root@localhost 账号,密码直接写在 log-error 日志文件中(在5.6版本中是放在 ~/.mysql_secret 文件里)
cd /usr/local/mysql/data
cat hostname.err |grep password
su mysqladmin
/usr/local/mysql/bin/mysqld_safe --defaults-file=/etc/my.cnf &
mysql -uroot -pxxxx
alter user root@localhost identified by 'lxz123';
grant all privileges on . to 'root'@'%' identified by 'lxz123' ;
flush privileges;
service mysql restart
mysql -uroot -plxz123
如对本文有疑问,请在下面进行留言讨论,广大热心网友会与你互动!! 点击进行留言回复
小白安装登录mysql-8.0.19-winx64的教程图解(新手必看)
Navicat连接MySQL时报10060、1045错误及my.ini位置问题
网友评论