Bill Wohler <woh...@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 <woh...@newt.com> aka <bill.woh...@nasa.gov> > http://www.newt.com/wohler/ > GnuPG ID:610BD9AD -- Bill Wohler <woh...@newt.com> aka <bill.woh...@nasa.gov> http://www.newt.com/wohler/ GnuPG ID:610BD9AD
