[BlueOnyx:19161] Re: default Password for MySql

[Michael Stauber]

Hi RC,

> Ok got is but where I do mysqlshow -ppassword I still get
> mysqlshow: Access denied for user 'root'@'localhost' (using password: YES)
> I did a service mysqld restart and aservice mysqld stop and service
> mysqld start
> still no love

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".

-- 
With best regards

Michael Stauber