MySQL - Change MySQL Root Password

MySQL 5.7.6 and later:

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';

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

MySQL 5.7.5 and earlier:

mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPass');
-------------------------------------------------------------------------------------------

Popular posts from this blog

SAP CPI - Loop Process Call with SuccessFactor (oData V2)

Image
This example will show you how to fetch data from SuccessFactor (oData V2 Message Protocal) with a specific page size. For example, if your data has 10,000 total records and each record consists of 20 child nodes (the result size is around 10MB), you can fetch data by 500 records per request by using Loop Process Call. # My integration process consists of 1. Content Modifier " Initial Data " which I declare property "fetchData". 2. Loop Process Call " Loop Fetch Data " which calls Local Integration Process " Fetch Data From SF ". 3. Groovy Script which writes data from property "fetchData" in an attachment format. This example will focus on step 2 - Loop Process Call & Local Integration Process. # Local Integration Process "Fetch Data from SF".  How does it work? 1. Use Request Reply to call SuccessFactor to get data 500 records per request. 2. Use Groovy Script to get some fields and return in XML format. 3. Use XML to CS...
Read more

C# - BASE64 to Image

public void ConvertBase64ToImage(String strBASE64) {      String _outputFile = @"c:\temp\test.jpg";      try      {         Byte[] _imageBytes = Convert.FromBase64String(strBASE64);         MemoryStream ms = new MemoryStream(_imageBytes, 0, _imageBytes.Length);         // Convert byte[] to Image         ms.Write(_imageBytes, 0, _imageBytes.Length);         Image _image = Image.FromStream(ms, true);         _image.Save(_outputFile);         MessageBox.Show("save image success");      }      catch (Exception ex)      {      ...
Read more

HTML - ToolTip

Step1. Add "htmltooltip.js" into <head> tag in your HTML See "htmltooltip.js" source code here Step2. Insert this stylesheet script in <head> tag in your HTML <style type="text/css">      div.htmltooltip {      position: absolute; /*leave this and next 3 values alone*/      z-index: 1000;      left: -1000px;      top: -1000px;      background: #EEEEEE;      border: 2px solid black;      color: black;      padding: 3px;      width: 250px; /*width of tooltip*/      } </style> In <body> tag. Add your tooltips text to <div class="htmltooltip"></div>. Example. <a href="#" rel="htmltooltip"> Displaying My tooltip text </a> <div class="htmlt...
Read more