安装mysql8.0最新版lnmp

悠悠 2023-02-11 07:20 5阅读 0赞

# 1.安装mysql8.0 #

官方文档：  
[https://dev.mysql.com/doc/refman/8.0/en/linux-installation-yum-repo.html][https_dev.mysql.com_doc_refman_8.0_en_linux-installation-yum-repo.html]

### 下载rpm ###

yum localinstall http://mirrors.ustc.edu.cn/mysql-repo/mysql80-community-release-el7-3.noarch.rpm (现在很慢,用下面这个链接里面介绍的方法)

[https://blog.csdn.net/Yuan\_xii/article/details/105539908][https_blog.csdn.net_Yuan_xii_article_details_105539908]

### 安装rpm ###

yum install mysql-community-server

### 启动mysql服务端 ###

service mysqld start

### 查找初始密码 ###

> 一定要先启动mysqld服务，不然不会生成初始密码：

sudo grep 'temporary password' /var/log/mysqld.log

### 设置新密码，否则不让登录 ###

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'MyNewPass4!ysp123456';

--------------------

5.7以后可能报错:

##### ALTER USER USER() IDENTIFIED BY ‘MyNewPass4!ysp123456’; #####

--------------------

##### 增加用户，赋予权限 #####

# 注意mysql_native_password 加密方式，否则使用phpmyadmin会碰到问题 https://blog.csdn.net/zhezhebie/article/details/106289214
    # 以前一步执行的创建用户分配权限，现在分为两步
    
    create user 'ysp'@'%' identified WITH mysql_native_password by 'Ysp123456!';
    
    grant all privileges on *.* to ysp@'%';
    
    flush privileges;

其他镜像源：  
[http://mirrors.ustc.edu.cn/mysql-repo/yum/mysql-8.0-community/el/7/x86\_64/][http_mirrors.ustc.edu.cn_mysql-repo_yum_mysql-8.0-community_el_7_x86_64]

# 2.安装nginx: #

yum localinstall http://mirrors.ustc.edu.cn/nginx/centos/7/x86_64/RPMS/nginx-1.18.0-1.el7.ngx.x86_64.rpm

### 查看nginx版本 ###

> nginx -v

# 3.安装php: #

### 安装yum源 ###

yum install epel-release

### 安装php源 ###

yum install http://rpms.remirepo.net/enterprise/remi-release-7.rpm

### 安装php拓展 ###

yum install -y php73-php-fpm php73-php-cli php73-php-bcmath php73-php-gd php73-php-json 
    php73-php-mbstring php73-php-mcrypt php73-php-mysqlnd php73-php-opcache php73-php-pdo 
    php73-php-pecl-crypto php73-php-pecl-mcrypt php73-php-soap php73-php-pecl-zip
    php73-php-process php73-php-pecl-yaf php73-php-xml php73-php-pecl-swoole4

### 设置开机启动 ###

systemctl enable php73-php-fpm
    systemctl start php73-php-fpm

### 查看php版本 ###

> php73 -v

举个例子，你要安装其他拓展，例如看看有没有swoole的拓展：

yum search swoole #找到了下面这个拓展，那么就可以直接安装了
    yum install -y php73-php-pecl-swoole4.x86_64

php73 -m |grep swoole
    cp /usr/bin/php73 /usr/bin/php  #后续就可以直接使用php -m

可以看到swoole已经被安装好了。

# 4.安装redis最新版本： #

sudo yum install -y http://rpms.famillecollet.com/enterprise/remi-release-7.rpm
    sudo yum --enablerepo=remi install redis -y
    systemctl start redis

# 设置服务开机启动 #

systemctl enable mysqld
    systemctl start mysqld
    systemctl enable php73-php-fpm
    systemctl start php73-php-fpm
    systemctl enable nginx
    systemctl enable redis

# 5.查看已经开机启动的服务： #

systemctl list-unit-files |grep enabled

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poZXpoZWJpZQ_size_16_color_FFFFFF_t_70]

=2020-05-27 补充=  
安装postgresql:  
[https://www.postgresql.org/download/linux/redhat/][https_www.postgresql.org_download_linux_redhat]

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poZXpoZWJpZQ_size_16_color_FFFFFF_t_70 1]

### 使用国内清华镜像： ###

速度更快，因为之前看清华的镜像太多了，不知道要安装哪一个，所以先安装了官方的源。

yum localinstall http://mirrors.ustc.edu.cn/postgresql/repos/yum/12/redhat/rhel-7.8-x86_64/pgdg-redhat-repo-latest.noarch.rpm
    yum install postgresql12 postgresql12-server -y
    
    /usr/pgsql-12/bin/postgresql-12-setup initdb
    systemctl enable postgresql-12
    systemctl start postgresql-12

### 默认用户postgres，无密码，相当于mysql的root用户 ###

psql postgres
    \passowrd postgres          #接着输入两次密码

[http://mirrors.ustc.edu.cn/postgresql/repos/yum/12/redhat/rhel-7.8-x86\_64/][http_mirrors.ustc.edu.cn_postgresql_repos_yum_12_redhat_rhel-7.8-x86_64]

==== 2021-02-04===

yum直接localinstall rpm包速度变得巨慢(10kb/s),直接下载集合包很快(3M/s).

最新的集合包:  
[http://mirrors.163.com/mysql/Downloads/MySQL-8.0/mysql-8.0.22-1.el7.x86\_64.rpm-bundle.tar][http_mirrors.163.com_mysql_Downloads_MySQL-8.0_mysql-8.0.22-1.el7.x86_64.rpm-bundle.tar]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poZXpoZWJpZQ_size_16_color_FFFFFF_t_70 2]

![在这里插入图片描述][20210204225028314.png]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poZXpoZWJpZQ_size_16_color_FFFFFF_t_70 3]

[https_dev.mysql.com_doc_refman_8.0_en_linux-installation-yum-repo.html]: https://dev.mysql.com/doc/refman/8.0/en/linux-installation-yum-repo.html
[https_blog.csdn.net_Yuan_xii_article_details_105539908]: https://blog.csdn.net/Yuan_xii/article/details/105539908
[http_mirrors.ustc.edu.cn_mysql-repo_yum_mysql-8.0-community_el_7_x86_64]: http://mirrors.ustc.edu.cn/mysql-repo/yum/mysql-8.0-community/el/7/x86_64/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poZXpoZWJpZQ_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200522105036320.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poZXpoZWJpZQ==,size_16,color_FFFFFF,t_70
[https_www.postgresql.org_download_linux_redhat]: https://www.postgresql.org/download/linux/redhat/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poZXpoZWJpZQ_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20200527095152101.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poZXpoZWJpZQ==,size_16,color_FFFFFF,t_70
[http_mirrors.ustc.edu.cn_postgresql_repos_yum_12_redhat_rhel-7.8-x86_64]: http://mirrors.ustc.edu.cn/postgresql/repos/yum/12/redhat/rhel-7.8-x86_64/
[http_mirrors.163.com_mysql_Downloads_MySQL-8.0_mysql-8.0.22-1.el7.x86_64.rpm-bundle.tar]: http://mirrors.163.com/mysql/Downloads/MySQL-8.0/mysql-8.0.22-1.el7.x86_64.rpm-bundle.tar
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poZXpoZWJpZQ_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20210204225208896.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poZXpoZWJpZQ==,size_16,color_FFFFFF,t_70
[20210204225028314.png]: https://img-blog.csdnimg.cn/20210204225028314.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poZXpoZWJpZQ_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/20210204232552253.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poZXpoZWJpZQ==,size_16,color_FFFFFF,t_70