Re: MySQL access denied for user

From	Bill Wohler <wohler@newt.com>
Newsgroups	linux.debian.user
Subject	Re: MySQL access denied for user
Date	2016-08-15 07:20 +0200
Message-ID	<s6itz-1kI-1@gated-at.bofh.it> (permalink)
References	<s6itz-1kI-3@gated-at.bofh.it>
Organization	Newt Software

Show all headers | View raw

Bill Wohler <wohler@newt.com> wrote:

> I'm getting the following:
> 
>     $ mysql -h localhost -u user
>     Enter password: 
>     ERROR 1045 (28000): Access denied for user 'user'@'localhost' (using password: YES)
> 
> This user was created with a fresh installation of mysql as (mysql) root
> with the following:
> 
> mysql> create user 'user'@'localhost' identified by 'password';
> Query OK, 0 rows affected (0.00 sec)
> mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES ON database.* TO 'user'@'localhost' IDENTIFIED BY 'password' with grant option;
> Query OK, 0 rows affected (0.00 sec)
> 
> I'm trying to create a database user for Drupal, but am not having any
> luck. Help for a MySQL newb is very much appreciated.

I should point out that I've installed Drupal 8 from drupal.org since
that isn't available to jessie (to my knowledge). I'd much prefer to say
aptitude install drupal8 and get on with my web site rather than fight
battles with mysql for literally days.

> This is on jessie with MySQL 5.5.
> 
> -- 
> Bill Wohler <wohler@newt.com> aka <Bill.Wohler@nasa.gov>
> http://www.newt.com/wohler/
> GnuPG ID:610BD9AD

-- 
Bill Wohler <wohler@newt.com> aka <Bill.Wohler@nasa.gov>
http://www.newt.com/wohler/
GnuPG ID:610BD9AD

Back to linux.debian.user | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

Re: MySQL access denied for user Bill Wohler <wohler@newt.com> - 2016-08-15 07:20 +0200
  Re: MySQL access denied for user Joe <joe@jretrading.com> - 2016-08-15 09:30 +0200
  Re: MySQL access denied for user Florian Pelgrim <florian.pelgrim@craneworks.de> - 2016-08-15 16:20 +0200

csiph-web