[Fiware-lab-help] [Blueprints] mysql authentication

[HENAR MUÑOZ FRUTOS]

Hi again
The mysql installed and configured with recipes have the root user with the password mysql321go. You cannot access from localhost. It is configured to be accessible from outside. Can you try to do the following?
mysql -u root -h PUBLIC_IP -p
(where the password is mysql321go).
Please tell me if this works for you.
Thanks for your feedback,
Regards,
Henar

De: fiware-lab-help-bounces at lists.fi-ware.eu [mailto:fiware-lab-help-bounces at lists.fi-ware.eu] En nombre de luigi.papino at gmail.com
Enviado el: jueves, 30 de enero de 2014 10:55
Para: fiware-lab-help at lists.fi-ware.eu
CC: Ivan Paudice; Ottavio Sgrosso
Asunto: [Fiware-lab-help] [Blueprints] mysql authentication

Hi, sorry to trouble again and take advantage of your patience. But I have very little time to finish the project for the FI-WARE 800k Challenge and I lack some knowledge.

I launched an instance of my template blueprints, which also contains mysql. Trying to access the mysql console, or set the root password, I get the following error:

[root at appetitoomain-mainserver-1 ~]# mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
[root at appetitoomain-mainserver-1 ~]# mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)


What should be the proper way to authenticate to mysql, perhaps through phpmyadmin, in the default installation provided in blueprints?

Really, really thanks!
Luigi

________________________________

Este mensaje se dirige exclusivamente a su destinatario. Puede consultar nuestra política de envío y recepción de correo electrónico en el enlace situado más abajo.
This message is intended exclusively for its addressee. We only send and receive email on the basis of the terms set out at:
http://www.tid.es/ES/PAGINAS/disclaimer.aspx
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.fiware.org/private/fiware-lab-help/attachments/20140130/cf53fb22/attachment.html>