Page MenuHomePhabricator

README, scripts don't set MySQL user up properly
Closed, ResolvedPublic

Description

Author: sumanah

Description:
If you follow the README*, it tells you to try to run some SQL scripts from the bash command line; it should say something like "sudo mysql -p < scripts/00_create_wikimetrics_db .

If you try to manually do what the scripts in the scripts/ directory aim to do, the "wikimetrics" user does not get created properly -- it needs to exist and have a password set.

(Dan and I were testing this out today - he might have better troubleshooting/records in his .bash_history, etc.)


Version: unspecified
Severity: normal
OS: Linux

Details

Reference
bz59843

Event Timeline

bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 2:31 AM
bzimport set Reference to bz59843.

sumanah wrote:

Dan, I think you wanted me to assign this to you?

sumanah wrote:

https://gerrit.wikimedia.org/r/#/c/106546/ addresses part of this bug, but when I do

$ sudo mysql < scripts/00_create_wikimetrics_db

I get

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

Change 106775 had a related patch set uploaded by Milimetric:
For Bug 59843

https://gerrit.wikimedia.org/r/106775

Please re-open if it's not solved with the new change.