<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[hellowangchaochao的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/hellowangchaochao</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; hellowangchaochao]]></copyright><item><title><![CDATA[mysql修改用户密码和无法远程登录]]></title><link>https://blog.youkuaiyun.com/hellowangchaochao/article/details/121145128</link><guid>https://blog.youkuaiyun.com/hellowangchaochao/article/details/121145128</guid><author>hellowangchaochao</author><pubDate>Thu, 04 Nov 2021 16:21:55 +0800</pubDate><description><![CDATA[1、cmd命令输入：mysql -uroot -p；

2、set password for root@localhost = password('123456');

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

4、flush privileges;

出现如下截图内容表示设置成功，可远程登录连接：




...]]></description><category></category></item><item><title><![CDATA[mysql数据库替换表字段包含的某内容]]></title><link>https://blog.youkuaiyun.com/hellowangchaochao/article/details/76316648</link><guid>https://blog.youkuaiyun.com/hellowangchaochao/article/details/76316648</guid><author>hellowangchaochao</author><pubDate>Sat, 29 Jul 2017 14:29:26 +0800</pubDate><description><![CDATA[SQL语句如下
                   表名                                 字段名                              字段             原值      要修改的值
UPDATE yl_customer_info SET head_img=REPLACE (head_img,'fileImg','mapImg')]]></description><category></category></item><item><title><![CDATA[mysql使用sql语句同步数据]]></title><link>https://blog.youkuaiyun.com/hellowangchaochao/article/details/76315257</link><guid>https://blog.youkuaiyun.com/hellowangchaochao/article/details/76315257</guid><author>hellowangchaochao</author><pubDate>Sat, 29 Jul 2017 14:07:34 +0800</pubDate><description><![CDATA[使用sql语句同步源表和目标表的指定地段
INSERT INTO yl_customer_info(customer_name,customer_level,customer_type)


SELECT customer_name,customer_level,customer_type


FROM yl_customer_info_copy]]></description><category></category></item><item><title><![CDATA[linux系统下部署war包]]></title><link>https://blog.youkuaiyun.com/hellowangchaochao/article/details/73223773</link><guid>https://blog.youkuaiyun.com/hellowangchaochao/article/details/73223773</guid><author>hellowangchaochao</author><pubDate>Wed, 14 Jun 2017 14:08:15 +0800</pubDate><description><![CDATA[本人也是linux的菜鸟，以前没接触过这个系统，前段时间因公司项目需要用到linux系统做服务器，所以将自己的操作学习心得在这里写成博客分享，希望能帮助同样是刚接触linux系统的小白少走弯路，写的不够详细，望大牛勿喷！！！


1、链接到操作系统
2、第一步停掉tomcat服务，如下（操作命令及截图）
a、进入到tomcat的bin目录，    cd /soft/apache-tomc]]></description><category></category></item><item><title><![CDATA[linux操作系统删除文件和文件夹]]></title><link>https://blog.youkuaiyun.com/hellowangchaochao/article/details/73223551</link><guid>https://blog.youkuaiyun.com/hellowangchaochao/article/details/73223551</guid><author>hellowangchaochao</author><pubDate>Wed, 14 Jun 2017 13:56:43 +0800</pubDate><description><![CDATA[1、远程链接到linux操作系统，按照下图操作


2、删除命令
删除文件夹：rm -rf /soft/apache-tomcat-7.0.77/webapps/ROOT
删除文件：rm -f /soft/apache-tomcat-7.0.77/webapps/EasyGreen.war


3、删除成功后会没有任何提示，如下图]]></description><category></category></item><item><title><![CDATA[win7配置JDK环境变量]]></title><link>https://blog.youkuaiyun.com/hellowangchaochao/article/details/54136332</link><guid>https://blog.youkuaiyun.com/hellowangchaochao/article/details/54136332</guid><author>hellowangchaochao</author><pubDate>Fri, 06 Jan 2017 11:44:43 +0800</pubDate><description><![CDATA[JDK环境（path）的配置：

我们右击桌面上我的电脑图标，选择“属性”，选择“高级系统设置”，点击“环境变量”。

①  配置classpath环境变量：

在系统变量中，点击“新建”，变量名为classpath，变量值为.(英文点)，然后点击确定。Classpath环境变量就配置好了。



②  配置JAVA_HOME环境变量：

在系统变量中，点击“新建”，变量名]]></description><category></category></item><item><title><![CDATA[oracle数据库创建表空间及用户授权]]></title><link>https://blog.youkuaiyun.com/hellowangchaochao/article/details/54020525</link><guid>https://blog.youkuaiyun.com/hellowangchaochao/article/details/54020525</guid><author>hellowangchaochao</author><pubDate>Wed, 04 Jan 2017 16:15:19 +0800</pubDate><description><![CDATA[第一步、创建表空间



create tablespace GD_Test_YD3_Data  
logging datafile 'GD_Test_YD3_Data.dbf'   
size 512M   
autoextend on   
maxsize unlimited  
extent management local;
  


第二步、创建用户


]]></description><category></category></item><item><title><![CDATA[plsql导出oracle数据库表结构及表数据]]></title><link>https://blog.youkuaiyun.com/hellowangchaochao/article/details/53886290</link><guid>https://blog.youkuaiyun.com/hellowangchaochao/article/details/53886290</guid><author>hellowangchaochao</author><pubDate>Mon, 26 Dec 2016 15:12:22 +0800</pubDate><description><![CDATA[导出表结构
1、打开pl/sql客户端(导出数据表结构)
2、在工具头部选择tools》export user objects
 
 
 
3、导出
 
 
 
 
 
 
 
 
 
导出表数据
1、在plsql头部选择tools》export tables
 
 
 
2、导出表数据]]></description><category></category></item></channel></rss>