1. 下载上传安装包到服务器 下载链接: https://pan.baidu.com/s/1YNaEq9E8lugXC8ebKyegwA 提取码:ienf 2. 解压及创建目录 解压 tar xzvf Mysql-5.7.1
下载链接:
https://pan.baidu.com/s/1YNaEq9E8lugXC8ebKyegwA
提取码:ienf
mkdir mysql/arch mysql/data mysql/tmp
vi /etc/my.cnf
Http://39.99.250.62:8080/file/download/myconf.txt
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
--结束END--
本文标题: MySQL in CentOS 7 安装部署
本文链接: https://www.lsjlt.com/news/6020.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-21
2024-05-21
2024-05-21
2024-05-21
2024-05-21
2024-05-21
2024-05-21
2024-05-21
2024-05-21
2024-05-21
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0