Koozali.org: home of the SME Server
Legacy Forums => General Discussion (Legacy) => Topic started by: andalon on May 01, 2002, 07:46:35 PM
-
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
-
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
-
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.
-
maybe I am only too stupid to understand, but your howto did not solve the problem because I could not reset the password
-
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
-
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.
-
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.
-
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.
-
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?
-
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 ...
-
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!!!!!!!!!!
-
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