1.本地Navicat for MySQL無法連接至伺服器(Centos 7 x86_64 bbr) 2.部署到伺服器上後(Centos 7 x86_64 bbr)表單提交亂碼問題 ...
作者:晨鐘暮鼓c
個人微信公眾號:程式猿的月光寶盒
1.本地Navicat for MySQL無法連接至伺服器(Centos 7 x86_64 bbr)
1045錯誤:
解決步驟:
1.查看用戶名密碼是否錯誤
2.用戶名密碼無誤的情況下,遠程登錄伺服器進入mysql,
mysql> use mysql;
Database changed
mysql> grant all privileges on *.* to root@'%' identified by "password";
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> select host,user,password from user;
+--------------+------+-------------------------------------------+
| host | user | password |
+--------------+------+-------------------------------------------+
| localhost | root | *A731AEBFB621E354CD41BAF207D884A609E81F5E |
| 192.168.1.1 | root | *A731AEBFB621E354CD41BAF207D884A609E81F5E |
| % | root | *A731AEBFB621E354CD41BAF207D884A609E81F5E |
+--------------+------+-------------------------------------------+
3 rows in set (0.00 sec)grant all privileges on *.* to root@'%' identified by "password";
以上這句話,表示所有的ip可以以用戶名root密碼password遠程訪問該機器上的MySql.當然可以自定義密碼.
以上,問題基本解決(我就是這麼解決了,如果你的還沒解決就再google吧)
2.部署到伺服器上後(Centos 7 x86_64 bbr)表單提交亂碼問題
這個問題,簡直噁心....因為本地開發環境是tomcat7開發,我的伺服器是tomcat8,網上查了一大堆...什麼7-->8要在service.xml改配置編碼...都沒用,打算放棄...以為是國外伺服器的編碼原因...然後...突然想起來,在jdbc連接資料庫的時候 URL後面可能會有問題
原來的
<property name="user">root</property>
<property name="password">root</property>
<property name="driverClass">com.mysql.jdbc.Driver</property>
<property name="jdbcUrl">jdbc:mysql://ip地址:3306/class3</property>jsbcUrl添加參數?characterEncoding=UTF-8
改後:
<property name="user">root</property>
<property name="password">root</property>
<property name="driverClass">com.mysql.jdbc.Driver</property>
<property name="jdbcUrl">jdbc:mysql://ip地址:3306/class3?characterEncoding=UTF-8</property>以上,解決
emm,填坑+2
晚安
