django vue admin服务器部署

最新推荐文章于 2024-08-08 07:46:04 发布

wxlly06

最新推荐文章于 2024-08-08 07:46:04 发布

阅读量1.1k

点赞数

分类专栏：服务器配置文章标签：服务器 django vue.js

本文链接：https://blog.csdn.net/wxlly06/article/details/128392653

版权

服务器配置专栏收录该内容

9 篇文章 0 订阅

订阅专栏

应用服务器：

1、redhat版本查看：

本应用服务器：Red Hat Enterprise Linux Server release 7.6 (Maipo)
查看linux的版本主要有三种方法：

登录到服务器执行 lsb_release -a ，即可列出所有版本信息，例如：

[root@3.5.5Biz-46 ~]# lsb_release -a

LSB Version: 1.3

Distributor ID: RedHatEnterpriseAS

Description: Red Hat Enterprise Linux AS release 4 (Nahant Update 1)

Release: 4

Codename: NahantUpdate1

[root@3.5.5Biz-46 ~]#

这个命令适用于所有的linux，包括Redhat、SuSE、Debian等发行版。

登录到linux执行cat /etc/redhat-release ，例如如下：

[root@3.5.5Biz-46 ~]# cat /etc/redhat-release

Red Hat Enterprise Linux AS release 4 (Nahant Update 1)

[root@3.5.5Biz-46 ~]#

这种方式下可以直接看到具体的版本号，比如 AS4 Update 1

3)登录到linux执行rpm -q redhat-release ，例如如下

[root@3.5.5Biz-46 ~]# rpm -q redhat-release

redhat-release-4AS-2.4

[root@3.5.5Biz-46 ~]#

这种方式下可看到一个所谓的release号，比如上边的例子是2.4

这个release号和实际的版本之间存在一定的对应关系，如下：

redhat-release-3AS-1 -> Redhat Enterprise Linux AS 3
redhat-release-3AS-7.4 -> Redhat Enterprise Linux AS 3 Update 4
redhat-release-4AS-2 -> Redhat Enterprise Linux AS 4
redhat-release-4AS-2.4 -> Redhat Enterprise Linux AS 4 Update 1
redhat-release-4AS-3 -> Redhat Enterprise Linux AS 4 Update 2
redhat-release-4AS-4.1 -> Redhat Enterprise Linux AS 4 Update 3
redhat-release-4AS-5.5 -> Redhat Enterprise Linux AS 4 Update 4

注意：第(2)(3)两种方法只对Redhat Linux有效

2、python3安装

https://www.python.org/ftp/python/ 下载Python-3.7.9.tgz
解压

tar -zxvf Python-3.7.9.tgz

进入解压后的目录，依次执行下面命令进行手动编译，最后没提示出错，就代表正确安装了，在/usr/local/目录下就会有Python-3.7.9目录

cd Python-3.7.9
./configure --enable-optimizations --prefix=/usr/local/python-3.7.9
make && make install

make install报错：

/usr/bin/install: cannot create directory ‘/usr/local/python-3.7.9’: Permission denied
make: *** [install] Error 1

解决：
切换为root ：su root 输入root密码
然后在执行：先执行make clean 在执行 make && make install

make install报错：

zipimport.ZipImportError: can't decompress data; zlib not available
make: *** [install] Error 1

问题分析
从错误信息分析，就是缺少了zlib的解压缩类库，安装即可

yum -y install zlib*

添加python3的软链接

ln -s /usr/local/python-3.7.9/bin/python3.7 /usr/bin/python3
ln -s /usr/local/python-3.7.9/bin/pip3.7 /usr/bin/pip3

测试是否安装成功了

python3 -V

下离线安装python项目的依赖包

3、nginx安装

安装yum依赖包
下载依赖包：

