title: Restart to default XAMPP or get access for user 'root'@'localhost after changing password
body: <p><strong>Here is the technical information:</strong></p>
  
  <p>XAMP : 7.2.10-0</p>
  
  <p>MacOS High Sierra: 10.13.6</p>
  
  <p><strong>Problem:</strong></p>
  
  <p>I reseted the MySQL/MariaDB Root Password by using the mysqladmin command-line utility:</p>
  
  <pre><code>mysqladmin --user=root password "newpassword"
  </code></pre>
  
  <p>I know that my password change has been accepted, by attempting to connect to the MySQL/MariaDB server using the mysql command-line client in the same directory.</p>
  
  <pre><code>--user=root --password=newpassword -e "SELECT 1+1"
  </code></pre>
  
  <p>However, when I try to access myphp, I get</p>
  
  <pre><code> mysqli_real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: NO)
  </code></pre>
  
  <p>I tried different solutions online, but none worked:</p>
  
  <ol>
  <li><a href="https://stackoverflow.com/questions/11096045/mysql-said-documentation-1045-access-denied-for-user-rootlocalhost-usi">MySQL said: Documentation #1045 - Access denied for user &#39;root&#39;@&#39;localhost&#39; (using password: NO)</a></li>
  </ol>
  
  <p>I am not able to change in config.inc.php</p>
  
  <pre><code>$cfg['Servers'][$i]['password']='NO'
  </code></pre>
  
  <p>because I don't have privileges. None of the solutions in the previous post helped</p>
  
  <ol start="2">
  <li><a href="https://dba.stackexchange.com/questions/75002/recovering-mysql-root-password-xampp/119749">https://dba.stackexchange.com/questions/75002/recovering-mysql-root-password-xampp/119749</a></li>
  </ol>
  
  <p>Edited my.ini and insert skip-grant-tables below [mysqld]
  Restart MySQL
  I am able to get into phpmyadmin; however, I don't have user privileges.</p>
  
  <p><strong>Is there a way to restart to default xampp? I would like to have it like it was before changing the password.</strong></p>