[SMS]

simbad · Senior Member Joined: 30 Jun 2011 Posts: 106

The full MySQL error message was : DBI connect failed : Access denied for user 'root'@'localhost' (using password: NO)

i can only user command line / ssh.

Any options how to fix this.

I have reinstall mysql server,...didn t fix this Sad

or how to full remove mysql and start fresh mysql install Smile

gerasimos_h · Posted: Sun Oct 21, 2012 9:25 pm Post subject:

Have change mysql root password using wiki?
http://sms.it-ccs.com/wiki/#LinkTarget_2290

When do you get error message?
If it's on webmin you need to set in webmin, the password for mysql root you create.

Also look at this post for resetting mysql root password
http://sms.it-ccs.com/forum/viewtopic.php?t=52

gerasimos_h

simbad · Senior Member Joined: 30 Jun 2011 Posts: 106

root@xenya:~# mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
root@xenya:~#

root@xenya:~# mysql -u root mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

gerasimos_h · Posted: Sun Oct 21, 2012 11:00 pm Post subject:

Is this a new installation (version?)?
Did you change mysql's root password and if so how?
Have you try to reset it ?
http://sms.it-ccs.com/forum/viewtopic.php?t=52

If you don't have any databases installed backup databases (/var/lib/mysql) and remove and reinstall mysql-data.

gerasimos_h

simbad · Senior Member Joined: 30 Jun 2011 Posts: 106

I have changed by webmin, and i have try it . to remove and fresh istal mz sql and mysql-data. I have the same error Sad

gerasimos_h · Posted: Sun Oct 21, 2012 11:53 pm Post subject:

Have you tried that?
http://sms.it-ccs.com/forum/viewtopic.php?p=3447#3447

Although if you remove (backup first) /var/lib/mysql/mysql and install mysql-data it should revert as fresh install (mysql rot with no password)

Can you post step by step what you did, so I can try to reproduce it, and check if that's an webmin bug, because I can change my password in webmin with no issues.

gerasimos_h

simbad · Senior Member Joined: 30 Jun 2011 Posts: 106

Click this button to start the MySQL database server on your system with the command cd /usr ; (/usr/bin/safe_mysqld || /usr/bin/mysqld_safe) &. This Webmin module cannot administer the database until it is started

simbad · Senior Member Joined: 30 Jun 2011 Posts: 106

I have folow your link, and now is ok! Smile

THANKS!!!

simbad · Senior Member Joined: 30 Jun 2011 Posts: 106

I have try now to install mailwatch (instalation OK! / root + mailwatch db pass).

When i now try to access to http://*/mailwatch with admin/admin i got this error:

Could not connect to database: Access denied for user 'mailwatch'@'localhost' (using password: YES)

gerasimos_h · Posted: Tue Oct 23, 2012 7:49 am Post subject:

The path it's http://yourserver/mailscanner.
Did you get any error during installation of the package...?

Check that your database "password" during installation exist in
/var/www/htdocs/mailscanner/config.php

define('DB_PASS', 'yourpassword');

gerasimos_h