wget http://mirror.centos.org/centos/7/os/x86_64/Packages/python-iniparse-0.4-9.el7.noarch.rpm
wget http://mirror.centos.org/centos/7/os/x86_64/Packages/yum-metadata-parser-1.1.4-10.el7.x86_64.rpm
wget http://mirror.centos.org/centos/7/os/x86_64/Packages/yum-3.4.3-168.el7.centos.noarch.rpm
wget http://mirror.centos.org/centos/7/os/x86_64/Packages/yum-plugin-fastestmirror-1.1.31-54.el7_8.noarch.rpm
wget http://mirror.centos.org/centos/7/os/x86_64/Packages/yum-utils-1.1.31-54.el7_8.noarch.rpm
wget http://mirror.centos.org/centos/7/os/x86_64/Packages/yum-updateonboot-1.1.31-54.el7_8.noarch.rpm
wget http://mirror.centos.org/centos/7/os/x86_64/Packages/yum-cron-3.4.3-168.el7.centos.noarch.rpm

安装：

rpm -ivh python-iniparse-0.4-9.el7.noarch.rpm
rpm -ivh yum-metadata-parser-1.1.4-10.el7.x86_64.rpm
rpm -ivh yum*

安装过程：

[root@localhost soft]# rpm -ivh python-iniparse-0.4-9.el7.noarch.rpm
warning: python-iniparse-0.4-9.el7.noarch.rpm: Header V3 RSA/SHA256 Signature, key ID f4a80eb5: NOKEY
Preparing...                          ################################# [100%]
	package python-iniparse-0.4-9.el7.noarch is already installed
	file /usr/lib/python2.7/site-packages/iniparse/ini.pyc from install of python-iniparse-0.4-9.el7.noarch conflicts with file from package python-iniparse-0.4-9.el7.noarch
	file /usr/lib/python2.7/site-packages/iniparse/ini.pyo from install of python-iniparse-0.4-9.el7.noarch conflicts with file from package python-iniparse-0.4-9.el7.noarch
[root@localhost soft]# rpm -ivh yum-metadata-parser-1.1.4-10.el7.x86_64.rpm
warning: yum-metadata-parser-1.1.4-10.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID f4a80eb5: NOKEY
Preparing...                          ################################# [100%]
	package yum-metadata-parser-1.1.4-10.el7.x86_64 is already installed
	file /usr/lib64/python2.7/site-packages/_sqlitecache.so from install of yum-metadata-parser-1.1.4-10.el7.x86_64 conflicts with file from package yum-metadata-parser-1.1.4-10.el7.x86_64

安装Nginx

wget http://nginx.org/download/nginx-1.20.1.tar.gz
tar -zxvf nginx-1.20.1.tar.gz
cd nginx-1.20.1

./configure --prefix=/usr/local/nginx \
--user=nginx \
--group=nginx \
--with-pcre \
--with-http_ssl_module \
--with-http_v2_module \
--with-http_realip_module \
--with-http_addition_module \
--with-http_sub_module \
--with-http_dav_module \
--with-http_flv_module \
--with-http_mp4_module \
--with-http_gunzip_module \
--with-http_gzip_static_module \
--with-http_random_index_module \
--with-http_secure_link_module \
--with-http_stub_status_module \
--with-http_auth_request_module \
--with-http_image_filter_module \
--with-http_slice_module \
--with-mail \
--with-threads \
--with-file-aio \
--with-stream \
--with-mail_ssl_module \
--with-stream_ssl_module

或

#./configure --help 查看常用模块
./configure --prefix=/usr/local/nginx \
--user=nginx \
--group=nginx  \
--with-http_ssl_module \
--with-http_v2_module \
--with-http_realip_module \
--with-http_sub_module  \
--with-http_stub_status_module \
--with-http_gzip_static_module  \
--with-pcre \
--with-http_perl_module \
--with-stream \
--with-stream_ssl_module \
--with-stream_realip_module \
--with-http_addition_module  \
--with-http_dav_module \
--with-http_flv_module \
--with-http_mp4_module

make && make install
/usr/local/nginx

常见错误：

错误为：./configure: error: the HTTP rewrite module requires the PCRE library.

解决方案：安装 pcre-devel（系统自带）

yum -y install pcre-devel

Nginx 编译报错：SSL modules require the OpenSSL library

解决方案：yum -y install openssl openssl-devel

Nginx 编译报错

./configure: error: the HTTP image filter module requires the GD library.
You can either do not enable the module or install the libraries.

解决方案：yum install gd gd-devel 或 yum -y install gd-devel

Nginx 编译报错./configure: error: perl module ExtUtils::Embed is
required

解决方法：

yum -y install perl-devel perl-ExtUtils-Embed

