Databases
StackOverflow2013
Postsdbo
POCannot log in to phpMyAdmin with my root password for mySQL (on Mac OS X Lion)
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCannot log in to phpMyAdmin with my root password for mySQL (on Mac OS X Lion)
    primarykey
    data
    text
    <p>So I am trying to log in to phpMyAdmin using my root password (Username: root Password: ******), however, I continue to receive the error: #2002 Cannot log in to the MySQL server</p> <p>I am pretty sure I know the root password, as I have typed into terminal on Mac OS X the line:</p> <pre><code>sudo /usr/local/mysql/support-files/mysql.server start </code></pre> <p>and was prompted with a <code>"Password:"</code> line. I typed the password, and the terminal read:</p> <p><code>Starting MySQL...SUCCESS!</code> And thus the server started up. I am not sure why the same password is not working for phpMyAdmin. </p> <p>I have tried setting the password in terminal with the command:</p> <pre><code>/usr/local/mysql/bin/mysqladmin -u root password ******* </code></pre> <p>But I receive the output: </p> <pre><code>/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)' </code></pre> <p>I would very much appreciate help. I am at my wits end with this. I have tried several websites, and the mySQL instructions are useless on this matter. A detailed explanation on how to solve this problem (on Mac OS X Lion) would be very helpful. Thank you. </p> <p>Update:</p> <p>I've been trying to reset the root password, and have been following these instructions: <a href="http://www.coolestguyplanet.net/how-to-change-the-mysql-root-password/" rel="noreferrer">http://www.coolestguyplanet.net/how-to-change-the-mysql-root-password/</a></p> <p>However, when I use the command: /usr/local/mysql/bin/mysqld_safe --skip-grant-tables</p> <p>I receive the following output:</p> <pre><code>111217 10:00:42 mysqld_safe Logging to '/usr/local/mysql/data/******-********-MacBook-Pro.local.err'. 111217 10:00:42 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data /usr/local/mysql/bin/mysqld_safe: line 107: /usr/local/mysql/data/********-********-MacBook-Pro.local.err: Permission denied /usr/local/mysql/bin/mysqld_safe: line 144: /usr/local/mysql/data/*******-**********-MacBook-Pro.local.err: Permission denied 111217 10:00:42 mysqld_safe mysqld from pid file /usr/local/mysql/data/*********-********-MacBook-Pro.local.pid ended /usr/local/mysql/bin/mysqld_safe: line 107: /usr/local/mysql/data/*******-*********-MacBook-Pro.local.err: Permission denied **********-*********-MacBook-Pro:~ myname$ </code></pre> <p>Why would my permission be denied??</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USuser1072337
    1. USuser1072337
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POCannot log in to phpMyAdmin with my root password for mySQL (on Mac OS X Lion)
      1. USChris Go
      1. VTFavorite
    2. VO
      singulars
      1. POCannot log in to phpMyAdmin with my root password for mySQL (on Mac OS X Lion)
      1. This table or related slice is empty.
      1. VTUpMod
    1. COCan you connect to the `mysql` command line client using the root password?
      singulars
      1. POCannot log in to phpMyAdmin with my root password for mySQL (on Mac OS X Lion)
      1. USEric J.
    2. COno, as below indicates
      singulars
      1. POCannot log in to phpMyAdmin with my root password for mySQL (on Mac OS X Lion)
      1. USuser1072337
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload