<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=windows-1252" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.19222">
<STYLE></STYLE>
</HEAD>
<BODY
style="WORD-WRAP: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space"
bgColor=#ffffff>
<DIV><FONT size=2 face=Arial>William</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>I am not an expert on the MySql and BlueOnyx but I
am (pretty) sure there is no connection between the MySql root password and the
password you set for root in the Gui for BO. The reason I feel confident in this
is on one of the test boxes I use PhpMyAdmin always yells at me that I havent
set the root password yet and it is set in the Gui for root.</FONT></DIV>
<DIV> </DIV>
<DIV>Bill Hicks</DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px">
<DIV><FONT size=2 face=Arial></FONT><BR></DIV>Hello everyone –
<DIV>We may have dug ourselves a hole here. In trying to restore a vsite
from one server to another, the mysql database for the site's drupal instance
didn't get set up. We figured 'no problem' and started to add it from
the command line since the mysql dump file exceeded the 8MB limit of
phpMyAdmin. At that point we realized that the mysql root password was
unknown. We tried everything we might have set it to. We tried
setting it in the BlueOnyx GUI without success. So we stopped mysqld,
restarted mysql in safe mode, set a new root user password, stopped mysqld and
restarted. So far so good. We can now log into mysql as
root.</DIV>
<DIV><BR></DIV>
<DIV>The trouble is, phpMyAdmin now will not connect and stays in a perpetual
loop connecting and transferring data. We assume the password the GUI is
using for the root user is wrong.</DIV>
<DIV><BR></DIV>
<DIV>Using the new root password in the B;ueOnyx GUI "password change" page we
changed the password for user root and then changed it back again to what we
want it to be. Using /usr/sausalito/bin/cceclient when logged in as
root, we see the correct password in the MySQL object. Running the
/usr/sausalito/bin/cceclient while logged in as admin, there is no MySQL
password.</DIV>
<DIV><BR></DIV>
<DIV>Can anyone suggest what we may have broken? If this is a
credentials issue, where is the password set that the GUI uses to connect to
MySQL?</DIV>
<DIV><BR></DIV>
<DIV>Thanks in advance for any tips.</DIV>
<DIV><BR>
<DIV apple-content-edited="true"><SPAN
style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px"
class=Apple-style-span>
<DIV>William Thackrey</DIV>
<DIV><A href="mailto:wethackrey@gmail.com">wethackrey@gmail.com</A></DIV>
<DIV><BR></DIV></SPAN><BR class=Apple-interchange-newline></DIV><BR></DIV>
<P>
<HR>
<P></P>_______________________________________________<BR>Blueonyx mailing
list<BR>Blueonyx@mail.blueonyx.it<BR>http://mail.blueonyx.it/mailman/listinfo/blueonyx<BR></BLOCKQUOTE></BODY></HTML>