nginx -t命令测试时候报错

[root@localhost sbin]# ./nginx -t
nginx: the configuration file /usr/local/nginx/conf/nginx.conf syntax is ok
nginx: [emerg] getpwnam("nginx") failed
nginx: configuration file /usr/local/nginx/conf/nginx.conf test failed

创建一个nginx用户

useradd -s /sbin/nologin -M nginx

实际用下面方法：
nginx编译安装之后，启动出现了：nginx: [emerg] getpwnam(“nginx”) failed
这个是因为我编译安装nginx的时候指定了–user=nginx和–group=nginx
解决方法

useradd nginx

[root@localhost sbin]# useradd nginx
[root@localhost sbin]# ./nginx -t
nginx: the configuration file /usr/local/nginx/conf/nginx.conf syntax is ok
nginx: configuration file /usr/local/nginx/conf/nginx.conf test is successful
[root@localhost sbin]#

验证配置文件是否正确

./nginx -t

重启nginx : ./nginx -s reload
停止nginx : ./nginx -s stop
查看是否安装成功，出现版本号就是成功 : ./nginx -v
查看是否启动 : netstat -ntlp |grep nginx

在加载nginx配置文件时，报错nginx: [error] invalid PID number ; in /usr/local/nginx/logs/nginx.pid

1.nginx 重新加载命令./nginx -s reload，出现

nginx: [error] invalid PID number “” in "/usr/local/nginx/logs/nginx.pid"问题。

解决办法：

1、执行命令 killall -9 nginx 杀掉nginx 进程
2、进入 目录 cd /usr/local/nginx
3、执行命令 /usr/local/nginx/sbin/nginx -c /usr/local/nginx/conf/nginx.conf （根据实际安装路径修改）
重新加载配置文件
4、进入 /usr/local/nginx/sbin
5、执行命令 ./nginx -s reload 重新启动nginx
6、重新启动nginx

./nginx 启动
./nginx -s stop 关闭ls
./nginx -s reload 重启

启动项目: python3 manage.py runserver 127.0.0.1:8000(如果是服务器或虚拟机安装，把 127.0.0.1:8000 改成 0.0.0.0:8000)
python3 manage.py runserver 0.0.0.0:8000

.env文件无法传输到Linux机器上
因为.开头的文件在linux系统中是不显示的，可以用过ls -a命令进行查看，发现.开头的文件其实都有传输成功
用压缩包上传总应用程序，不容易卡死
然后解压

unzip -o -d /home/agrj/ django-vue-admin-master.zip
chmod 777 /home/agrj/django-vue-admin-master
chmod 777 /usr/local/nginx/conf/nginx.conf

python-django项目迁移依赖包离线安装

1.在项目中导出下载依赖包包:
pip freeze > requirements.txt 导出环境中用到的依赖包记录文本

#pip download -d /tmp/packages -r requirements.txt    
pip download -d E:\PROGRAM\django-vue-admin-master\dvadmin-backend\bao -r requirements.txt

要保存下载的包的目录 -r requirements.txt 通过txt文件中的内容，下载相应的依赖包到指定目录
2.通过上面的方法，把包拷贝到内网服务器

3.安装包：

  #/home/agrj/soft/
  pip install --no-index --find-links=packages -r requirements.txt
  pip3 install --no-index --find-links=packages -r requirements.txt

安装不上如：

ERROR: Could not find a version that satisfies the requirement pymongo<4.0,>=3.4 (from mongoengine==0.22.1->-r requirements.txt (line 39)) (from versions: none)
ERROR: No matching distribution found for pymongo<4.0,>=3.4 (from mongoengine==0.22.1->-r requirements.txt (line 39))

可以改whl文件名后缀为-py3-none-any.whl
pip3 install --no-index --find-links=packages -r requirements.txt(requirements.txt 和packages文件夹同目录下)
也可以下载一个包后，通过pip install **.whl或者python setup.py install **.tar.gz 安装指定安装目录
pip3 install --no-index --find-links=packages -r requirements.txt --target=/opt/envs/django2.1.8/lib/python3.8/site-packages #未测试
4. 注意：python3不再支持mysqldb，取而代之的是pymysql，安装依赖包时应注意。

ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command output.

在pip安装过程中，

