[BlueOnyx:20797] Re: FW: MySQL Error

[Chris Gebhardt - VIRTBIZ Internet]

Hi Sean,

On 3/7/2017 10:56 AM, abuse at sithost.ca wrote:
> Haha' sounds good.
> So am I resetting THEIR MySQL password or the root accounts?
>
> Also where would I do this in the GUI?
> I know how to do this if I can access phpmyadmin (but like I said, this
> won't load for me)

If phpMyAdmin won't load, then this could be an issue with the root 
password in MySQL / MariaDB.

When you go to Server Management > Network Services > MariaDB, look 
under MariaDB Connection Status.   If it says "MariaDB connection 
possible" then that's fine.   I would expect phpMyAdmin to load.

> I see the "Change Password" option under Server Management -> Network
> Services -> MariaDB
> But that's asking for a "current password" we had this server setup for us,
> so I sadly do not know this password :( haha'

Eeek.  You may want to check in with whoever did the setup in that case. 
   Anytime we deliver dedicated BlueOnyx system, the customer always has 
access to that information.

You can check CCE to see what BlueOnyx knows/thinks the current password 
is.   Do that by running /usr/sausalito/bin/cceclient

After the "200 READY" prompt, type "find MySQL" (without quotes) and 
then Enter.

You will get a 104 response with OBJECT and then a number.  That number 
is the MySQL entry in BlueOnyx's CCE.  Let's say the number is 35. 
You'd type "get 35" then Enter.

That will produce various information about MySQL according to CCE, 
including the root password from this line:
102 DATA sql_rootpassword =

CTRL-C will quite CCEclient.

Or, if you've got hosting on this from a service provider, they should 
be able to help you out with it as well in the event this is more 
involved than you're comfortable with.

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