Topic: Mysql database/password problem

[andalon]

Hi everyone,

as I am a total beginner using Linux and SME Server I think this would be a easy one for all of you.

I played with mysql on my SME Server and created a database because I was trying to install a CME software. I do not know what I exactly did, but it seems to my that I changed my mysql password. Now several apps I installed come up with a error like this one:

Access denied for user: 'root@localhost' (Using password: YES)

This in special is the error the acid frontend I installed came up with.

Has anyone of you a clue how to solve the problem and get my apps up and running again?

Thank you all for your help.

Cheers

[Lukas Dettwiler]

Hi
I have absolutly the same problem; only on e-smith (5.1.2), my php-scripts with mysql-db will not run (ERROR: Access denied for user: 'root@localhost' (Using password: YES)).Thank you all for your help too.
Lukas

[Dan Brown]

Sounds like you're using the wrong password (and for that matter, the wrong user as well; shouldn't be using root if you can avoid it).  Take a look at http://www.familybrown.org/howtos/mysql-password-howto.html.

[andalon]

maybe I am only too stupid to understand, but your howto did not solve the problem because I could not reset the password

[Lukas Dettwiler]

Hi
It seems that there is always a password needed; so add in your scripts e.g. "$db = mysql_connect("localhost", "msql","12345");" instead of only user without password.
Cheersandalon wrote:
>
> Hi everyone,
>
> as I am a total beginner using Linux and SME Server I think
> this would be a easy one for all of you.
>
> I played with mysql on my SME Server and created a database
> because I was trying to install a CME software. I do not know
> what I exactly did, but it seems to my that I changed my
> mysql password. Now several apps I installed come up with a
> error like this one:
>
> Access denied for user: 'root@localhost' (Using password: YES)
>
> This in special is the error the acid frontend I installed
> came up with.
>
> Has anyone of you a clue how to solve the problem and get my
> apps up and running again?
>
> Thank you all for your help.
>
> Cheers

[andalon]

The problem is that I do not know how to change my password, I do not know to what it is currently set. If I try to change it with mysqladmin there is always the same error as mentioned above when I try to use acid.

[Salah]

alt f2 to console as root and
mysqladmin -u root passwrd "newpassword"andalon wrote:
>
> The problem is that I do not know how to change my password,
> I do not know to what it is currently set. If I try to change
> it with mysqladmin there is always the same error as
> mentioned above when I try to use acid.

[andalon]

Thanks for your reply but I would not post if that had worked for me. Even this command and the way over the customized startup and flushed privileges won´t work.

I am looking for a way to get this back to normal, without reinstalling the SME.

[Luk Vermeylen]

have the same problem here
user root@localhost is rejected (acces denied)
also other users, even when changed to user@domain.com
can't use mysql (acces denied)
what to do now (think i must have changed it when installing phpgroupware)
Is this also the reason that i keep having problems with smtpffwd?

[Chrsim]

Hi all,
I begged on my knees the developpers not to have us type this 64+ chars password in our scripts, and then discovered I was the fool one. When you first install the SME Sever, just connect from a console and create a user with grant all accesses and a password you can remember(hard one tho, because of the grant all). You will then use that new user to create 'applications' users without drop accesses ...

This was taken as a rule from a post from Charly Brady
saying every application should have its own user.

To do the above creation, follow this thead :
http://forums.contribs.org/index.php?topic=3248.msg10953#msg10953

Unfortunately, I could not find a solution without re-installing. Maybe some linux/mysql/sme server pros will be able to ...

[Alphete]

Hi !!!
I found a way of "restoring" MySQL root password if you messed up (as I did) with it and assigned it another password, wich I cannot remember know (the thing is I changed by mistake the MySQL root password, and I don't know when)

The point is that in MySQL.com, there is a paper that has all the procedure to "restore" root password.

http://www.mysql.com/doc/R/e/Resetting_permissions.html

It's quite a simple procedure, but the problem I'm having is this one.
The instructions say you must kill the mysqsl process.
once you do (with Kill ) you must restart the mysql daemon
with some parameters...
But I cannot find a way to restore it since I enter mysqld and I get a "command not found" error.....

My question is HOW DO I RESTAR MANUALLY the MYSQLD?????
If anyone knows how to do this, will save me from reinstalling SME....
Thanks a lot dudes!!!!!!!!!!

[Tony Bennett]

Hi

According to what I have read you enter:

safe_mysqld -Sg &

my problem is that this just hangs.

I think I've totally messed up mysql and must reinstall

Post how you get/got on

Tony