ModuleNotFoundError: No module named ‘_ctypes‘解决方法

解决方案
其实很简单安装一下外部函数库(libffi)就可以了，操作步骤如下：

1、yum install libffi-devel -y
2、源码安装的python3 重新编译安装， 如果通过yum安装的 那么直接执行命令 yum install python                                                                                                                           
./configure --prefix=/usr/local/python3

make && make install

如果遇到ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command output.
执行以下命令即可解决
pip install --user pytest-runner pip3 install --user pytest-runner（经测试需要联网）

安装uwsgi：
官网下载页 https://uwsgi-docs.readthedocs.io/en/latest/Download.html 选择版本下载

如果打开网速较慢，可以尝试此链接，最后的版本号根据自己需求修改并建立下载任务，此处我选择的是2.0.18的版本，所以链接地址是 https://projects.unbit.it/downloads/uwsgi-2.0.18.tar.gz
/home/agrj/django-vue-admin-master/dvadmin-backend/
解压安装（注意使用root用户安装）
将下载好的安装包上传到服务器 /usr/local 文件夹下

chmod 777 /usr/local/

cd /usr/local # 进入安装目录
tar zxvf uwsgi-2.0.18.tar.gz # 解压文件夹

cd uwsgi-2.0.18

make

make失败：plugins/python/uwsgi_python.h:2:20: fatal error: Python.h: No such file or directory #include <Python.h> ^
解决办法
尝试安装以下的包

yum install python-devel.x86_64
yum install python3-devel.x86_64

chmod 755 /usr/local/

启动 uwsgi --ini application/uwsgi.ini
uwsgi --ini uwsgi.ini
报错uwsgi: command not found
解决办法：找到uwsgi执行位置，建立软链接

[root@localhost home]# find / -name uwsgi
/usr/bin/uwsgi
/usr/local/uwsgi-2.0.18/bin/uwsgi
/usr/local/uwsgi-2.0.18/ext/uwsgi
/usr/local/uwsgi-2.0.18/t/ring/src/uwsgi
/usr/local/uwsgi-2.0.18/uwsgi

ln -s /usr/local/uwsgi-2.0.18/bin/uwsgi /usr/bin/uwsgi

[root@localhost uwsgi-2.0.18]# ln -s /usr/local/python3/bin/uwsgi /usr/bin/uwsgi
ln: failed to create symbolic link ‘/usr/bin/uwsgi’: File exists

#解决方法：删除软连接

[root@localhost uwsgi-2.0.18]# rm /usr/bin/uwsgi 
rm: remove symbolic link ‘/usr/bin/uwsgi’? y
[root@localhost uwsgi-2.0.18]# ln -s /usr/local/python3/bin/uwsgi /usr/bin/uwsgi

成功连接但uwsgi不管用

python3 setup.py --build

方法2：安装uwsgi，不用make
/home/agrj/soft

[root@localhost soft]# pip3 install uwsgi-2.0.18.tar.gz
Processing ./uwsgi-2.0.18.tar.gz
Using legacy setup.py install for uWSGI, since package 'wheel' is not installed.
Installing collected packages: uWSGI
    Running setup.py install for uWSGI ... done
Successfully installed uWSGI-2.0.18
[root@localhost soft]#

ln -s /usr/local/python-3.7.9/bin/uwsgi /usr/bin/uwsgi

[root@localhost soft]#  uwsgi --version
bash:  uwsgi --version: command not found
[root@localhost soft]# find / -name uwsgi
/usr/bin/uwsgi
/usr/local/python-3.7.9/bin/uwsgi
/usr/local/uwsgi-2.0.18/bin/uwsgi
/usr/local/uwsgi-2.0.18/ext/uwsgi
/usr/local/uwsgi-2.0.18/t/ring/src/uwsgi
[root@localhost soft]# ln -s /usr/local/python-3.7.9/bin/uwsgi /usr/bin/uwsgi
ln: failed to create symbolic link ‘/usr/bin/uwsgi’: File exists
[root@localhost soft]# rm /usr/bin/uwsgi
rm: remove symbolic link ‘/usr/bin/uwsgi’? y
[root@localhost soft]# find / -name uwsgi
/usr/local/python-3.7.9/bin/uwsgi
/usr/local/uwsgi-2.0.18/bin/uwsgi
/usr/local/uwsgi-2.0.18/ext/uwsgi
/usr/local/uwsgi-2.0.18/t/ring/src/uwsgi
[root@localhost soft]# ln -s /usr/local/python-3.7.9/bin/uwsgi /usr/bin/uwsgi
[root@localhost soft]# find / -name uwsgi
/usr/bin/uwsgi
/usr/local/python-3.7.9/bin/uwsgi
/usr/local/uwsgi-2.0.18/bin/uwsgi
/usr/local/uwsgi-2.0.18/ext/uwsgi
/usr/local/uwsgi-2.0.18/t/ring/src/uwsgi
[root@localhost soft]# whereis uwsgi
uwsgi: /usr/bin/uwsgi

