Log inUsernamePassword
Log me on automatically each visit    
Register
Register
Log in to check your private messages
Log in to check your private messages
SMS Forum Index » Installation Support

Post new topic   Reply to topic
mysl root password need to change
View previous topic :: View next topic  
Author Message
simbad
Senior Member


Joined: 30 Jun 2011
Posts: 106

PostPosted: Sun Oct 21, 2012 8:59 pm    Post subject: mysl root password need to change Reply with quote

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
Back to top
View user's profile Send private message
gerasimos_h
Site Admin


Joined: 09 Aug 2007
Posts: 1738
Location: Greece

PostPosted: Sun Oct 21, 2012 9:25 pm    Post subject: Reply with quote

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

_________________
Superb! Mini Server Project Manager
http://sms.it-ccs.com
Back to top
View user's profile Send private message Visit poster's website
simbad
Senior Member


Joined: 30 Jun 2011
Posts: 106

PostPosted: Sun Oct 21, 2012 10:46 pm    Post subject: Reply with quote

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)
Back to top
View user's profile Send private message
gerasimos_h
Site Admin


Joined: 09 Aug 2007
Posts: 1738
Location: Greece

PostPosted: Sun Oct 21, 2012 11:00 pm    Post subject: Reply with quote

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

_________________
Superb! Mini Server Project Manager
http://sms.it-ccs.com
Back to top
View user's profile Send private message Visit poster's website
simbad
Senior Member


Joined: 30 Jun 2011
Posts: 106

PostPosted: Sun Oct 21, 2012 11:38 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
gerasimos_h
Site Admin


Joined: 09 Aug 2007
Posts: 1738
Location: Greece

PostPosted: Sun Oct 21, 2012 11:53 pm    Post subject: Reply with quote

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

_________________
Superb! Mini Server Project Manager
http://sms.it-ccs.com
Back to top
View user's profile Send private message Visit poster's website
simbad
Senior Member


Joined: 30 Jun 2011
Posts: 106

PostPosted: Mon Oct 22, 2012 7:43 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
simbad
Senior Member


Joined: 30 Jun 2011
Posts: 106

PostPosted: Mon Oct 22, 2012 7:45 pm    Post subject: Reply with quote

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

THANKS!!!
Back to top
View user's profile Send private message
simbad
Senior Member


Joined: 30 Jun 2011
Posts: 106

PostPosted: Tue Oct 23, 2012 7:35 am    Post subject: Reply with quote

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)
Back to top
View user's profile Send private message
gerasimos_h
Site Admin


Joined: 09 Aug 2007
Posts: 1738
Location: Greece

PostPosted: Tue Oct 23, 2012 7:49 am    Post subject: Reply with quote

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

_________________
Superb! Mini Server Project Manager
http://sms.it-ccs.com
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    SMS Forum Index » Installation Support All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum

SMS - Superb! Mini Server Project © 2016
Powered by phpBB © 2001, 2002 phpBB Group
iCGstation v1.0 Template By Ray © 2003, 2004 iOptional