<div dir="ltr"><div>Dear Simon,<br><br></div>It seems as though it can't authenticate with your database. See this link <a href="http://creskolab.uoregon.edu/stacks/manual/#install">http://creskolab.uoregon.edu/stacks/manual/#install</a> specifically "Section 2.3 Edit the MySQL configuration file" that details setting up MySQL users. Use <span style="font-family:monospace,monospace">mysql -u root </span>to login to the MySQL shell and add new users. You should then edit <span class=""><span style="font-family:monospace,monospace">/usr/local/share/stacks/sql/mysql.cnf </span>to include the appropriate user and password for connection.</span> It's not a good idea to use root for stacks to connect, so you should create an additional stacks user in MySQL.<br><br>Cheers,<span class=""><br><br>Steve<br></span><br><div><div><div class="gmail_extra"><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
Message: 1<br>
Date: Fri, 6 Feb 2015 19:38:56 +0000<br>
From: Simon Wagstaff <<a href="mailto:Simon.Wagstaff@lstmed.ac.uk" target="_blank">Simon.Wagstaff@lstmed.ac.uk</a>><br>
To: Bio-Linux help and discussion <<a href="mailto:bio-linux@nebclists.nerc.ac.uk" target="_blank">bio-linux@nebclists.nerc.ac.uk</a>><br>
Subject: Re: [Bio-Linux] Stacks RAD-seq software on Bio-Linux<br>
Message-ID: <<a href="mailto:3ED46ED7-9B83-43C0-8C7A-1D2D5D578329@lstmed.ac.uk" target="_blank">3ED46ED7-9B83-43C0-8C7A-1D2D5D578329@lstmed.ac.uk</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
Hi Tim,<br>
Thanks again for doing this. I?ve installed stacks web but got some errors (below) when attempting to create the database. I?m not familiar with how it works so not sure if this is a problem?<br>
<br>
Thanks,<br>
<br>
Simon<br>
<br>
<br>
simonw@PowerEdge-R820[simonw] sudo stacks-setup-database gweedall [ 7:26PM]<br>
ERROR 1045 (28000): Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)<br>
Making database gweedall_radtags for gweedall<br>
ERROR 1045 (28000): Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)<br>
Aborting.<br>
simonw@PowerEdge-R820[simonw] [ 7:27PM]<br>
<br>
<br>
_________________________________<br>
<br>
Simon Wagstaff<br>
Tel: <a href="tel:%2B44-%280%29151-705-3164" value="+441517053164" target="_blank">+44-(0)151-705-3164</a><br>
Fax: <a href="tel:%2B44-%280%29151-705-3371" value="+441517053371" target="_blank">+44-(0)151-705-3371</a><br>
email: <a href="mailto:simon.wagstaff@lstmed.ac.uk" target="_blank">simon.wagstaff@lstmed.ac.uk</a><mailto:<a href="mailto:simon.wagstaff@lstmed.ac.uk" target="_blank">simon.wagstaff@lstmed.ac.uk</a>><br>
</blockquote></div><br><br clear="all"><br>-- <br><div><div dir="ltr"><a href="http://about.me/gawbul" style="margin:0px;padding:0px;border:0px none;outline:0px none;font-size:14px;vertical-align:baseline;color:rgb(43,130,173);text-decoration:none;line-height:18px" target="_blank"><font face="tahoma, sans-serif"></font><table style="margin:0px;padding:0px;border:0px none;outline:0px none;font-style:inherit;vertical-align:baseline;border-spacing:0px" border="0" cellpadding="0" cellspacing="0"><tbody style="margin:0px;padding:0px;border:0px none;outline:0px none;font-style:inherit;vertical-align:baseline"><tr style="margin:0px;padding:0px;border:0px none;outline:0px none;font-style:inherit;vertical-align:baseline"><td style="padding:0px;border:0px none;outline:0px none;font-style:inherit;font-size:0px;vertical-align:baseline;height:30px"> </td></tr><tr style="margin:0px;padding:0px;border:0px none;outline:0px none;font-style:inherit;vertical-align:baseline"><td style="padding:0px;border:0px none;outline:0px none;font-style:inherit;vertical-align:top;line-height:1" align="left" valign="top"><div style="margin:0px;padding:0px;border:0px none;outline:0px none;font-weight:bold;font-style:inherit;font-size:18px;vertical-align:baseline;line-height:1;color:rgb(51,51,51)">Steve Moss</div><div style="margin:3px 0px 0px;padding:0px;border:0px none;outline:0px none;font-style:inherit;font-size:12px;vertical-align:baseline">about.me/gawbul</div></td></tr><tr style="margin:0px;padding:0px;border:0px none;outline:0px none;font-style:inherit;vertical-align:baseline"><td style="padding:8px 0px 0px;border:0px none;outline:0px none;font-style:inherit;vertical-align:top;line-height:1" align="left" valign="top"><div style="margin:0px;padding:0px;border:0px none;outline:0px none;font-style:inherit;vertical-align:baseline;text-align:right;background-color:rgb(197,208,224);min-height:4px"><img src="http://d13pix9kaak6wt.cloudfront.net/signature/colorbar.png" alt="Steve Moss on about.me" style="margin: 0px; padding: 0px; border: 0px none; outline: 0px none; font-style: inherit; vertical-align: baseline; float: right; display: block;" height="4" width="88"></div></td></tr><tr style="margin:0px;padding:0px;border:0px none;outline:0px none;font-style:inherit;vertical-align:baseline"><td style="padding:0px;border:0px none;outline:0px none;font-style:inherit;font-size:0px;vertical-align:baseline;height:20px"> </td></tr></tbody></table></a></div></div>
</div></div></div></div>