Dev {Tricks}

You are here: Home / Archives for Server and Hosting

by

How to change root password of CWP and CWP pro

  • Change root password in CentOS Web Panel
  • CWP admin password – How we reset it via panel
  • Change root password in CentOS Web Panel

Login to CWP account

  • Go to Server Settings->Change Root Password.
  • Enter your new password; confirm the new password.
  • Click the Change Root Password button.
  • You will see the confirmation message: 
    Changing password for user root.
passwd: all authentication tokens updated successfully.

 

 

by

Update a column value, replacing part of a string

  • How to Replace Part of a String in MySQL
  • Replace part of string in mysql table column
  • Find and Replace text in the entire table
  • MySQL REPLACE String Function: Find & Replace Text

Replace the bold text as per your table name, field/column name, strings and conditions.

UPDATE table_name
SET field_name = REPLACE(field_name, 'string_to_find', 'string_to_replace')
WHERE conditions;

Example,
Table name: publication_settings
Field/column name: setting_value
String to change: Copyright © to ©

where conditions
Field/column name: setting_name
Field string/value: abstract

UPDATE publication_settings
SET setting_value = REPLACE(setting_value, 'Copyright ©', '©')
WHERE setting_name LIKE ('abstract');