Dev {Tricks}

You are here: Home / Home

by

How to reset MySQL root password | CWP

    • CWPpro Database connection 
      vi /usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php
    • MySQL root password 
      vi /root/.my.cnf
    • Reset the MySQL root password fast with this command 
      /scripts/mysql_pwd_reset -q

 

by

MariaDB Upgrade to the new version | CWP

 

    • Check installed MariaDB version on your server 
      rpm -qa|grep -i maria
    • MariaDB Repository Changes
      Modify repo file to the version you want to upgrade

      vi /etc/yum.repos.d/mariadb.repo
    • Output 
      [mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.2/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
enabled=1
    • Modify 10.2 with the version you want to upgrade
      Example for upgrade to MariaDB 10.5

      [mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.5/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
enabled=1
    • Stop and remove the old version of MariaDB (Databases will not be removed) 
      service mysql stop
service mariadb stop
systemctl disable mariadb
rpm --nodeps -ev MariaDB-server
  • Install the new version of MariaDB 
    yum clean all
yum -y update "MariaDB-*"
yum -y install MariaDB-server
systemctl enable mariadb
service mariadb start
mysql_upgrade
  • Check for the custom configuration 
    diff -Bw /etc/my.cnf.d/server.cnf.rpmsave /etc/my.cnf.d/server.cnf
  • Verify upgraded packages 
    rpm -qa|grep -i maria
  • That’s All

Yum repository list of the available versions
http://yum.mariadb.org/

by

Install Optimize with optimize.js (sync)

Create Google Analytics account.

 

 

Create Optimize account and container

  • Sign in to optimize.google.com.
  • Click Create account.
  • Enter an account name.
  • Agree to the Optimize Terms of Service.
  • Enter a container name.
  • Click Create.

Place the Optimize snippet (below) at the top of thein your web page(s).

<script src=”https://www.googleoptimize.com/optimize.js?id=OPT_CONTAINER_ID”></script>

Note: Replace OPT_CONTAINER_ID with your Optimize container ID.

 

 

[GA4] Link Optimize to Analytics

 

https://tagmanager.google.com/

https://support.google.com/analytics/answer/9304153#add-tag

 

Set up data collection for websites

You’ll need to add the Google tag to your web pages to begin seeing data in your new Google Analytics 4 property.

Add the Google tag directly to your web pages

You need access to the HTML for your web pages. Ask your web developer to perform these steps if you’re unable to complete the steps yourself.

  1. Sign in to your Google Analytics account.
  2. Click Admin.
  3. At the top of the Property column, select your property.
  4. In the Property column, click Data streams > Web.
  5. Click the data stream for your website.
  6. Under Google tag, click View tag instructions.
  7. On the Installation instructions page, select Install manually:
    On the screen, you’ll see the JavaScript snippet for your account’s Google tag. Your Google tag is the entire section of code that appears, beginning with:<!– Google tag (gtag.js) –>
    and ending with
    </script>

Paste your Google tag immediately after the <head> on each page of your website.

Data collection may take up to 30 minutes to begin. You can then use the Realtime report to verify that you’re receiving data.

Don’t see a Data Streams option in the Property column? You are in a Universal Analytics property instead of the GA4 property that you just created. Use the property selector or Admin to navigate to your new GA4 property.

 

 

by

Journey to Laravel & Vue – December to February 2022/2023

Journey to Laravel & Vue
Course Curriculum

Course Instructor
Rasel Ahmed

FB Group: https://fb.com/groups/1661735757554627/
FB Events: https://fb.com/groups/1661735757554627/events/

Online Classes and tasks
Journey to Laravel & Vue – December to February –
Youtube Playlist: [Link]

  1. Intro meeting [YouTube]
  2. Learn HTML & CSS [YouTube]
  3. Make a layout [YouTube]
  4. Javascript [YouTube]
  5. PHP [YouTube]
  6. Hosting & Exam guideline [YouTube]
  7. Make a layout [YouTube]
    • Layout [Link]
    • Color Picker for windows [Pixie]
  8. Templating [YouTube]

Important Video Tutorials

Important Links

  • Chocolatey [Link]
  • CSS Tricks [Link]
  • Earn Your PHP Certification [Link]
  • CSSBattle’s “LEARN” [Link]
  • FLEXBOX FROGGY [Game Link]
  • Local Server Laragon [Download]
  • PHP Sandbox [Link]
  • Figma [Link]

Software Links