Default MYSQL Credentials

Questions and answers about how to do stuff
Post Reply
curibe
Posts: 74
Joined: 26 Feb 2014 22:38

Default MYSQL Credentials

Post by curibe »

What are the Default MYSQL credentials that comes with the build?

for some reason i have the wrong credentials in webmin >servers > MySql Database Server. i keep seen this error "he full MySQL error message was : DBI connect failed : Access denied for user 'whadmin'@'localhost' (using password: YES)"

Also for MailWatch i cant log in because i do not have the right credentials in SQL.
I get the same error witch i think it could be related "Could not connect to database: Access denied for user 'mailwatch'@'localhost' (using password: YES)"

Please let me know.
User avatar
shawniverson
Posts: 3644
Joined: 13 Jan 2014 23:30
Location: Indianapolis, Indiana USA
Contact:

Re: Default MYSQL Credentials

Post by shawniverson »

Take a peek in /etc/EFA-Config

:D
curibe
Posts: 74
Joined: 26 Feb 2014 22:38

Re: Default MYSQL Credentials

Post by curibe »

Hmm i tried those long string PW but i still cant log in.

anyway to change the config file and rerun the config?

sorry, im just new at this. ;)
User avatar
shawniverson
Posts: 3644
Joined: 13 Jan 2014 23:30
Location: Indianapolis, Indiana USA
Contact:

Re: Default MYSQL Credentials

Post by shawniverson »

whadmin is not a SQL user in EFA...

This may help

Here are the SQL user accounts:

root and sa-user -- all databases
mailwatch -- mailwatch database only
sqlgrey -- sqlgrey database only
efa -- efa database only
curibe
Posts: 74
Joined: 26 Feb 2014 22:38

Re: Default MYSQL Credentials

Post by curibe »

I just tried using the sa-user with the SAUSERSQLPWD and it does not let me in.
:(

I also tried with root and the mysqlrootpwd
:(
User avatar
shawniverson
Posts: 3644
Joined: 13 Jan 2014 23:30
Location: Indianapolis, Indiana USA
Contact:

Re: Default MYSQL Credentials

Post by shawniverson »

Please post the command you are trying to execute without the password.
curibe
Posts: 74
Joined: 26 Feb 2014 22:38

Re: Default MYSQL Credentials

Post by curibe »

what i did was recreate the appliance. i did not upgrade to latest version of EFA-3.0.0.2. i was able to log into mysql server from webmin. this allowed me to create a user that will allow me to log into mailwatch.

maybe i bombed my first install of EFA :) but the second one works great. or maybe the upgrade had something to do with it. would it? Should i upgrade to EFA-3.0.0.2?

let me know.
User avatar
shawniverson
Posts: 3644
Joined: 13 Jan 2014 23:30
Location: Indianapolis, Indiana USA
Contact:

Re: Default MYSQL Credentials

Post by shawniverson »

curibe wrote:what i did was recreate the appliance. i did not upgrade to latest version of EFA-3.0.0.2. i was able to log into mysql server from webmin. this allowed me to create a user that will allow me to log into mailwatch.
Firstly, EFA-Init should have created a MailWatch user for you. That user would be the non-root user. Did it not create the user?

I would hold of on applying 3.0.0.2. We are close to releasing 3.0.0.3 which includes fixes after 3.0.0.2 was released.
Post Reply