Re: MySQL access denied for user

[Bill Wohler <wohler@newt.com>]

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