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

Groups > comp.lang.php > #16861

Re: phpmyadmin #2002 - No such file or directory

Cross-posted to 2 groups.

Show key headers only | View raw

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

Back to comp.lang.php | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

phpmyadmin #2002 - No such file or directory Alla <modelling.data@gmail.com> - 2016-07-11 04:16 -0700
  Re: phpmyadmin #2002 - No such file or directory Jerry Stuckle <jstucklex@attglobal.net> - 2016-07-11 09:48 -0400
    Re: phpmyadmin #2002 - No such file or directory alla.rashitova@gmail.com - 2016-07-11 09:17 -0700
  Re: phpmyadmin #2002 - No such file or directory gordonb.8gp9q@burditt.org (Gordon Burditt) - 2016-07-11 19:53 -0500
    Re: phpmyadmin #2002 - No such file or directory Jerry Stuckle <jstucklex@attglobal.net> - 2016-07-11 21:08 -0400
      Re: phpmyadmin #2002 - No such file or directory gordonb.1jqa2@burditt.org (Gordon Burditt) - 2016-07-12 04:55 -0500
        Re: phpmyadmin #2002 - No such file or directory Jerry Stuckle <jstucklex@attglobal.net> - 2016-07-12 08:35 -0400
          Re: phpmyadmin #2002 - No such file or directory Alla <modelling.data@gmail.com> - 2016-07-14 04:41 -0700
            Re: phpmyadmin #2002 - No such file or directory Jerry Stuckle <jstucklex@attglobal.net> - 2016-07-14 11:00 -0400
              Re: phpmyadmin #2002 - No such file or directory Alla <modelling.data@gmail.com> - 2016-07-14 09:03 -0700
                Re: phpmyadmin #2002 - No such file or directory Jerry Stuckle <jstucklex@attglobal.net> - 2016-07-14 13:24 -0400
                Re: phpmyadmin #2002 - No such file or directory Alla <modelling.data@gmail.com> - 2016-07-16 08:59 -0700
    Re: phpmyadmin #2002 - No such file or directory Alla <modelling.data@gmail.com> - 2016-07-14 04:37 -0700
      Re: phpmyadmin #2002 - No such file or directory Jerry Stuckle <jstucklex@attglobal.net> - 2016-07-14 11:01 -0400
      Re: phpmyadmin #2002 - No such file or directory "J.O. Aho" <user@example.net> - 2016-07-15 08:32 +0200
  Re: phpmyadmin #2002 - No such file or directory praider650@gmail.com - 2016-08-17 02:55 -0700
    Re: phpmyadmin #2002 - No such file or directory buttle <praider650@gmail.com> - 2016-08-17 03:03 -0700
    Re: phpmyadmin #2002 - No such file or directory Jerry Stuckle <jstucklex@attglobal.net> - 2016-08-18 12:15 -0400
  Re: phpmyadmin #2002 - No such file or directory Härra Rabmo <he12091983@gmail.com> - 2022-07-08 06:47 -0700

csiph-web