question Re: problem connection to Httpp://hadoop:3306 in Support Questions

problem connection to Httpp://hadoop:3306

krol — Thu, 15 Mar 2018 22:26:22 GMT

I am trying to connect to this url :http://hadoop:3306 but its not working, can someone explain to me.

Re: problem connection to Httpp://hadoop:3306

Shelton — Thu, 15 Mar 2018 22:32:27 GMT

What service are you trying to connect to? That looks the mysql database port ! Incase you wanted the Ambari port is

http://ambari-server:8080

Where ambari-server is the FQDN of the host where Ambari server

Please clarify.

Re: problem connection to Httpp://hadoop:3306

krol — Thu, 15 Mar 2018 22:36:16 GMT

@Geoffrey Shelton Okot

yes the ambari port is 8080, I want to connect to mysql service.

Re: problem connection to Httpp://hadoop:3306

RahulSoni — Fri, 16 Mar 2018 00:47:17 GMT

When you say you want to connect to mysql service, do you mean you want to login to MySQL shell? Or you are trying to connect MySQL over http?

Re: problem connection to Httpp://hadoop:3306

jsensharma — Fri, 16 Mar 2018 03:45:22 GMT

@Aymen Rahal

The default Mysql Port 3306 is a TCP/IP port (non http). So you can not connect to it via Http. If you want to remotely connect to MySQL DB and want to run some queries then youi will need to install "mysql-clients" (Or use some third party tools like DBVisualizer / JDBC code ..etc) on your local machine and then using the following format you will be able to connect to it.

# mysql --host=remote.example.com --port=3306 -u root -p

For more details on this please refer to MySQL standard documentation: https://dev.mysql.com/doc/refman/5.6/en/connecting.html

Re: problem connection to Httpp://hadoop:3306

krol — Fri, 16 Mar 2018 04:08:43 GMT

# mysql --host=hadoop --port=3306 -u admin -p Enter password: ERROR 2003 (HY000): Can't connect to MySQL server on 'hadoop' (111)

Re: problem connection to Httpp://hadoop:3306

Shelton — Fri, 16 Mar 2018 04:12:28 GMT

@Aymen Rahal

To connect to the CLI If you have the root password then from the Mysql host you do, notice the -p is attached no spaces assuming the password is welcome1

# mysql -u root -pwelcome1

If you don't have the mysql root password then you can change it as below, in the below example I want my new password to be 'welcome1'

# mysql -u root UPDATE mysql.user SET Password=PASSWORD('welcome1') WHERE User='root'; flush privileges;

Otherwise, you have the below clients to choose from

MySQL Workbench (Mac, Windows, Linux), Free, open-source
phpMyAdmin (web app), Free, open-source
Toad for MySQL (Windows), Free
MySQL-Front (Windows), Free, open-source
Neor Profile SQL (Mac, Windows, Linux), Free

You should implement the secure Mysql/mariaDB installation see link

Re: problem connection to Httpp://hadoop:3306

Shelton — Fri, 16 Mar 2018 04:38:12 GMT

@Aymen Rahal

Check my update !!!!