XAMPP Note Reset mysql/mariadb root user password

Currently using MySQL, the installation under Mac is XAMPP 4.5.2, which requires resetting the MYSQL/MARIADB root user password. Encounter a small problem recorded in the following:

1, according to the official guidance (http://localhost/dashboard/docs/reset-mysql-password.html) prompt, run the following command:

(1) Start MySQL SERVER First, this is no problem;

(2) Open the terminal, switch to the default installation location of XAMPP, on my Mac is

/applications/xampp/xamppfiles/bin

, and then run the following command:

Mysqladmin--user=root Password "NewPassword"

Error occurred: Command not found!

2, the preliminary method: The use of soft link technology, as follows:

Ln-s/applications/xampp/xamppfiles/bin/mysqladmin/usr/bin

An error occurred as follows: Operation not permitted

Change to:

Ln-s/applications/xampp/xamppfiles/bin/mysqladmin/usr/local/bin

Build a soft link successfully!

3, Change Password:

Mysqladmin--user=root Password "NewPassword"

Command succeeded!

This article is from the "Green Peak" blog, please make sure to keep this source http://zhuxianzhong.blog.51cto.com/157061/1829402

Xampp Note Reset mysql/mariadb root user password