Skip to main content

Reset the MySQL/MariaDB Root Password Ubuntu

By default, the MySQL/MariaDB installation that ships with XAMPP has an empty root password. This is a serious security risk, especially if you plan to use XAMPP in production scenarios.
To change the MySQL/MariaDB root password, follow these steps:
  1. Ensure that the MySQL/MariaDB server is running.
  2. Open a new Linux terminal.
  3. Use the mysqladmin command-line utility to alter the MySQL/MariaDB password, using the following syntax:
    mysqladmin --user=root password "newpassword"
    The mysqladmin command-line utility is located within the bin/ subdirectory of the XAMPP installation directory, typically /opt/lampp.
    For example, to change the MySQL/MariaDB root password from its default empty value to the password gue55me, you would execute:
    /opt/lampp/bin/mysqladmin --user=root password "gue55me"
    Or, if a password has already been previously set and you’d like to change it to a new one, you can use the following syntax:
    mysqladmin --user=root --password=oldpassword password "newpassword"
    For example, to change the root password from 12345 to gue55me, you would execute:
    /opt/lampp/bin/mysqladmin --user=root --password=12345 password "gue55me"
  4. Test that your password change has been accepted, by attempting to connect to the MySQL/MariaDB server using the mysqlcommand-line client in the same directory. For example, you could use the command below to connect to the server and return the results of a calculation:
    /opt/lampp/bin/mysql --user=root --password=gue55me -e "SELECT 1+1"

Credits: Apache Friends

Note: For documentation Purposes

THANK YOU!!! 

Comments

Post a Comment

Popular posts from this blog

Two simple ways to block internet browsing using Windows Firewall.

  Here are two simple ways to block internet browsing using Windows Firewall. Choose Method A (Block all browsers) or Method B (Block specific browsers like Chrome/Edge/Firefox). ✅ METHOD A — BLOCK ALL INTERNET BROWSING (Recommended) This blocks ALL internet access for ALL applications except those you allow. Steps: Press Windows + R Type: wf.msc Press Enter On the left, click Outbound Rules On the right, click New Rule… Select Custom → Next Under Program , choose All programs → Next Under Protocol and Ports , click Next Under Scope , click Next Under Action , select: ✔ Block the connection Click Next Under Profile , select: ✔ Domain ✔ Private ✔ Public Click Next Name the rule: Block Internet Browsing Click Finish ✔ This will instantly disable ALL internet access. 🟨 OPTIONAL: Allow exceptions If you want to allow EXCEPTIONS (example: allow only MT5, or allow Windows Update): Create a New Outbound Rule Select Program Browse to the app...
Post a Comment
Read more

Block Browser Using Software Restriction Policy

Here are several alternative ways to block web browsers in Windows (Chrome, Edge, Firefox, etc.) without using the firewall method you mentioned earlier . Choose the method that best fits your need. 1 . Block Browser Using AppLocker (Windows Pro/Enterprise) Blocks the browser application from opening completely. Steps: Press Win + R , type: secpol.msc Go to: Application Control Policies → AppLocker → Executable Rules Right-click → Create New Rule Select: Deny User = Standard user (not Admin) Choose Path : Chrome: C:\Program Files\Google\Chrome\Application\chrome.exe Edge: C:\Program Files (x86)\Microsoft\Edge\Application\msedge.exe Firefox: C:\Program Files\Mozilla Firefox\firefox.exe Apply. Result: User cannot open the browser. Admin still can. 2 . Block Browser Using Software Restriction Policy For Windows Pro. Steps: Press Win + R , type: gpedit.msc Navigate to: Computer Configuration → Windows Settings → Security Settings → Soft...
Post a Comment
Read more

How to stop Windows 10 from upgrading to Windows 11

  ✅ Method 1 — Pause Updates (Temporary Only) Good if you just want to delay. Steps Go to Start → Settings → Windows Update Click Pause updates Choose how long to pause ➡ This only delays updates. After the pause period, updates resume automatically. ( Microsoft Support ) ✅ Method 2 — Block Windows 11 Using Group Policy (Best for Pro / Enterprise) This is the most recommended permanent method . Steps Press Win + R Type gpedit.msc Go to: Computer Configuration → Administrative Templates → Windows Components → Windows Update → Windows Update for Business Open Select the target Feature Update version Set to Enabled Enter your Windows 10 version (ex: 21H2 , 22H2 ) ➡ This forces your PC to stay on Windows 10 and not upgrade to Windows 11. ( Software Hubs ) ✅ Method 3 — Registry Method (Works for Windows 10 Home) If you don’t have Group Policy: Path HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows\WindowsUpdate Create: DWORD → TargetReleaseVersion = 1 String → TargetReleaseVersionI...
Post a Comment
Read more