MySQL access denied for user

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

Show all headers | View raw

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.

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

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

Thread

MySQL access denied for user Bill Wohler <wohler@newt.com> - 2016-08-15 07:20 +0200
  Re: MySQL access denied for user Liam O'Toole <liam.p.otoole@gmail.com> - 2016-08-15 12:10 +0200
    Re: MySQL access denied for user limpia <limpia@openmailbox.org> - 2016-08-15 16:00 +0200

csiph-web