清除rm /usr/local/uwsgi-2.0.18/bin/uwsgi
启动 uwsgi --ini application/uwsgi.ini成功

启动中间有错误用sqlsever缺少东西太多连接不上
改为用mysql
启动中间有错误python 3.7 cannot import name ‘_mysql’ from ‘MySQLdb’ (

[root@localhost dvadmin-backend]# cd /home/agrj/soft/packages
[root@localhost packages]# pip3 install PyMySQL-1.0.2-py3-none-any.whl
Processing ./PyMySQL-1.0.2-py3-none-any.whl
Installing collected packages: PyMySQL
Successfully installed PyMySQL-1.0.2

ImportError: cannot import name '_imaging' from 'PIL'
python3 setup.py install Pillow-4.0.0.tar.gz

/home/agrj/soft/packages
/usr/local/python-3.7.9/lib/python3.7/site-packages

联网后pip3 install 报错

WARNING: Retrying (Retry(total=4, connect=None, read=None, redirect=None, status=None)) after connection broken by 'NewConnectionError('<pip._vendor.urllib3.connection.VerifiedHTTPSConnection object at 0x7f70c8bfaf50>: Failed to establish a new connection: [Errno -2] Name or service not known')':

可能是DNS未配置

配置办法：介绍一种

打开文件

sudo vim /etc/resolv.conf

插入以下两句

nameserver 8.8.8.8
nameserver 114.114.114.114

保存（不需要重启网络或服务器）

更改文件权限可以记事本修改

root@localhost agrj]# chmod 777 /etc/resolv.conf
[root@localhost agrj]# chmod 664 /etc/resolv.conf

启动网站时

ImportError: cannot import name '_psutil_linux' from 'psutil' (/usr/local/python-3.7.9/lib/python3.7/site-packages/psutil/__init__.py)

[root@localhost dvadmin-backend]# pip3 install psutil
Requirement already satisfied: psutil in /usr/local/python-3.7.9/lib/python3.7/site-packages (5.8.0)
WARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv

卸载psutil

[root@localhost dvadmin-backend]# pip3 uninstall psutil

在线重新安装对应版本psutil

[root@localhost dvadmin-backend]# pip3 install psutil

  File "/usr/local/python-3.7.9/lib/python3.7/site-packages/django/db/backends/mysql/operations.py", line 146, in last_executed_query
    query = query.decode(errors='replace')
AttributeError: 'str' object has no attribute 'decode'

解决办法：打开此文件把146行的decode修改为encode

启动后端

[root@localhost django-vue-admin-master]# cd /home/agrj/django-vue-admin-master/dvadmin-backend
[root@localhost dvadmin-backend]# python3 manage.py makemigrations
No changes detected
[root@localhost dvadmin-backend]# python3 manage.py migrate
[root@localhost dvadmin-backend]# python3 manage.py runserver 0.0.0.0:8000
Watching for file changes with StatReloader
[2022-12-16 10:16:24][django.utils.autoreload.run_with_reloader():597] [INFO] Watching for file changes with StatReloader
Performing system checks...

System check identified no issues (0 silenced).
December 16, 2022 - 10:16:25
Django version 2.2.16, using settings 'application.settings'
Starting development server at http://0.0.0.0:8000/
Quit the server with CONTROL-C.

安装npm

npm 不需要单独安装。在安装 Node 的时候，会连带一起安装 npm 。但是，Node 附带的 npm 可能不是最新版本，最后用下面的命令，更新到最新版本。

#sudo npm install npm -g

