vue項(xiàng)目部署上線遇到的問(wèn)題及解決方法

mkdir /usr/local //進(jìn)入此目錄 
wget http://dev.MySQL.com/get/Downloads/MySQL-5.7/mysql-5.7.11-Linux-glibc2.5-x86_64.tar.gz //下載mysql壓縮包
tar -xvf mysql-5.7.11-Linux-glibc2.5-x86_64.tar.gz //解壓
mv mysql-5.7.11-Linux-glibc2.5-x86_64/ mysql //重命名,方便后面的設(shè)置groups mysql //查看是否有mysql用戶組,有就跳過(guò)(mysql:mysql) 沒(méi)有就創(chuàng)建(groups:mysql: No such user) 括號(hào)里為判斷信息groupadd mysql useradd -r -g mysql mysql //創(chuàng)建用戶組cd mysql/ chown -R mysql:mysql ./ //修改權(quán)限
mkdir /usr/local/mysql/data //創(chuàng)建data目錄
./bin/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/ //初始化信息 這里可能報(bào)錯(cuò)一個(gè)模塊找不到,直接yum安裝 就行了
[root@localhost mysql] ./bin/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/
2016-01-20 02:47:35 [WARNING] mysql_install_db is deprecated. Please consider switching to mysqld --initialize
2016-01-20 02:47:45 [WARNING] The bootstrap log isn't empty:
2016-01-20 02:47:45 [WARNING] 2016-01-19T18:47:36.732678Z 0 [Warning] --bootstrap is deprecated. Please consider using --initialize instead

cp -a ./support-files/my-default.cnf /etc/my.cnf //復(fù)制文件
cp -a ./support-files/mysql.server /etc/init.d/mysqld
修改my.cnf文件
# These are commonly set, remove the # and set as required.
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
port = 3306
# server_id = .....
socket = /tmp/mysql.sock
character-set-server = utf8
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M 
ln -s /usr/local/mysql/ /usr/bin/ //創(chuàng)建In
service mysqld start //啟動(dòng)服務(wù)
[root@localhost ~]# cat /root/.mysql_secret //查看數(shù)據(jù)庫(kù)初始密碼
# Password set for user 'root@localhost' at 2017-03-16 00:52:34 
（as;qwe23QADdqwe //類似這樣的數(shù)據(jù),這就是初始密碼
[root@localhost ~]# mysql -u root -p //登錄數(shù)據(jù)庫(kù)
alter user root@localhost identified by 'tiger'; //修改數(shù)據(jù)庫(kù)密碼(有的時(shí)候修改成功了,遠(yuǎn)程的時(shí)候還是不可以.遠(yuǎn)程管理工具比如dbvisualizer報(bào)錯(cuò)28000 
 那么就在修改一次數(shù)據(jù)庫(kù)密碼)
flush privileges; //刷新
show databases;//顯示數(shù)據(jù)庫(kù)。
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+ 如此顯示就是安裝成功了.

 在shell6連接到mysql 數(shù)據(jù)庫(kù)
 use mysql //選擇mysql 數(shù)據(jù)庫(kù)
 GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION 
 FLUSH PRIVILEGES 

[CREATE - 0 row(s), 0.000 secs] Could not getColumn for vue: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT' at line 1
... 1 statement(s) executed, 0 row(s) affected, exec/fetch time: 0.000/0.000 sec [0 successful, 0 warnings, 1 errors] 

proxyTable: { // 在這里配置如下代碼
 '/api': {
 //target:'http://localhost:8080/', // 你請(qǐng)求的第三方接口GradeSystem
 //target:'http://www.ruoyechenxi.com:8080/GradeSystem', // 你請(qǐng)求的第三方接口
 target:'http://www.ruoyechenxi.com:8080', // 你請(qǐng)求的第三方接口
 changeOrigin:true, // 在本地會(huì)創(chuàng)建一個(gè)虛擬服務(wù)端，然后發(fā)送請(qǐng)求的數(shù)據(jù)，并同時(shí)接收請(qǐng)求的數(shù)據(jù)，這樣服務(wù)端和服務(wù)端進(jìn)行數(shù)據(jù)的交互就不會(huì)有跨域問(wèn)題
 pathRewrite:{ // 路徑重寫(xiě)，
 '^/api': '' // 替換target中的請(qǐng)求地址，也就是說(shuō)以后你在請(qǐng)求http://api.jisuapi.com/XXXXX這個(gè)地址的時(shí)候直接寫(xiě)成/api即可。
 }
 }
 } //config文件夾下的build.js 中 dev 里面配置 

let params = new URLSearchParams(); //這個(gè)請(qǐng)自行百度
 params.append("code", "2");
 this.$axios({
 method: 'post',
 url: '/GradeSystem/repairCode.do',
 data: params
 }).then(function(response) {
 alert(response.data);
 th.$router.push({ path: "/index" });
 }).catch(function(error) {
 alert(error);
 }); 

resp.setHeader("Access-Control-Allow-Origin", "*");
resp.setHeader("Access-Control-Allow-Methods", "POST, GET, OPTIONS, DELETE"); 

index: path.resolve(__dirname, '../dist/index.html'),
 // Paths
 assetsRoot: path.resolve(__dirname, '../dist'),
 assetsSubDirectory: 'static',
 assetsPublicPath: './',
 productionSourceMap: false, 

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee
 http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"
 version="3.1" metadata-complete="true">
 <display-name>Router for Tomcat</display-name>
 <error-page>
 <error-code>404</error-code>
 <location>/index.html</location>
 </error-page>
</web-app>