[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

MySQL access denied for user



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


Reply to: