<HTML>
<HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META content="OPENWEBMAIL" name=GENERATOR>
</HEAD>
<BODY bgColor=#ffffff>
When you first load the box - there is no MySQL root user password. In the GUI - leave that "Current Password" block blank and put in the new password you want for the root MySQL user.
<br />
<br />If that doesn't work - you might have accidentally put in a password and now don't know what it is. In that case, change it from the command line. As root - use the commands
<br />
<br />service mysqld stop
<br />
<br />/usr/bin/mysqld_safe --datadir="$datadir" --socket="$socketfile" --log-error="$errlogfile" --pid-file="$mypidfile" –skip-grant-tables >/dev/null 2>&1 &
<br />
<br />Make sure that command is all on one line - or it won't work.
<br />
<br />mysqladmin -u root password ‘mynewpassword’
<br />
<br />Be sure you use single quotes around that new password like 'mynewpassword'. Then simply restart the MySQL server with "service mysqld restart".
<br />
<br />Test to be sure you can get in with the new password by accessing the MySQL client from the command line with "mysql -u root -p". The client will prompt you for the root user's password. If you successfully get in to the MySQL prompt like <span style="font-style: italic;">mysql></span> -- you were successful. Get out using the command "exit" and you've got a new MySQL root user password.
<br />
<br />Now go into the GUI and attempt to change the password. Use that password as the "Current Password", and put in a new password in the two blanks.
<br />
<br />And you're done!
<br />
<br />Good luck.
<br />
<br />
<br />
<br />
<br />Chuck
<br />
<br />
<br /><font size="2"><b>---------- Original Message
-----------</b>
<br />
From: Richard Barker <rc@probass.com>
<br />
To: "'BlueOnyx General Mailing List'" <blueonyx@blueonyx.it>
<br />
Sent: Thu, 17 Mar 2011 21:21:05 -0400
<br />
Subject: [BlueOnyx:06740] Mysql
<br />
<br />> I did a new install from the latest iso and all went great but I am
<br />>
unable to change the mysql password,
<br />>
I did it multiple times and from the cli still uses no password.
<br />>
<br />>
Does anyone have any ideas what might be the issue?
<br />>
<br />>
Thanks in advance.
<br />>
RC
<br />>
<br />>
_______________________________________________
<br />>
Blueonyx mailing list
<br />>
Blueonyx@blueonyx.it
<br />>
<a target="_blank" href="http://www.blueonyx.it/mailman/listinfo/blueonyx">http://www.blueonyx.it/mailman/listinfo/blueonyx</a>
<br /><b>------- End of Original Message
-------</b>
<br />
</font>
</BODY>
</HTML>