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

[luigi.papino at gmail.com]

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> 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 [m
> ailto: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/a23fce2e/attachment.html>