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

How to add your Source Code to GitHub

Quick setup  — if you’ve done this kind of thing before  Set up in Desktop or HTTPS SSH Get started by  creating a new file  or  uploading an existing file . We recommend every repository include a  README ,  LICENSE , and  .gitignore . …or create a new repository on the command line echo "# bms" >> README.md git init git add README.md git commit -m "first commit" git branch -M main git remote add origin https://github.com/xxxxxxxxx/bms.git git push -u origin main …or push an existing repository from the command line git remote add origin https://github.com/xxxxxxxxxx/bms.git git branch -M main git push -u origin main -------------------------------------------------------------------------------------------------------- Proper steps to add existing code to GitHub The proper way to push a new project into an existing GitHub repository follows these steps: Create a GitHub repository for the existing project. Copy the GitHub URL for th...
Post a Comment
Read more

How to connect your Website domain name to a Cloud VPS hosting environment running XAMPP

To connect your Website domain name to a Cloud VPS hosting environment running XAMPP, follow these steps: Obtain Your VPS IP Address : Log in to your Contabo account and navigate to your VPS management section to find your server's public IP address. Configure Your Domain's DNS Settings : Access your domain registrar's control panel. Locate the DNS management section. Create an 'A' record pointing your domain (e.g., yourdomain.com ) to your VPS's public IP address. If you want ' www.yourdomain.com ' to also point to your VPS, add a 'CNAME' record for 'www' pointing to 'yourdomain.com'. Set Up Virtual Hosts in XAMPP : On your VPS, open the httpd-vhosts.conf file located at C:\xampp\apache\conf\extra\httpd-vhosts.conf . Add the following configuration, replacing placeholders with your actual domain and directory paths: <VirtualHost *:80> ServerAdmin [email protected] DocumentRoot "C:/xampp/ht...
Post a Comment
Read more

How to Create a Bootable USB Using Rufus

  How to Create a Bootable USB Using Rufus A “ bootable USB ” is a regular USB storage device (like a USB stick or external hard drive) that has an “ISO image” of an operating system saved on it.   An ISO image is an archive file that contains all the information found on an optical disc, such as a CD or DVD. This could, for example, be a Windows installation CD. Normally, whenever you start up your computer, it boots from the operating system stored on your internal hard drive. By running the bootable USB however, you can boot up your computer using the USB’s ISO image instead.  This can be useful if you ever need to recover, repair or install an operating system on your computer. How to Create a Bootable USB using Rufus Rufus is one of several programs that allow you to create an “ISO image” on a USB stick. To create a bootable USB using Rufus, all you need is: Your ISO of choice, e.g. Windows 10 The latest version of Rufus (available online from...
Post a Comment
Read more