安装nodejs
1、采用解压方式进行安装，安装步骤如下：

1）下载
在http://nodejs.cn/download/下进行下载，选择自己的平台。
这里是x64，下载安装包node-v8.6.0-linux-x64.tar.xz

**注意事项：**通过命令uname -m&&uname -r查看系统版本，是x86还是x64平台。如果安装包与系统不符，则会抛错：/lib/ld-linux.so.2: bad ELF interpreter: No such file or directory

2）将文件下载或拷贝至/usr/local/src目录下，可使用xshell工具上传文件

3）解压

cd /usr/local/src
tar xvf node-v16.18.1-linux-x64.tar.xz

4）配置

vi /etc/profile

vi使用{vi是打开文件后的命令模式状态。您可以使用i或a命令进入可编辑状态。在这里我按a进入编辑模式。
在编辑模式的情况下，您应该在此时保存文件。要保存文件，请按esc，这将返回vi的命令模式。
按esc后，输入冒号（英文），然后切换到最后一行模式，最后一行模式决定是否保存文件。
在最后一行模式中，您可以通过按x进行保存，x命令 :x可以保存已编辑的文件。
你也可以用wq保存。
然后检查以查看使用的cat文件名。
可以看到vi写的内容，表示保存成功。}
在最下面加入

 #node （注释作用）
export NODE_HOME=/usr/local/src/node-v16.18.1-linux-x64
export NODE_PATH=$NODE_HOME/lib/node_modules 
export PATH=$PATH:$NODE_HOME/bin

5）使配置文件生效：

source /etc/profile

6）测试是否安装成功
使用 node -v，显示版本号则安装成功

[root@localhost bin]# ./node -v
v16.18.1
[root@localhost bin]# ./npm -v
/usr/bin/env: node: No such file or directory
[root@localhost bin]# ln -s /usr/local/node-v16.18.1-linux-x64/bin/node /usr/local/bin/
[root@localhost bin]# ln -s /usr/local/node-v16.18.1-linux-x64/bin/npm /usr/local/bin/
[root@localhost bin]# node -v
v16.18.1
[root@localhost bin]# npm -v
8.19.2
[root@localhost bin]# ./node -v
v16.18.1
[root@localhost bin]# ./npm -v
8.19.2
[root@localhost bin]#

###########################
解压：tar -xvf node-v16.18.1-linux-x64.tar.xz

改目录名：

mv /usr/local/node-v16.18.1-linux-x64 /usr/local/node

mv命令用来修改名字或移动文件的

查看版本（./代表从当前目录找）

./node -v
./npm -v（需要配环境变量）

配环境变量

vi /etc/profile

最后加上这句话：export PATH=$PATH:/usr/local/node/bin
让新加的配置生效：source /etc/profile

配软连接：
相当于全局变量，在任何文件夹都能查看版本信息

ln -s /usr/local/node/bin/node /usr/local/bin/
ln -s /usr/local/node/bin/npm /usr/local/bin/

###########################
2、源码编译安装

cd /usr/local/src
wget https://npmmirror.com/mirrors/node/v16.18.1/node-v16.18.1.tar.gz
tar zxvf node-v16.18.1.tar.gz
cd node-v16.18.1
./configure
make
make install

常用路径（根据自己项目路径不同）：

/home/agrj/django-vue-admin-master/dvadmin-backend
/home/agrj/django-vue-admin-master/dvadmin-ui

G:\tools\python\redhat7.6配置包

/usr/local/nginx/sbin/nginx -s stop
/usr/local/nginx/sbin/nginx -s start
/usr/local/nginx/sbin/nginx -s reload

数据库服务器：

安装sql server 2016；

注意事项：
1、报错项目不要选择安装如R 什么的。
2、打开防火墙设置——>高级设置，选择左侧的入站规则，然后点击右侧新建规则添加1433端口

django.core.exceptions.ImproperlyConfigured: ‘sql_server.pyodbc’ isn’t an available database backend.

pip install django-pyodbc-azure
未能执行数据库迁移（数据库安装成了但django连不上）

mysql安装:

错误1：

C:\Users\Administrator>C:\mysql\mysql-8.0.31-winx64\bin
'C:\mysql\mysql-8.0.31-winx64\bin' 不是内部或外部命令，也不是可运行的程序
或批处理文件。

