Hi guys! I'm Abdullatef. I'm installing KOHA 3.4.02 following the same instruction on the wiki and I'm stuck at: 7 - Create MySQL Database and grant all privileges to the koha database to the specified user # mysqladmin -uroot -ppassword create kohadata it stated here: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: YES)' Please help. Abdullatef Al-Madinah International University Malaysia Den 02-06-2011 22:50, Lars J. Helbo skrev: .. cause that gave me the hint, where to look. Yes, I had set up MySQL, but the database was called kohadata instead of koha. After creating the database koha using phpmyadmin everything works. If you look here: http://wiki.koha-community.org/wiki/Koha_on_Ubuntu under 7 - Create MySQL Database and grant all privileges to the koha database to the specified user you will see, why I made this mistake. I think this is a general problem in such manuals. For somebody like me, who is not a native English speaker, it is often quiet difficult to realise, which words should be taken literally and which ones should be seen as placeholders for something. -- Venlig hilsen Lars J. Helbo Borgergade 44 DK-8450 Hammel Tlf.: +45 8696 9315 Mobil: +45 6133 9315 www.helbo.org www.frijsendal.dk www.sallnet.dk www.salldata.dk _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- View this message in context: http://koha.1045719.n5.nabble.com/Installation-problem-tp4449146p4611528.htm... Sent from the Koha - Discuss mailing list archive at Nabble.com.

Hi Nigel! Thanks for your guide. Actually, before you reply, I asked a friend of mine on whether the MySQL is ready or not. He give me this command: #myslqd and I got this: 110719 15:41:36 [Warning] Can't create test file /var/lib/mysql/abdullatef-VirtualBox.lower-test 110719 15:41:36 [Warning] Can't create test file /var/lib/mysql/abdullatef-VirtualBox.lower-test mysqld: Can't change dir to '/var/lib/mysql/' (Errcode: 13) 110719 15:41:36 [ERROR] Aborting 110719 15:41:36 [Note] mysqld: Shutdown complete So, I think, the mysql has been shut down. Do I need to On it again? how? Thanks in advance. Abdullatef -- View this message in context: http://koha.1045719.n5.nabble.com/Installation-problem-tp4449146p4611686.htm... Sent from the Koha - Discuss mailing list archive at Nabble.com.

On 19 July 2011 18:27, abdulllatef <ibnsaadiah@gmail.com> wrote:

I tried #mysql mysql

I got this:

abdullatef@abdullatef-VirtualBox:~/koha-latest/koha-3.4.02$ mysql mysql ERROR 1045 (28000): Access denied for user 'abdullatef'@'localhost' (using password: NO)

this means mysql is running, to answer your other question try #mysql mysql -p or #mysql mysql -u root -p and see if you know the root password if you don't, then you might need to search some mysql forums nigel

I got the username & password through this guide: http://mirzmaster.wordpress.com/2009/01/16/mysql-access-denied-for-user-debi... With help from few friends, now, I'm under : 3 - Configure and Start Apache but, I'm stuck again at this point: _______________________________________ Uncomment or Add the Lines: Listen 80 Listen 8080 NameVirtualHost*:80 NameVirtualHost*:8080 If not running named virtual hosts, comment out the NameVirtualHost lines (prepending the # character to the line). Now enable the apache modules this config needs, enable koha's configuration and restart apache. _________________________________________ I run this: sudo gedit /etc/apache2/ports.conf and i got this in the gedit: _____________________________ # If you just change the port or add more ports here, you will likely also # have to change the VirtualHost statement in # /etc/apache2/sites-enabled/000-default # This is also true if you have upgraded from before 2.2.9-3 (i.e. from # Debian etch). See /usr/share/doc/apache2.2-common/NEWS.Debian.gz and # README.Debian.gz NameVirtualHost *:80 Listen 80 <IfModule mod_ssl.c> # If you add NameVirtualHost *:443 here, you will also have to change # the VirtualHost statement in /etc/apache2/sites-available/default-ssl # to <VirtualHost *:443> # Server Name Indication for SSL named virtual hosts is currently not # supported by MSIE on Windows XP. Listen 443 </IfModule> <IfModule mod_gnutls.c> Listen 443 </IfModule> ____________________________________________ Now, how to "Uncomment" -- View this message in context: http://koha.1045719.n5.nabble.com/Installation-problem-tp4449146p4615169.htm... Sent from the Koha - Discuss mailing list archive at Nabble.com.