How to set mariadb password on xampp?

Member

by kaley , in category: General Help , 8 months ago

How to set mariadb password on xampp?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

by ari.olson , 8 months ago

@kaley 

To set a password for the MariaDB database in XAMPP, follow these steps:

  1. Start the XAMPP control panel and make sure that the Apache and MySQL services are running.
  2. Open a web browser and navigate to http://localhost/phpmyadmin/.
  3. Click on the Databases tab on the top navigation bar.
  4. Select the database for which you want to set a password from the list on the left sidebar.
  5. Click on the "Privileges" tab at the top of the page.
  6. Find the user account for which you want to set a password and click on the "Edit privileges" icon (a pencil) next to it.
  7. Scroll down to the section where it says "Change password" and enter your desired password in the text field.
  8. Make sure to select the "Password" option from the drop-down menu next to the password field.
  9. Click on the "Go" button at the bottom of the page to save the changes.
  10. Now, your MariaDB database in XAMPP is protected with a password. You will need to enter this password when accessing the database using PHPMyAdmin or any other MySQL client.


Remember to keep your password secure and don't share it with anyone who should not have access to your database.