首页 文章 精选 留言 我的

精选列表

搜索[集群],共10000篇文章
优秀的个人博客,低调大师

ClouderManger搭建大数据集群时ERROR 2003 (HY000): Can't connect to MySQL server...

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,如需转载请自行联系原作者

资源下载

更多资源
优质分享App

优质分享App

近一个月的开发和优化,本站点的第一个app全新上线。该app采用极致压缩,本体才4.36MB。系统里面做了大量数据访问、缓存优化。方便用户在手机上查看文章。后续会推出HarmonyOS的适配版本。

Nacos

Nacos

Nacos /nɑ:kəʊs/ 是 Dynamic Naming and Configuration Service 的首字母简称,一个易于构建 AI Agent 应用的动态服务发现、配置管理和AI智能体管理平台。Nacos 致力于帮助您发现、配置和管理微服务及AI智能体应用。Nacos 提供了一组简单易用的特性集,帮助您快速实现动态服务发现、服务配置、服务元数据、流量管理。Nacos 帮助您更敏捷和容易地构建、交付和管理微服务平台。

Rocky Linux

Rocky Linux

Rocky Linux(中文名:洛基)是由Gregory Kurtzer于2020年12月发起的企业级Linux发行版,作为CentOS稳定版停止维护后与RHEL(Red Hat Enterprise Linux)完全兼容的开源替代方案,由社区拥有并管理,支持x86_64、aarch64等架构。其通过重新编译RHEL源代码提供长期稳定性,采用模块化包装和SELinux安全架构,默认包含GNOME桌面环境及XFS文件系统,支持十年生命周期更新。

Sublime Text

Sublime Text

Sublime Text具有漂亮的用户界面和强大的功能,例如代码缩略图,Python的插件,代码段等。还可自定义键绑定,菜单和工具栏。Sublime Text 的主要功能包括:拼写检查,书签,完整的 Python API , Goto 功能,即时项目切换,多选择,多窗口等等。Sublime Text 是一个跨平台的编辑器,同时支持Windows、Linux、Mac OS X等操作系统。

用户登录
用户注册