解决：

C:\mysql-8.0.31>cd C:\mysql-8.0.31\bin

C:\mysql-8.0.31\bin>mysqld --initialize --console
2022-12-13T00:40:55.916493Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2022-12-13T00:40:55.916539Z 0 [System] [MY-013169] [Server] C:\mysql-8.0.31\bin\mysqld.exe (mysqld 8.0.31) initializing of server in progress as process 4928
2022-12-13T00:40:55.918231Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2022-12-13T00:40:55.932941Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-12-13T00:40:56.599705Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2022-12-13T00:40:57.705272Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: a!RsgW#mi9Ji

C:\mysql-8.0.31\bin>

密码 root@localhost: a!RsgW#mi9Ji
//安装mysql服务并启动

C:\mysql\mysql-8.0.31-winx64\bin>mysqld -install

Service successfully installed.
C:\mysql-8.0.31\bin>mysqld --install mysql
Service successfully installed.
C:\mysql\mysql-8.0.31-winx64\bin>net start mysql
MySQL 服务正在启动 .
MySQL 服务已经启动成功。

//修改密码为x@mysql

ALTER USER 'root'@'localhost' IDENTIFIED BY 'x@mysql';

//查看到端口号

show global variables like 'port';

*错误2：Mysql连接报错：1130-host ... is not allowed to connect to this MySql server如何处理*
1、连接服务器: mysql -u root -p

2、看当前所有数据库：show databases;

3、进入mysql数据库：use mysql;

4、查看mysql数据库中所有的表：show tables;

5、查看user表中的数据：select Host, User,Password from user;

6、修改user表中的Host:update user set Host=‘%’ where User=‘root’;
方法1：update user set host = ‘%’ where user =‘root’;
方法2：
GRANT ALL PRIVILEGES ON . TO ‘root’@‘%’ IDENTIFIED BY ‘w123318’ WITH GRANT OPTION;

一种情况mysql的赋权操作：GRANTALLPRIVILEGESON*.*TOroot@%IDENTIFIEDBY123456WITHGRANTOPTION；mysql赋权操…

一种情况
mysql的赋权操作：GRANT ALL PRIVILEGES ON . TO ‘root‘@‘%‘ IDENTIFIED BY ‘123456‘ WITH GRANT OPTION；
mysql赋权操作：

GRANT ALL PRIVILEGES ON . TO ‘root’@‘%’ IDENTIFIED BY ‘123456’ WITH GRANT OPTION;
flush privileges;
GRANT：赋权命令
ALL PRIVILEGES：当前用户的所有权限
ON：介词
.：当前用户对所有数据库和表的相应操作权限
TO：介词
‘root’@’%’：权限赋给root用户，所有ip都能连接
IDENTIFIED BY ‘123456’：连接时输入密码，密码为123456
WITH GRANT OPTION：允许级联赋权

20200901:
将GRANT语句通过代码块包起来

二种情况
mysql中远程连接权限语句grant all privileges on .VawFYbXAcO to ‘root‘@‘%‘ identified by ‘123456‘ with grant optio报错
grant all privileges on . tojavascript ‘root‘@‘%‘ identified by ‘123456‘ with grant option
原因： mysql的版本问题，这条语句适用于MySQL8.0之前

解决： mysql8.0及以上版本需要使用以下语句：

create user root@'%' identified by '123456';
grant all privileges on *.* to root@'%' with grant option;

到此这篇关于mysql的赋权操作：GRANT ALL PRIVILEGES ON . TO ‘root‘@‘%‘ IDENTIFIED BY ‘123456‘ WITH GRANT OPTION；的文章就介绍到这了,更多相关mysql的赋权操作：GRANT ALL PRIVILEGES ON . TO ‘root‘@‘%‘ IDENTIFIED BY ‘123456‘ WITH GRANT OPTION；

7、最后刷新一下：flush privileges;

#一定要记得在写sql的时候要在语句完成后加上" ; "下面是图示说明

D:MySqlin>mysqld --install "MySql80" --defaults-file="C:/mysql/mysql-8.0.31-winx64/my.ini"

wxlly06

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
复制链接

分享到 QQ

分享到新浪微博

扫一扫

专栏目录