Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.mysql > #6211 > unrolled thread

Re: phpmyadmin #2002 - No such file or directory

Back to article view | Back to comp.databases.mysql

This discussion starts older than the indexed window; earlier articles aren't shown. The article labeled Started by below is the oldest one visible, not the original post.

Contents

  Re: phpmyadmin #2002 - No such file or directory gordonb.5e2rd@burditt.org (Gordon Burditt) - 2016-07-14 18:37 -0500
    Re: phpmyadmin #2002 - No such file or directory "J.O. Aho" <user@example.net> - 2016-07-15 08:32 +0200

#6211 — Re: phpmyadmin #2002 - No such file or directory

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'@'localhost' (using password: YES)

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'@'localhost' (using password: YES)

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. 

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'@'localhost' (using password: NO)

There's no tilde in that one!

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.

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?

[toc] | [next] | [standalone]

#6212

On 07/15/16 01:37, Gordon Burditt wrote:
> This belongs in comp.databases.mysql, not comp.lang.php.

Do you know if the OP do subscribe to c.d.m? You at least cross post and
in worst case you may set followup-to, but then you tell that, for you
still loose major input as people may not always subscribe to the
followup-to newsgroup.


>> 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'@'localhost' (using password: YES)
> 
> 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'@'localhost' (using password: YES)
> 
> 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. 
> 
> 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'@'localhost' (using password: NO)
> 
> There's no tilde in that one!

No password, add -p to the command line.


> 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.

Unless the password in the configuration file is encrypted, it do not
add any security over using -p (without supplying the password) in the
command line, the only way to get hold of the password would be a
keylogger when you use -p (without supplying the password).

> 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?
> 

-- 

 //Aho

[toc] | [prev] | [standalone]

Back to top | Article view | comp.databases.mysql

csiph-web