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

[HENAR MUÑOZ FRUTOS]

Hi

Yes, you are right. Can you have a look now?
Thanks for your feedback,
Regards,
Henar

De: luigi.papino at gmail.com [mailto:luigi.papino at gmail.com]
Enviado el: jueves, 30 de enero de 2014 15:27
Para: HENAR MUÑOZ FRUTOS
CC: fiware-lab-help at lists.fi-ware.eu; Ivan Paudice; Ottavio Sgrosso
Asunto: Re: [Fiware-lab-help] [Blueprints] mysql authentication

It works well from localhost, but doesn't work from public ip

LOCALHOST:
[root at appetitoomain-mainserver-1 ~]# mysql -u root -pmysql321go
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 16
Server version: 5.1.71-log Source distribution
mysql> quit
Bye

PUBLIC IP: (reamin in waiting status for a lot of time)
nietzsche at nietzsche-Extensa-5635Z:~$ mysql -u root -h 130.206.82.35 -pmysql321go
ERROR 2003 (HY000): Can't connect to MySQL server on '130.206.82.35' (110)

On 30 January 2014 14:54, HENAR MUÑOZ FRUTOS <henar at tid.es<mailto:henar at tid.es>> wrote:
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> [mailto:fiware-lab-help-bounces at lists.fi-ware.eu<mailto:ailto%3Afiware-lab-help-bounces at lists.fi-ware.eu>] En nombre de luigi.papino at gmail.com<mailto:luigi.papino at gmail.com>
Enviado el: jueves, 30 de enero de 2014 10:55
Para: fiware-lab-help at lists.fi-ware.eu<mailto: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


________________________________

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/484af073/attachment.html>