Access denied for user 'root
Dear friends, We are using Koha 10.02 on Ubuntu 12.04 LTS. During the installation I used Ubuntu MySQL Security Tweak from this documentation http://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_tarball The anonymous connections were removed. But now I need to connect Koha database with a Mysql -u root -p command. As would be expected mysql has generated an error. ************************************************************************ 'Access denied for user 'root'@'localhost' (using password: YES)' **************************************************************************** ** How can I fix this problem and over again to use a mysql -u root -p command. Thank you for your help! Araik.
The "problem" seems to be that you don't know your root password for MySQL. It can be reset on 12.04 (and most debian-based systems) issuing: $ sudo dpkg-reconfigure mysql-server-5.5 Regards To+ On Fri, Mar 15, 2013 at 8:43 AM, Araik Manukyan <araik@flib.sci.am> wrote:
Dear friends,
We are using Koha 10.02 on Ubuntu 12.04 LTS.
During the installation I used Ubuntu MySQL Security Tweak from this documentation
http://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_tarball
The anonymous connections were removed.
But now I need to connect Koha database with a
Mysql -u root -p command.
As would be expected mysql has generated an error.
************************************************************************
'Access denied for user 'root'@'localhost' (using password: YES)'
**************************************************************************** **
How can I fix this problem and over again to use a mysql -u root -p command.
Thank you for your help!
Araik.
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Greetings,
During the installation I used Ubuntu MySQL Security Tweak from this documentation [URL SNIPPED]
You should be using: http://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages It too has the same section: http://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages#Ubuntu_MySQL_S... The tarball method of installation requires a level of system administration that many first time users do not have. Packages are much easier by comparison.
But now I need to connect Koha database with a Mysql -u root -p command.
$ mysql -u root -p [ I generally put the command on a different line, so it prompts you for the password. Otherwise, it may think 'command' is your password.] If you have forgotten your root password, Tomas has already pointed out how to do that. GPML, Mark Tompsett
participants (3)
-
Araik Manukyan -
Mark Tompsett -
Tomas Cohen Arazi