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.
Default MYSQL Credentials
- shawniverson
- Posts: 3644
- Joined: 13 Jan 2014 23:30
- Location: Indianapolis, Indiana USA
- Contact:
Re: Default MYSQL Credentials
Take a peek in /etc/EFA-Config
Re: Default MYSQL Credentials
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.
anyway to change the config file and rerun the config?
sorry, im just new at this.
- shawniverson
- Posts: 3644
- Joined: 13 Jan 2014 23:30
- Location: Indianapolis, Indiana USA
- Contact:
Re: Default MYSQL Credentials
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
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
Re: Default MYSQL Credentials
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
I also tried with root and the mysqlrootpwd
- shawniverson
- Posts: 3644
- Joined: 13 Jan 2014 23:30
- Location: Indianapolis, Indiana USA
- Contact:
Re: Default MYSQL Credentials
Please post the command you are trying to execute without the password.
Re: Default MYSQL Credentials
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.
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.
- shawniverson
- Posts: 3644
- Joined: 13 Jan 2014 23:30
- Location: Indianapolis, Indiana USA
- Contact:
Re: Default MYSQL Credentials
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?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.
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.