Installation corrupted my ySQL Server

[antiheld2000]

I tried to install the software on my local machine. Now my MySQL Server seems to be destroied. The error Message is #1045 - Access denied for user mailto:'root'@'localhost' (using password: YES) What can happen duringthe installation, that this message occurs?
Please help me! I don't know what to do to get my MySQL to work again or to connect to it.
I'm using MAMP on a Mac Pro Mac OS X 10.5...Sent from the phpGroupWare forums @ http://forums.phpGroupWare.org


_______________________________________________
phpGroupWare-users mailing list
phpGroupWare-users@...
http://lists.gnu.org/mailman/listinfo/phpgroupware-users

[Chris Weiss-2]

On Tue, Nov 4, 2008 at 3:39 AM, antiheld2000 wrote:
>
>
> I tried to install the software on my local machine. Now my MySQL Server seems to be destroied. The error Message is #1045 - Access denied for user mailto:'root'@'localhost' (using password: YES) What can happen duringthe installation, that this message occurs?
> Please help me! I don't know what to do to get my MySQL to work again or to connect to it.

either you mysql root user has no password, or you are giving it the
wrong password.
it's best to have phpgw use it's own mysql user, the install process
will even create it for you.


_______________________________________________
phpGroupWare-users mailing list
phpGroupWare-users@...
http://lists.gnu.org/mailman/listinfo/phpgroupware-users

[antiheld2000]

any suggestions how to recreate my old password status? i can't conntect with empty pass and i can't connect with old pass. how to save my old data? is everything lost?Sent from the phpGroupWare forums @ http://forums.phpGroupWare.org


_______________________________________________
phpGroupWare-users mailing list
phpGroupWare-users@...
http://lists.gnu.org/mailman/listinfo/phpgroupware-users

[Giorgio Pioda]

Hi,

backup your database directories and files that are probably located in /var/lib/mysql/

Then reinstall mysql cleanly and copy the backed up files at the onw place. Pay attention NOT to copy the /var/lib/mysql/mysql directory since mysql stores the users information inside mysql self and restoring this last directory will regenerate your actual problem.

After this you will be able to set up users and permissions logging in as mysql/root user

cheers

gfwpSent from the phpGroupWare forums @ http://forums.phpGroupWare.org


_______________________________________________
phpGroupWare-users mailing list
phpGroupWare-users@...
http://lists.gnu.org/mailman/listinfo/phpgroupware-users

[antiheld2000]

thank you very much. it worked. so, is there a way to install without creating a new mysql user?Sent from the phpGroupWare forums @ http://forums.phpGroupWare.org


_______________________________________________
phpGroupWare-users mailing list
phpGroupWare-users@...
http://lists.gnu.org/mailman/listinfo/phpgroupware-users

[Chris Weiss-2]

On Wed, Nov 5, 2008 at 7:34 AM, antiheld2000 <hp@...> wrote:
>
>
> thank you very much. it worked. so, is there a way to install without creating a new mysql user?

sure, just pay attention to how you set the root password.

it is HIGHLY recommended to not use mysql root user with any php
application though.  in the long run you can save a lot of time by
following best practices.


_______________________________________________
phpGroupWare-users mailing list
phpGroupWare-users@...
http://lists.gnu.org/mailman/listinfo/phpgroupware-users