title: Facing issue with PHPMyAdmin on MySQL service XAMPP
body: <p>I am encountering this particular issue when on PHPMyAdmin. The MySQL service on XAMPP isn't even starting as well. Here is the issue:</p>
  <p><a href="https://i.stack.imgur.com/xli9O.png" rel="nofollow noreferrer">Error Image</a></p>
  <p>Here is my config.inc.php code script:</p>
  <pre><code>&lt;?php
  /**
   * phpMyAdmin sample configuration, you can use it as base for
   * manual configuration. For easier setup you can use setup/
   *
   * All directives are explained in documentation in the doc/ folder
   * or at &lt;https://docs.phpmyadmin.net/&gt;.
   */
  
  declare(strict_types=1);
  
  /**
   * This is needed for cookie based authentication to encrypt password in
   * cookie. Needs to be 32 chars long.
   */
  $cfg['blowfish_secret'] = 'xampp'; /* YOU SHOULD CHANGE THIS FOR A MORE SECURE COOKIE AUTH! */
  
  /**
   * Servers configuration
   */
  $i = 0;
  
  /**
   * First server
   */
  $i++;
  /* Authentication type */
  $cfg['Servers'][$i]['auth_type'] = 'config';
  $cfg['Servers'][$i]['user'] = 'root';
  $cfg['Servers'][$i]['password'] = '';
  /* Server parameters */
  //$cfg['Servers'][$i]['host'] ='localhost';
  $cfg['Servers'][$i]['compress'] = false;
  $cfg['Servers'][$i]['AllowNoPassword'] = true;
  
  /**
   * phpMyAdmin configuration storage settings.
   */
  
  /* User used to manipulate with storage */
  //$cfg['Servers'][$i]['controlhost'] = 'localhost';
  //$cfg['Servers'][$i]['controlport'] = '3306';
  $cfg['Servers'][$i]['controluser'] = 'pma';
  $cfg['Servers'][$i]['controlpass'] = '';
  
  /* Storage database and tables */
  $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
  $cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';
  $cfg['Servers'][$i]['relation'] = 'pma__relation';
  $cfg['Servers'][$i]['table_info'] = 'pma__table_info';
  $cfg['Servers'][$i]['table_coords'] = 'pma__table_coords';
  $cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages';
  $cfg['Servers'][$i]['column_info'] = 'pma__column_info';
  $cfg['Servers'][$i]['history'] = 'pma__history';
  $cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';
  $cfg['Servers'][$i]['tracking'] = 'pma__tracking';
  $cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';
  $cfg['Servers'][$i]['recent'] = 'pma__recent';
  $cfg['Servers'][$i]['users'] = 'pma__users';
  $cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';
  $cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';
  $cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches';
  $cfg['Servers'][$i]['central_columns'] = 'pma__central_columns';
  $cfg['Servers'][$i]['designer_coords'] = 'pma__designer_coords';
  $cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings';
  $cfg['Servers'][$i]['export_templates'] = 'pma__export_templates';
  $cfg['Servers'][$i]['favorite'] = 'pma__favorite';
  // $cfg['Servers'][$i]['favorite'] = 'pma__favorite';
  // $cfg['Servers'][$i]['users'] = 'pma__users';
  // $cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';
  // $cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';
  // $cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches';
  // $cfg['Servers'][$i]['central_columns'] = 'pma__central_columns';
  // $cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings';
  // $cfg['Servers'][$i]['export_templates'] = 'pma__export_templates';
  
  /**
   * End of servers configuration
   */
  
  /**
   * Directories for saving/loading files from server
   */
  $cfg['UploadDir'] = '';
  $cfg['SaveDir'] = '';
  
  /**
   * Whether to display icons or text or both icons and text in table row
   * action segment. Value can be either of 'icons', 'text' or 'both'.
   * default = 'both'
   */
  //$cfg['RowActionType'] = 'icons';
  
  /**
   * Defines whether a user should be displayed a &quot;show all (records)&quot;
   * button in browse mode or not.
   * default = false
   */
  //$cfg['ShowAll'] = true;
  
  /**
   * Number of rows displayed when browsing a result set. If the result
   * set contains more rows, &quot;Previous&quot; and &quot;Next&quot;.
   * Possible values: 25, 50, 100, 250, 500
   * default = 25
   */
  //$cfg['MaxRows'] = 50;
  
  /**
   * Disallow editing of binary fields
   * valid values are:
   *   false    allow editing
   *   'blob'   allow editing except for BLOB fields
   *   'noblob' disallow editing except for BLOB fields
   *   'all'    disallow editing
   * default = 'blob'
   */
  //$cfg['ProtectBinary'] = false;
  
  /**
   * Default language to use, if not browser-defined or user-defined
   * (you find all languages in the locale folder)
   * uncomment the desired line:
   * default = 'en'
   */
  //$cfg['DefaultLang'] = 'en';
  //$cfg['DefaultLang'] = 'de';
  
  /**
   * How many columns should be used for table display of a database?
   * (a value larger than 1 results in some information being hidden)
   * default = 1
   */
  //$cfg['PropertiesNumColumns'] = 2;
  
  /**
   * Set to true if you want DB-based query history.If false, this utilizes
   * JS-routines to display query history (lost by window close)
   *
   * This requires configuration storage enabled, see above.
   * default = false
   */
  //$cfg['QueryHistoryDB'] = true;
  
  /**
   * When using DB-based query history, how many entries should be kept?
   * default = 25
   */
  //$cfg['QueryHistoryMax'] = 100;
  
  /**
   * Whether or not to query the user before sending the error report to
   * the phpMyAdmin team when a JavaScript error occurs
   *
   * Available options
   * ('ask' | 'always' | 'never')
   * default = 'ask'
   */
  //$cfg['SendErrorReports'] = 'always';
  
  /**
   * You can find more configuration options in the documentation
   * in the doc/ folder or at &lt;https://docs.phpmyadmin.net/&gt;.
   */
  </code></pre>
  <p>Furthermore, when I change my auth_type from config to cookie or http, it asks me to log in, and if I use my credentials as username -&gt; root and password -&gt; nothing, it is also not working. Here is an image of that login error on auth_type cookie:</p>
  <p><a href="https://i.stack.imgur.com/o4sP9.png" rel="nofollow noreferrer">Error Image</a></p>
  <p>Also, on the XAMPP panel, my MySQL service isn't starting, and if I check the log, it says this: ERROR: Failed to start &quot;mysql&quot;: cannot start service: /opt/lampp/bin/mysql.server: 264: kill: No such process.</p>
  <p>And when I open the XAMPP terminal, and try to run MySQL by typing mysql -u root -p, and enter my password as nothing, it displays this error message: Can't connect to local MySQL server through socket '/opt/lampp/var/mysql/mysql.sock' (111)</p>
  <p>These are all the error messages I encountered.</p>
  <p>I really need access to PHPMyAdmin so that I can use my databases again, and I really hope that this issue is resolvable. I am kind of stressed out. What should I do? Please help me! Thanks for any help!</p>