Re: phpmyadmin #2002 - No such file or directory

From: Gordon Burditt <>
Date: Thu, 14 Jul 2016 18:37:06 -0500
Message-ID: <i-qdnVROntS_vxXKnZ2dnUU7-N_NnZ2d_at_posted.internetamerica>

[Quoted] This belongs in comp.databases.mysql, not comp.lang.php.

> 1) when I try to log in to phpmyadmin and enter the login name and password,
> I get two error messages:
> #1045 - Access denied for user '~Alla'_at_'localhost' (using password: YES)

[Quoted] Does your user name *REALLY* begin with a tilde? Are you sure about that? It's apparent that your home directory is *not* /Users/~Alla , so where did the tilde come from?

> mysqli_real_connect(): (HY000/1045): Access denied for user '~Alla'_at_'localhost' (using password: YES)

[Quoted] You may need to re-do the configuration of phpMyAdmin if you gave it a username beginning with a tilde to log into MySQL.

Do the environment variables $USER or $LOGNAME have your user name in it beginning with a tilde? If so, fix that.

> But mysql server is running, which is indicated in the system preferences.

[Quoted] If the server says "Access Denied", chances are VERY good it's running.

> 2) mysql start command from the Terminal returns the same error message:
> ERROR 1045 (28000): Access denied for user 'Alla'_at_'localhost' (using password: NO)

[Quoted] There's no tilde in that one!

[Quoted] Does your (MySQL) account have a password? Did you supply a password? (hint: using password: NO) What do you think is supposed to happen when you don't supply a required password? How do you think you might fix the problem of not supplying a required password (on a shell command line)? If you know how to teach Terminal to use a different command line to start MySQL? If so, you might try that.

It is possible (and recommended) to put information in your home directory to hand the client utilities ('mysql', 'mysqldump', 'mysqladmin', etc.) a default server hostname, username, and password by default. A better way appeared in mysql 5.6.6. This involves .my.cnf or .mylogin.cnf files in your home directory. This is more secure than putting a password on the command line, and permits running them in batch shell scripts without being prompted for the password a lot. I'm not going to give details here.

[Quoted] I am intentionally not giving click-by-click instructions to do this. You need to read some documentation on option files for configuring *CLIENT* (not server) programs.

You ran the security script to delete anonymous access to MySQL. You did at some point create a user Alla, right? Received on Fri Jul 15 2016 - 01:37:06 CEST

Original text of this message