[BlueOnyx:19159] Re: default Password for MySql

[Chris Gebhardt - VIRTBIZ Internet]

On 2/22/2016 11:59 AM, Richard Barker wrote:
> What is the default Password for MySql on 5209R
> I forgot to set

There is not a default, since it has to be set (configured) when you 
complete the initial BlueOnyx configuration.

If you want to find the MySQL password that you configured into 
BlueOnyx, you can look up what's stored in cceclient.

http://www.blueonyx.it/index.php?page=cmu-migrations has instructions 
under item 5, starting with Find out your MySQL "root" password in case 
you have forgotten it by using CCEclient:

/usr/sausalito/bin/cceclient

This will answer with something like this:

100 CSCP/0.80
200 READY

Type the following:

find MySQL

This will answer with something like this:

104 OBJECT 72
201 OK

Note the reported "object ID" - in this case "72". Yours will be 
different. Poll the object ID with the"get" command like this (but 
substitute the reported object ID instead!):

get 72

CCEclient will then fetch the data stored in that object and will 
display it like this:

102 DATA NAMESPACE = ""
102 DATA sql_rootpassword = "the-supersecret-password"
102 DATA CLASSVER = "1.0"
102 DATA sql_host = "localhost"
102 DATA timestamp = "1322165402"
102 DATA CLASS = "MySQL"
102 DATA savechanges = "1322165402"
102 DATA sql_port = "3306"
102 DATA OID = "72"
102 DATA sql_root = "root"
201 OK

Your MySQL "root" password (if it was set through the GUI) will be 
reported in the line beginning with "102 DATA sql_rootpassword".

Note that is whatever was last stored with BlueOnyx.   If you've changed 
it at CLI since then, then this won't help you...  then you'll need to 
perform the manual reset procedure.

-- 
Chris Gebhardt
VIRTBIZ Internet Services
Access, Web Hosting, Colocation, Dedicated
www.virtbiz.com | toll-free (866) 4 VIRTBIZ