bin/install.php have problems setting up database on ubuntu 18.04 #82
Description
On an Ubuntu 18.04 VM, I have followed instructions at:
https://www.casebox.org/dev/install/
except that I have to replace the user "apache" with "www-data" for ubuntu.
I changed into /var/www/casebox, and run:
sudo php bin/install.php
Mysql refuses access to the database:
vagrant@ubuntu1804:/var/www/casebox$ sudo php bin/install.php
Config file doesnt exist
Specify apache user (default "apache"):
Specify prefix used for database names, solr core and log files (default "cb"):
Specify database configuration:
db host (default "127.0.0.1"):
db port (default "3306"):
db user (default "local"):
db password:
privileged db user (default "root"):
privileged db user's password:
PHP Warning: mysqli::__construct(): (HY000/1698): Access denied for user 'root'@'localhost' in /var/www/casebox/httpsdocs/lib/install_functions.php on line 415
Specify database configuration:
db host (default "127.0.0.1"):
I didn't fiddle with the mysql installation. Also, I verified that the user root does not need a password for mysql login:
vagrant@ubuntu1804:/var/www/casebox/bin$ sudo mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 14
Server version: 5.7.23-0ubuntu0.18.04.1 (Ubuntu)
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
So how can I get the script to work on ubuntu?