linux 普通用户傻瓜式安装启动mysql5.7.26

wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz

useradd mysql

passwd mysql

tar -zxvf mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz -C /home/mysql

cd /home/mysql

mv mysql-5.7.26-linux-glibc2.12-x86_64 mysql

chown -R mysql:mysql mysql

vim /etc/my.cnf

[client]
port=3306
#socket=/home/mysql/mysql/mysql.sock
[mysqld]
port=3306
#设置mysql的安装目录
basedir=/home/mysql/mysql
# 设置mysql数据库的数据的存放目录
datadir=/home/mysql/data
pid-file=/home/mysql/mysql/mysql.pid
#socket=/home/mysql/mysql/mysql.sock
log_error=/home/mysql/log/error.log
collation_server=utf8_general_ci
# 服务端使用的字符集默认为8比特编码的latin1字符集
character_set_server=utf8
log-bin=/home/mysql/log/mysql-bin
server-id=100
[mysqld_safe]
log-error=/home/mysql/log/mysql_error.log
pid-file=/home/mysql/log//mysql.pid

 

chown mysql:mysql /etc/my.cnf

su mysql

cd /home/mysql

mkdir data log

./mysql/bin/mysqld --initialize --user=mysql --basedir=/home/mysql/mysql --datadir=/home/mysql/data

./mysql/bin/mysqld_safe   --user=mysql  &

cat log/error.log | grep root@localhost

2019-07-19T14:33:39.208431Z 1 [Note] A temporary password is generated for root@localhost: m)5=+pn<h0wO

./mysql/bin/mysql -u root -p m)5=+pn<h0wO

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('123456');
flush privileges;

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
flush privileges;

exit

./mysql/bin/mysql -u root -p 123456

 

 

感谢:https://blog.csdn.net/u013967628/article/details/82867422

https://blog.csdn.net/aling54010/article/details/82391209

https://www.cnblogs.com/omsql/p/10931725.html

https://www.cnblogs.com/parasis/p/9318938.html