Topic: Help!!! - smerver 7.1.3 - Restore lost root access to mysql

[daley]

I have sudddenly lost root access to mysql on SMEServer 7.1.3 installation. Sad Logging on as root, thus:

[root@ns1 ~]# mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[root@ns1 ~]#

I don't know what I could have done to cause this, appreciate your help.

Thanks in anticipation.

Regards,
Daley

[cactus]

I have sudddenly lost root access to mysql on SMEServer 7.1.3 installation. Sad Logging on as root, thus:

[root@ns1 ~]# mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[root@ns1 ~]#

I don't know what I could have done to cause this, appreciate your help.

Thanks in anticipation.

Regards,
Daley

It seems that you somehow have been tempering with the MySQL root password. You should never do this. See the wiki for resetting the MySQL root password and more information.

[daley]

 cd /var/service/mysqld
 runsvctrl d .
 expand-template /root/.my.cnf
 expand-template /var/service/mysqld/set.password
 /usr/libexec/mysqld --bootstrap --user=mysql --skip-grant-tables < ./set.password
 runsvctrl u .

Thanks for help, i have restored the password....

i was wanted to use the phpmyadmin to set password for one of the database name "roundcule", if i using the contrib file without the database password, how can i do it?

example....

[root@ns1 ]# config show roundcube
roundcube=service
    DbPassword=
    Name=RoundCube IMAP Client
    PublicAccess=global-pw-remote
[root@ns1 ]#

Thanks so much,

Regards,
Daley

[bpivk]

Folow the install procedure as described on www.dungog.net

[daley]

# pico -w db.inc.php

# add password and shorten roundcubemail to roundcube
# note if your password has an @ you may have problems ?
$rcmail_config['db_dsnw'] = 'mysql://roundcube:hpxQLICHl-SNIP-vfpc034S@localhost/roundcube';

DATABASE ERROR: CONNECTION FAILED!

Unable to connect to the database!
Please contact your server-administrator.

Where do i go wrong for the setup?, i can't find the mysql password with 'config show roundcube',

[root@ns1 ]# config show roundcube
roundcube=service
    DbPassword=
    Name=RoundCube IMAP Client
    PublicAccess=global-pw-remote
[root@ns1 ]#

Regards,
Daley[/b]

[bpivk]

Did you folow the procedure as described on dungog?
You have to install 2 (two) contribs.

[daley]

Yes, both files, i got it fixed, this contrib does not required password for the configuration file.

Thanks for help.
Daley