Mysql Error 2005
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up ERROR 2005 (HY000): Unknown MySQL server host in aws up vote 7 down vote favorite 1 I have created an e-commerce site in angular js. And I need to host the same in amazon web service. So inorder to host the same I created an ec2 instance first. Now after that added an rds instance with a security group of VPC by allowing all ip's as outbound and inbound. While creating security group I specified for mysql and for all connection. Still after I remotely loged into the instance and try to connect to the end point from rds instance using mysql -u username -p password -h ********.ap-southeast-1.rds.amazonaws.com:3306 I get an error ERROR 2005 (HY000): Unknown MySQL server host xxxxxxxxx (0) I created the instance from Asia Pacific (singapore) region since I am a resident of india. mysql amazon-web-services amazon-ec2 rds amazon-vpc share|improve this question edited Sep 4 '14 at 7:29 arghtype 1,83761525 asked Sep 4 '14 at 6:55 riyas_tk 3221515 add a comment| 1 Answer 1 active oldest votes up vote 31 down vote It should be ********.ap-southeast-1.rds.amazonaws.com instead of ********.ap-southeast-1.rds.amazonaws.com:3306 You do not need the port number in the end. share|improve this answer answered Sep 4 '14 at 9:55 slayedbylucifer 11.4k114586 2 Obvious, but helped me, thanks :) –Raj Pawan Gumdal Feb 23 '15 at 19:53 Thank you for saving me from flipping my desk –Kevin Jul 22 at 4:56 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. Not the answer you're looking for? Browse other questions tagged mysql amazon-web-services amazon-ec2 rds amazon-vpc or ask your own question. asked 2 years ago viewed 8758 times active 2 years ago Related 9can't connect to mysql on AWS RDS (error 2003)1ERROR 2005 (HY000): Unknown MySQL server host “danny@ser
Connectors More MySQL.com Downloads Developer Zone Section Menu: Documentation Home MySQL 5.7 Reference Manual Preface and Legal Notices General Information Installing and Upgrading MySQL Using MySQL as a Document Store Tutorial MySQL Programs Overview of MySQL Programs Using MySQL Programs Invoking MySQL Programs Connecting to the MySQL Server Specifying Program Options Using Options on the Command Line Program Option Modifiers Using Option Files Command-Line Options that Affect Option-File Handling Using Options to Set Program Variables Option Defaults, Options Expecting Values, and the = Sign Setting Environment Variables MySQL Server and Server-Startup Programs mysqld — The MySQL Server mysqld_safe http://stackoverflow.com/questions/25659051/error-2005-hy000-unknown-mysql-server-host-in-aws — MySQL Server Startup Script mysql.server — MySQL Server Startup Script mysqld_multi — Manage Multiple MySQL Servers MySQL Installation-Related Programs comp_err — Compile MySQL Error Message File mysql_install_db — Initialize MySQL Data Directory mysql_plugin — Configure MySQL Server Plugins mysql_secure_installation — Improve MySQL Installation Security mysql_ssl_rsa_setup — Create SSL/RSA Files mysql_tzinfo_to_sql — Load the Time Zone Tables mysql_upgrade — Check and Upgrade MySQL Tables MySQL https://dev.mysql.com/doc/refman/5.7/en/option-defaults-equals.html Client Programs mysql — The MySQL Command-Line Tool mysql Options mysql Commands mysql Logging mysql Server-Side Help Executing SQL Statements from a Text File mysql Tips mysqladmin — Client for Administering a MySQL Server mysqlcheck — A Table Maintenance Program mysqldump — A Database Backup Program mysqlimport — A Data Import Program mysqlpump — A Database Backup Program mysqlsh — The MySQL Shell mysqlshow — Display Database, Table, and Column Information mysqlslap — Load Emulation Client MySQL Administrative and Utility Programs innochecksum — Offline InnoDB File Checksum Utility myisam_ftdump — Display Full-Text Index information myisamchk — MyISAM Table-Maintenance Utility myisamchk General Options myisamchk Check Options myisamchk Repair Options Other myisamchk Options Obtaining Table Information with myisamchk myisamchk Memory Usage myisamlog — Display MyISAM Log File Contents myisampack — Generate Compressed, Read-Only MyISAM Tables mysql_config_editor — MySQL Configuration Utility mysqlbinlog — Utility for Processing Binary Log Files mysqlbinlog Hex Dump Format mysqlbinlog Row Event Display Using mysqlbinlog to Back Up Binary Log Files Specifying the mysqlbinlog Server ID mysqldumpslow — Summarize Slow Query Log Files MySQL Program Development Utilities mysql_config — Display Options for Compiling Clients my_print_defaults — Display Options from Option Files reso
this error every time i try to run the install script. Does anybody know what is causing this https://www.howtoforge.com/community/threads/mysql-error-2005.1906/ error or how to fix it?? Mandriva 2006 -------------------------------------------------------------------------- for d in uudeview.1 uuenview.1 xdeview.1 ; do \ ./install-sh -c -m 644 ./man/$d /home/admispconfig/ispconfig/tools/uudeview/man/man1/$d ; \ done http://serverfault.com/questions/363397/getting-error-unknown-mysql-server-host-during-importing-the-sql-file All prerequisites are fulfilled. Here we go... Please enter your MySQL server:localhost Please enter your MySQL user:ispconfig Please enter your MySQL password: ERROR 2005 (HY000): Unknown MySQL mysql error server host ' localhost' (2) ERROR: The provided MySQL password is wrong! The installation routine stops here! [[emailprotected] install_ispconfig]# -------------------------------------------------------------------------- zalo, Jan 2, 2006 #1 till Super Moderator Staff Member ISPConfig Developer This means that either your mysql server is not installed, not running or not listening on localhost. If your mysql server mysql error 2005 is running, you maybe have the "skip-networking" option in you mysql my.cnf config file. till, Jan 2, 2006 #2 zalo New Member Mysql is installed and running: -mysqld (pid 2033) is running... I have removed --skip-networking from the file: /etc/sysconfig/mysqld I dident find any --skip-networking in the my.cnf file How do i make mysql listen to "localhost" zalo, Jan 2, 2006 #3 falko Super Moderator ISPConfig Developer Please restart MySQL. Then post the output of Code: netstat -tap here as well as the content of /etc/hosts. falko, Jan 2, 2006 #4 zalo New Member [[emailprotected] salomon]# /etc/init.d/mysqld restart Stopping MySQL: [ OK ] Starting MySQL: [ OK ] [[emailprotected] salomon]# netstat -tap Active Internet connections (servers and established) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp 0 0 *:imaps *:* LISTEN 3760/xinetd tcp 0 0 *op3s *:* LISTEN 3760/xinetd tcp 0 0 *:mysql *:* LISTEN 20206/mysqld tcp 0 0 server1.zalo.net:10026 *:* LISTEN 3906/master tcp
Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Server Fault Questions Tags Users Badges Unanswered Ask Question _ Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Getting Error “Unknown MySQL server host” during importing the sql file? up vote 1 down vote favorite In mysql server, when importing the sql file into the db. I am getting as error as below. So, can you help where the issues lies that is in mysql server config or the sql file ERROR 2005 (HY000) at line 1: Unknown MySQL server host 'Courier' (1) Mysql Server Version : 5.0.45 mysql mysql5.5 share|improve this question asked Feb 24 '12 at 13:23 Mughil 7741823 Have you got an entry called 'Courier' in your hosts file? If not, try specifying the host in its IP equivalent –qweet Feb 24 '12 at 13:57 there is no entry with 'Courier' in your hosts file –Mughil Mar 6 '12 at 9:51 add a comment| 1 Answer 1 active oldest votes up vote 1 down vote This is a name resolution issue. The machine you're using to import this sql file is not able to resolve the MySQL Server hostname 'Courier'. Are you sure this is the correct hostname? Can you provide the output of a 'nslookup Courier' and the command you're using to import? If you're not sure about the hostname, try importing using the MySQL Server ip address. Hope this helps. share|improve this answer answered Feb 24 '12 at 14:01 Luis Fernando Alen 380149 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. Not the answer you're looking for? Browse other questions tagged mysql mysql5.5 or ask your own question. asked 4 years ago viewed 3445 times active 3 years ago Related 10Cant connect to mysql using self sign