root@ubuntucmbigdata1:~# mysql -uhive -hubuntucmbigdata1 -phive_password ERROR 2003 (HY000): Can't connect to MySQL server on 'ubuntucmbigdata1' (111) root@ubuntucmbigdata1:~# mysql -uhive -hlocalhost -phive_password Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 58 Server version: 5.5.55-0ubuntu0.14.04.1 (Ubuntu) Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> exit; Bye
解决办法
若是centos系统，则是可以直接
[root@cmbigdata1 ~]# yum install mysql-connector-java Is this ok [y/N]: y
就好了。
但是，在ubuntu系统里，
root@ubuntucmbigdata1:/home/bigdata# apt-get install libmysql-java
则会失败。
解决办法1
root@ubuntucmbigdata1:~# sudo /etc/init.d/mysql start
查看你的mysql服务启动没。
解决办法2
root@ubuntucmbigdata1:/usr/share/java# pwd /usr/share/java root@ubuntucmbigdata1:/usr/share/java# ls gettext.jar java_defaults.mk java_uno.jar juh-4.2.8.jar juh.jar jurt-4.2.8.jar jurt.jar libintl.jar mysql-connector-java-5.1.28.jar mysql-connector-java.jar mysql.jar ridl-4.2.8.jar ridl.jar unoloader.jar root@ubuntucmbigdata1:/usr/share/java# sudo cp /usr/share/java/mysql-connector-java-5.1.28.jar /var/lib/oozie root@ubuntucmbigdata1:/usr/share/java# cd /var/lib//oozie/ root@ubuntucmbigdata1:/var/lib/oozie# ls examples.desktop mysql-connector-java-5.1.28.jar root@ubuntucmbigdata1:/var/lib/oozie#
sudo cp /usr/share/java/mysql-connector-java-5.1.28.jar /var/lib/oozie
bigdata@ubuntucmbigdata1:/opt/cloudera/parcels/CDH-5.6.0-1.cdh5.6.0.p0.45/lib$ pwd
/opt/cloudera/parcels/CDH-5.6.0-1.cdh5.6.0.p0.45/lib
bigdata@ubuntucmbigdata1:/opt/cloudera/parcels/CDH-5.6.0-1.cdh5.6.0.p0.45/lib$ ls
avro debug hadoop-hdfs hadoop-yarn hive-hcatalog kite libImpalaUdf-retail.a libzookeeper_mt.so.2 libzookeeper_st.so mahout search sqoop zookeeper-native
bigtop-tomcat flume-ng hadoop-httpfs hbase hue libhdfs.so libzookeeper_mt.a libzookeeper_mt.so.2.0.0 libzookeeper_st.so.2 oozie sentry sqoop2
bigtop-utils hadoop hadoop-kms hbase-solr impala libhdfs.so.0.0.0 libzookeeper_mt.la libzookeeper_st.a libzookeeper_st.so.2.0.0 parquet solr whirr
crunch hadoop-0.20-mapreduce hadoop-mapreduce hive impala-shell libImpalaUdf-debug.a libzookeeper_mt.so libzookeeper_st.la llama pig spark zookeeper
bigdata@ubuntucmbigdata1:/opt/cloudera/parcels/CDH-5.6.0-1.cdh5.6.0.p0.45/lib$ cd hive
bigdata@ubuntucmbigdata1:/opt/cloudera/parcels/CDH-5.6.0-1.cdh5.6.0.p0.45/lib/hive$ ls
bin cloudera conf lib LICENSE NOTICE scripts sentry
bigdata@ubuntucmbigdata1:/opt/cloudera/parcels/CDH-5.6.0-1.cdh5.6.0.p0.45/lib/hive$ cd lib/
bigdata@ubuntucmbigdata1:/opt/cloudera/parcels/CDH-5.6.0-1.cdh5.6.0.p0.45/lib/hive/lib$ ls
accumulo-core-1.6.0.jar commons-compress-1.4.1.jar hbase-client.jar hive-jdbc-1.1.0-cdh5.6.0.jar jackson-databind-2.2.2.jar metrics-jvm-3.0.2.jar
accumulo-fate-1.6.0.jar commons-configuration-1.6.jar hbase-common.jar hive-jdbc-1.1.0-cdh5.6.0-standalone.jar jackson-jaxrs-1.9.2.jar opencsv-2.3.jar
accumulo-start-1.6.0.jar commons-dbcp-1.4.jar hbase-hadoop2-compat.jar hive-jdbc.jar jackson-xc-1.9.2.jar oro-2.0.8.jar
accumulo-trace-1.6.0.jar commons-digester-1.8.jar hbase-hadoop-compat.jar hive-jdbc-standalone.jar janino-2.7.6.jar paranamer-2.3.jar
activation-1.1.jar commons-httpclient-3.0.1.jar hbase-protocol.jar hive-metastore-1.1.0-cdh5.6.0.jar jcommander-1.32.jar parquet-hadoop-bundle.jar
ant-1.9.1.jar commons-io-2.4.jar hbase-server.jar hive-metastore.jar jdo-api-3.0.1.jar pentaho-aggdesigner-algorithm-5.1.5-jhyde.jar
ant-launcher-1.9.1.jar commons-lang-2.6.jar high-scale-lib-1.1.1.jar hive-serde-1.1.0-cdh5.6.0.jar jersey-server-1.14.jar php
antlr-2.7.7.jar commons-logging-1.1.3.jar hive-accumulo-handler-1.1.0-cdh5.6.0.jar hive-serde.jar jersey-servlet-1.14.jar plexus-utils-1.5.6.jar
antlr-runtime-3.4.jar commons-math-2.1.jar hive-accumulo-handler.jar hive-service-1.1.0-cdh5.6.0.jar jetty-all-7.6.0.v20120127.jar py
apache-curator-2.6.0.pom commons-pool-1.5.4.jar hive-ant-1.1.0-cdh5.6.0.jar hive-service.jar jetty-all-server-7.6.0.v20120127.jar regexp-1.3.jar
apache-log4j-extras-1.2.17.jar commons-vfs2-2.0.jar hive-ant.jar hive-shims-0.23-1.1.0-cdh5.6.0.jar jline-2.12.jar servlet-api-2.5.jar
asm-3.2.jar curator-client-2.6.0.jar hive-beeline-1.1.0-cdh5.6.0.jar hive-shims-0.23.jar jpam-1.1.jar snappy-java-1.0.4.1.jar
asm-commons-3.1.jar curator-framework-2.6.0.jar hive-beeline.jar hive-shims-1.1.0-cdh5.6.0.jar jsr305-3.0.0.jar ST4-4.0.4.jar
asm-tree-3.1.jar datanucleus-api-jdo-3.2.6.jar hive-cli-1.1.0-cdh5.6.0.jar hive-shims-common-1.1.0-cdh5.6.0.jar jta-1.1.jar stax-api-1.0.1.jar
avro.jar datanucleus-core-3.2.10.jar hive-cli.jar hive-shims-common.jar junit-4.11.jar stringtemplate-3.2.1.jar
bonecp-0.8.0.RELEASE.jar datanucleus-rdbms-3.2.9.jar hive-common-1.1.0-cdh5.6.0.jar hive-shims.jar libfb303-0.9.2.jar super-csv-2.2.0.jar
calcite-avatica-1.0.0-incubating.jar derby-10.11.1.1.jar hive-common.jar hive-shims-scheduler-1.1.0-cdh5.6.0.jar libthrift-0.9.2.jar tempus-fugit-1.1.jar
calcite-core-1.0.0-incubating.jar eigenbase-properties-1.1.4.jar hive-contrib-1.1.0-cdh5.6.0.jar hive-shims-scheduler.jar log4j-1.2.16.jar velocity-1.5.jar
calcite-linq4j-1.0.0-incubating.jar geronimo-annotation_1.0_spec-1.1.1.jar hive-contrib.jar hive-testutils-1.1.0-cdh5.6.0.jar logredactor-1.0.3.jar xz-1.0.jar
commons-beanutils-1.7.0.jar geronimo-jaspic_1.0_spec-1.0.jar hive-exec-1.1.0-cdh5.6.0.jar hive-testutils.jar mail-1.4.1.jar zookeeper.jar
commons-beanutils-core-1.8.0.jar geronimo-jta_1.1_spec-1.1.1.jar hive-exec.jar htrace-core.jar maven-scm-api-1.4.jar
commons-cli-1.2.jar groovy-all-2.4.4.jar hive-hbase-handler-1.1.0-cdh5.6.0.jar httpclient-4.2.5.jar maven-scm-provider-svn-commons-1.4.jar
commons-codec-1.4.jar gson-2.2.4.jar hive-hbase-handler.jar httpcore-4.2.5.jar maven-scm-provider-svnexe-1.4.jar
commons-collections-3.2.2.jar guava-14.0.1.jar hive-hwi-1.1.0-cdh5.6.0.jar jackson-annotations-2.2.2.jar metrics-core-3.0.2.jar
commons-compiler-2.7.6.jar hamcrest-core-1.1.jar hive-hwi.jar jackson-core-2.2.2.jar metrics-json-3.0.2.jar
bigdata@ubuntucmbigdata1:/opt/cloudera/parcels/CDH-5.6.0-1.cdh5.6.0.p0.45/lib/hive/lib$ cp /usr/share/java/mysql-connector-java-5.1.28.jar .
cp: cannot create regular file ‘./mysql-connector-java-5.1.28.jar’: Permission denied
bigdata@ubuntucmbigdata1:/opt/cloudera/parcels/CDH-5.6.0-1.cdh5.6.0.p0.45/lib/hive/lib$ sudo cp /usr/share/java/mysql-connector-java-5.1.28.jar .
[sudo] password for bigdata:
bigdata@ubuntucmbigdata1:/opt/cloudera/parcels/CDH-5.6.0-1.cdh5.6.0.p0.45/lib/hive/lib$ ls
accumulo-core-1.6.0.jar commons-compress-1.4.1.jar hbase-client.jar hive-jdbc-1.1.0-cdh5.6.0.jar jackson-databind-2.2.2.jar metrics-jvm-3.0.2.jar
accumulo-fate-1.6.0.jar commons-configuration-1.6.jar hbase-common.jar hive-jdbc-1.1.0-cdh5.6.0-standalone.jar jackson-jaxrs-1.9.2.jar mysql-connector-java-5.1.28.jar
accumulo-start-1.6.0.jar commons-dbcp-1.4.jar hbase-hadoop2-compat.jar hive-jdbc.jar jackson-xc-1.9.2.jar opencsv-2.3.jar
root@ubuntucmbigdata1:~# mysql -uhive -hubuntucmbigdata1 -phive_password ERROR 2003 (HY000): Can't connect to MySQL server on 'ubuntucmbigdata1' (111) root@ubuntucmbigdata1:~# mysql -uhive -hlocalhost -phive_password Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 58 Server version: 5.5.55-0ubuntu0.14.04.1 (Ubuntu) Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> exit;
断定不是授权的问题。
#bind-address = 127.0.0.1
原文地址
原文地址：http://stackoverflow.com/questions/1420839/cant-connect-to-mysql-server-error-111
成功!
本文转自大数据躺过的坑博客园博客，原文链接：http://www.cnblogs.com/zlslch/p/7086500.html，如需转载请自行联系原作者
