Suggestion : Better error message for hostname resolution error during MySQL installation

2010-08-22 Thread Jaikiran Pai
Hello everyone, Recently, while installing MySQL, I ran into an error[1] which complained about the hostname: --- Neither host 'blahblah' nor 'localhost' could be looked up with /usr/bin/resolveip Please configure the 'hostname' command to return a correct hostname. If you want to solve

Re: master master replication - hostname change - slaves fails

2008-05-23 Thread Tom Brown
I don't think you need to flush your bin logs. CHANGE MASTER TO MASTER HOST = 'hostname'; Look at this for more info at http://dev.mysql.com/doc/refman/5.0/en/change-master-to.html There is a lot more you can add to the statement. thanks but this gave me a very similar error - I

master master replication - hostname change - slaves fails

2008-05-22 Thread Tom Brown
Hi I had master-master working fin in dev - i move them to prd now and so change the hostnames, on starting i see this error 080522 11:53:40 mysqld started 080522 11:53:40 InnoDB: Started; log sequence number 0 213274351 080522 11:53:40 [ERROR] Failed to open the relay log

Re: master master replication - hostname change - slaves fails

2008-05-22 Thread Tom Brown
Hi I had master-master working fin in dev - i move them to prd now and so change the hostnames, on starting i see this error 080522 11:53:40 mysqld started 080522 11:53:40 InnoDB: Started; log sequence number 0 213274351 080522 11:53:40 [ERROR] Failed to open the relay log

Re: master master replication - hostname change - slaves fails

2008-05-22 Thread Mike
= 'hostname'; Look at this for more info at http://dev.mysql.com/doc/refman/5.0/en/change-master-to.html There is a lot more you can add to the statement. thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: master master replication - hostname change - slaves fails

2008-05-22 Thread Mike
On Thu, May 22, 2008 at 10:00 AM, Tom Brown [EMAIL PROTECTED] wrote: I don't think you need to flush your bin logs. CHANGE MASTER TO MASTER HOST = 'hostname'; Look at this for more info at http://dev.mysql.com/doc/refman/5.0/en/change-master-to.html There is a lot more you can add

about the username and hostname

2007-06-28 Thread Weiqi Wang
Dear everyone: I start mySQL by a shotcut in windowsXP so that I don't have to input my username, just password is required. That brings in a problem: I don't know my user name(I suppose it to be root) and the server host, etc. Is there anyway I can find it out? (I suppose the server host is

Re: about the username and hostname

2007-06-28 Thread John Meyer
Weiqi Wang wrote: Dear everyone: I start mySQL by a shotcut in windowsXP so that I don't have to input my username, just password is required. That brings in a problem: I don't know my user name(I suppose it to be root) and the server host, etc. Is there anyway I can find it out? (I

Re: about the username and hostname

2007-06-28 Thread Eugene Mah
Check the properties of your shortcut to see what user name is specified in the command options Eugene Weiqi Wang wrote: Dear everyone: I start mySQL by a shotcut in windowsXP so that I don't have to input my username, just password is required. That brings in a problem: I don't know my

RE: about the username and hostname

2007-06-28 Thread Jerry Schwartz
06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com -Original Message- From: Weiqi Wang [mailto:[EMAIL PROTECTED] Sent: Thursday, June 28, 2007 10:27 AM To: mysql@lists.mysql.com Subject: about the username and hostname Dear

Re: Problems connecting using -h hostname with new installation

2006-08-07 Thread obed
message: ERROR 1130 (0): Host '75.120.X.X' is not allowed to connect to this MySQL server Now the server's hostname is web1.server.com and it resolves to 75.120.X.X fine so I know it's not an issue with that. Does anyone have any clues why? I have a web1.server.com added in the mysq.user

Re: Problems connecting using -h hostname with new installation

2006-08-07 Thread Daniel da Veiga
message: ERROR 1130 (0): Host '75.120.X.X' is not allowed to connect to this MySQL server Now the server's hostname is web1.server.com and it resolves to 75.120.X.X fine so I know it's not an issue with that. Does anyone have any clues why? I have a web1.server.com added in the mysq.user

Problems connecting using -h hostname with new installation

2006-08-06 Thread Ro BGCT
.X.X' is not allowed to connect to this MySQL server Now the server's hostname is web1.server.com and it resolves to 75.120.X.X fine so I know it's not an issue with that. Does anyone have any clues why? I have a web1.server.com added in the mysq.user table so I know that's not the problem. If I

Re: User is rejected because of IP, but hostname is allowed

2006-02-20 Thread sheeri kritzer
Why not also put a wildcard for 192.168.% ? That's what we've done. -Sheeri On 2/17/06, Ryan Stille [EMAIL PROTECTED] wrote: did u start mysql with --skip-name-resolve ??? Kishore Jalleda Kim Christensen wrote: On 2/16/06, Ryan Stille [EMAIL PROTECTED] wrote: Nope. Well, have you

Re: User is rejected because of IP, but hostname is allowed

2006-02-17 Thread Kim Christensen
On 2/16/06, Ryan Stille [EMAIL PROTECTED] wrote: Nope. Well, have you tried it? Did it solve your problem? -- Kim Christensen [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: User is rejected because of IP, but hostname is allowed

2006-02-17 Thread Kim Christensen
On 2/16/06, Ryan Stille [EMAIL PROTECTED] wrote: Nope. Well, have you tried it? Did it solve your problem? -- Kim Christensen [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: User is rejected because of IP, but hostname is allowed

2006-02-17 Thread Ryan Stille
did u start mysql with --skip-name-resolve ??? Kishore Jalleda Kim Christensen wrote: On 2/16/06, Ryan Stille [EMAIL PROTECTED] wrote: Nope. Well, have you tried it? Did it solve your problem? Sorry, I misunderstood. I thought Kishore was saying that if I had started the server

User is rejected because of IP, but hostname is allowed

2006-02-16 Thread Ryan Stille
trying to connect from is named dbdev.willcomminc.com. I did a reverse lookup from the database server and the IP 192.168.2.56 does indeed lookup to dbdev.willcomminc.com. Why is MySQL ignoring the hostname and using the IP? I did google for this first but didn't come up with anything. -Ryan

Re: User is rejected because of IP, but hostname is allowed

2006-02-16 Thread Kishore Jalleda
is MySQL ignoring the hostname and using the IP? I did google for this first but didn't come up with anything. -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: User is rejected because of IP, but hostname is allowed

2006-02-16 Thread Ryan Stille
Nope. _ From: Kishore Jalleda [mailto:[EMAIL PROTECTED] Sent: Thursday, February 16, 2006 4:32 PM To: Ryan Stille Cc: mysql@lists.mysql.com Subject: Re: User is rejected because of IP, but hostname is allowed did u start

Re: user and hostname connection priveleges

2005-09-15 Thread Michael Stassen
James wrote: I had set up the following I have a MYSQL server running on let's say 123.xx.xx.xx User: user1 Host: 111.xx.xx.xx and gave that user the appropriate priveleges. How exactly? Did you use GRANT? Something like GRANT ALL ON test.* TO [EMAIL PROTECTED] IDENTIFIED BY

Re: user and hostname connection priveleges

2005-09-15 Thread Gleb Paharenko
Hello. If you want to have a complete understanding of how MySQL access privilege system works, read this chapter of the manual: http://dev.mysql.com/doc/mysql/en/privilege-system.html James [EMAIL PROTECTED] wrote: I had set up the following I have a MYSQL server running on

user and hostname connection priveleges

2005-09-14 Thread James
I had set up the following I have a MYSQL server running on let's say 123.xx.xx.xx User: user1 Host: 111.xx.xx.xx and gave that user the appropriate priveleges. So. I tried to connect to the MYSQL server from 111.xx.xx.xx using user1, but it won't allow my to. I then had to add this

Re: authentication - which hostname is used?

2005-07-19 Thread Gleb Paharenko
Hello. Searching through the code shown me that all stuff is located in sql/hostname.cc file. MySQL depends on gethostbyaddr_r and uses the official name of the host which it returns. According to rfc897: Hosts have an official (or primary) name and possibly several nicknames. When

authentication - which hostname is used?

2005-07-17 Thread Per Jessen
Hi, when an IP-address is reverse mapped to multiple names, which one is used by mysql for user authentication? Right now (4.1.11) it looks like the first record is used, which I'm not sure good enough. Shouldn't mysql check all the returned names and see if one of them authenticates?

hostname

2004-10-26 Thread Jad Madi
hi i have changed my host name now I got this when I tried to restart mysql mysql 6382 0.0 1.5 31340 3512 ?SOct25 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/localhost.localdomain.pid --skip-locking what to do ? --

2 questions: hostname variable and exit if slave

2004-10-06 Thread Brian C. Hill
I have 2 unrelated questions: 1) Is there any way to get the hostname that the server is running on from within mysql? All I can come up with is (pseudo coded): mysql system echo insert mysql.hostname `hostname` ... hostname.sql mysql

Re: 2 questions: hostname variable and exit if slave

2004-10-06 Thread Ted Byrne
, you wrote: I have 2 unrelated questions: 1) Is there any way to get the hostname that the server is running on from within mysql? All I can come up with is (pseudo coded): mysql system echo insert mysql.hostname `hostname` ... hostname.sql mysql

hostname-bin.001 Files

2004-09-28 Thread Rob Best
On my mysql servers, I've noticed some unexpected files in the /usr/local/mysql/data/ directory. Specifically, I have files like: hostname-bin.001 hostname-bin.002 hostname-bin.003 etc. (obviously with hostname being replaced with the name of the computer) I also have files like

Re: hostname-bin.001 Files

2004-09-28 Thread Rob Best
, 2004, at 4:49 AM, Rob Best wrote: On my mysql servers, I've noticed some unexpected files in the /usr/local/mysql/data/ directory. Specifically, I have files like: hostname-bin.001 hostname-bin.002 hostname-bin.003 etc. (obviously with hostname being replaced with the name of the computer) I also

Re: hostname-bin.001 Files

2004-09-28 Thread Egor Egorov
Rob Best [EMAIL PROTECTED] wrote: Okay, replying to my own post is like talking to one's self but... so I finally found the manual page that describes the two files. Any reason I want them (the log files that is)? My databases currently are not replicating (no plans to add it) and have many

RE: unable to resolve hostname...

2004-03-02 Thread J.R. Bullington
I have run into this countless times. The 'easiest' way to fix this is to set your hostname back to localhost, run the scripts/mysql_install_db, then change your hostname back to whatever you need it to be. I don't understand why it happens, I just know that is the 'easiest' way to fix it. J.R

unable to resolve hostname...

2004-03-01 Thread Jonathan Villa
Ok, I am going about this as I normally have umpting times # scripts/mysql_install_db and I get Neither host 'isdesign.isdesigndev.com' and 'localhost' could not be looked up with ./bin/resolveip Please configure the 'hostname' command to return a correct hostname. If you want to solve

New install, hostname and other lookup isues

2004-01-31 Thread Scott Haneda
password password That worked, and I can get into the database as a localhost user with no trouble at all. The second I instructed MySql to /usr/local/mysql/bin/mysqladmin -u root -h `hostname` password password Is where I ran into troubles. Echo `hostname` gives me something like xserve1

hostname

2003-09-21 Thread [EMAIL PROTECTED]
Hi all, is there a way to find out which host I am connected from? My CGI script checks privileges of users based on host names they came from. But their hosts some times are detected as IP. E.g. when the script asks: SHOW GRANTS FOR 'user'@'127.0.0.1' Mysql replies that there is no such

Re: hostname

2003-09-21 Thread rich allen
127.0.0.1 is always localhost, perhaps you could make this change in your scripts - hcir use MySQL is there a way to find out which host I am connected from? My CGI script checks privileges of users based on host names they came from. But their hosts some times are detected as IP. E.g. when

Re: hostname

2003-09-21 Thread Dan Anderson
is there a way to find out which host I am connected from? Does the solution have to be a function called within mySQL or would you accept a function called by PHP or Perl? -Dan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: hostname

2003-09-21 Thread [EMAIL PROTECTED]
In order to avoid errors it is better to call this within mysql. I tried already SELECT USER(). It seems to work for me. --- Dan Anderson [EMAIL PROTECTED] wrote: is there a way to find out which host I am connected from? Does the solution have to be a function called within mySQL or

hostname-bin.xxx file what is this

2003-05-28 Thread Knight Raider
I installed MySQL that comes with RedHat 8, after run it I noticed that lot of file created in my data directory, file name is something like 'myhostname-bin.xxx' where xxx is the number, and it take lot of disk space. What the file is use for and how to avoid it? Thanks in advance.

Re: hostname-bin.xxx file what is this

2003-05-28 Thread Egor Egorov
Knight Raider [EMAIL PROTECTED] wrote: I installed MySQL that comes with RedHat 8, after run it I noticed that lot of file created in my data directory, file name is something like 'myhostname-bin.xxx' where xxx is the number, and it take lot of disk space. What the file is use for and how

Re: silly old hostname help?

2003-05-27 Thread Dan Nelson
In the last episode (May 27), [EMAIL PROTECTED] said: Rebuilding my (Mac OS X Server 10.2.x) server and installing MySQL again, I have forgotten how to fix this, which I've seen long ago: %mysql_install_db Sorry, the host 'rogers' could not be looked up. Please configure the 'hostname

resolving hostname

2003-03-06 Thread mysql
when I try to connect to mysql (on the same host as mysqld): mysql -h mysql.vhost1.com I get: Access denied for user [EMAIL PROTECTED] mysqld runs at hostname.domain.com mysql.vhost1.com and hostname.domain.com have the same ip mysql first looks up the ip of mysql.vhost1.com then resolves it

Hostname error on install

2003-01-13 Thread Mike
OS - FreeBSD 4.7 Release MySQL 3.23.54 Have an odd error. When reinstalling MySQL, I needed to add something's, it says the hostname is wrong, I did a make clean and tried make reinstall --force and everything else I can find. Never had this error before! Nothings been changed since

reg mysql unreachability from hostname

2002-12-26 Thread geetha
sir/madam while in our script trying to reach a particular hostname related mysql_data to monitor the calls . we get an error database connect failure please advice us how to proceed further . eagerly waiting for ur earliest reply regards Geetha Sr.Engineer [VAS] vsnl/chennai

Hostname resolve issue?

2002-12-20 Thread MySQL
Hi all, Due to the severe security issue released last week for mysql, we had to upgrade all our 3.22.32 servers to the latest 3.23 release. However, this introduced us to some problems across several of our 80+ DB servers: 1. Weird resolve issues: Host A tries to connect to Host B

hostname failure

2002-12-18 Thread Vance Wheelock
I have a domain mail.xxx.com. Everywhere I do a nslookup the reverse lookup up returns the domain correctly. When I do a 'hostname' it returns the correct name. Also on this machine I have another domain mail.yyy.com Both of these domains resolve to the same IP. The problem I'm having is when

slave pukes with hostname change

2002-12-15 Thread Eric Frazier
Hi, Ok, I am begging now. Has no one ran into this problem? I can't believe it would not come up, it is the only thing that mysql does wrong with a hostname change. All of the log files for example just are rewritten with the new hostname. I know one way I could fix it, RESET MASTER

Re: slave pukes with hostname change

2002-12-15 Thread Jeremy Zawodny
On Sun, Dec 15, 2002 at 07:34:49PM -0500, Eric Frazier wrote: Hi, Ok, I am begging now. Has no one ran into this problem? I can't believe it would not come up, it is the only thing that mysql does wrong with a hostname change. All of the log files for example just are rewritten

Re: slave pukes with hostname change

2002-12-15 Thread Eric Frazier
Hi, sorry, I didn't realize that. The slave's hostname. Thanks, Eric At 08:01 PM 12/15/02 -0800, Jeremy Zawodny wrote: On Sun, Dec 15, 2002 at 07:34:49PM -0500, Eric Frazier wrote: Hi, Ok, I am begging now. Has no one ran into this problem? I can't believe it would not come up

Re: A FAQ type question, but not in the FAQ - How to change my hostname, but not make replication puke

2002-10-01 Thread Eric Frazier
Hi, The mysql master wasn't restricting the slave by ip. But thanks, Eric At 10:28 AM 9/30/02 -0500, gerald_clark wrote: You need to grant privileges on the master to the new slave machine. http://www.kwinternet.com/eric (250) 655 - 9513 (PST Time Zone) Inquiry is fatal to certainty. --

Re: A FAQ type question, but not in the FAQ - How to change my hostname,but not make replication puke

2002-09-30 Thread gerald_clark
Did you make the changes to master.onfo to point to the new master? Did mysql own master.info when you were through? Eric Frazier wrote: Hi, I changed my hostname(The DNS change was taken care of elseware) in FreeBSD 4.6 in the rc.conf file, rebooted. Mysql had no problems starting

Re: A FAQ type question, but not in the FAQ - How to change my hostname, but not make replication puke

2002-09-30 Thread Eric Frazier
Frazier wrote: Hi, I changed my hostname(The DNS change was taken care of elseware) in FreeBSD 4.6 in the rc.conf file, rebooted. Mysql had no problems starting, but it failed to start the slave. In the new error log I saw: 020927 10:15:58 mysqld started 020927 10:15:59 InnoDB: Started

Re: A FAQ type question, but not in the FAQ - How to change my hostname, but not make replication puke

2002-09-30 Thread gerald_clark
to master.onfo to point to the new master? Did mysql own master.info when you were through? Eric Frazier wrote: Hi, I changed my hostname(The DNS change was taken care of elseware) in FreeBSD 4.6 in the rc.conf file, rebooted. Mysql had no problems starting, but it failed to start the slave

A FAQ type question, but not in the FAQ - How to change my hostname, but not make replication puke

2002-09-27 Thread Eric Frazier
Hi, I changed my hostname(The DNS change was taken care of elseware) in FreeBSD 4.6 in the rc.conf file, rebooted. Mysql had no problems starting, but it failed to start the slave. In the new error log I saw: 020927 10:15:58 mysqld started 020927 10:15:59 InnoDB: Started 020927 10:15:59

Bug at Hostname parameter for SHOW GRANTS FOR ...?

2002-09-23 Thread Moestl, Wolfgang
the parsing for the hostname at the '-' character and tries to find an appropriate command sequence afterwards. Is this a Bug or expected behaviour? Best regards, Wolf - Before posting, please check: http://www.mysql.com

re: Bug at Hostname parameter for SHOW GRANTS FOR ...?

2002-09-23 Thread Egor Egorov
'-COMPUTER' at line 1. MW It looks like the command processor stops the parsing for the hostname at the '-' character and tries to find an appropriate command sequence afterwards. MW Is this a Bug or expected behaviour? Quote host name, like 'root'@'MY-COMUPTER' -- For technical support contracts

Re: Setting up hostname

2002-07-09 Thread Desmond Lee
Hi Thanks for all your help, much appreciated. I edited my both the /etc/resolv.conf and /etc/hosts to include the line 'hostname 142.135.134.154' of course, that's not my real ip addy. Am i suppose to edit these files? or did you mean to edit the /etc/sysconfig/network file. THe /etc

Re: Setting up hostname

2002-07-08 Thread Desmond Lee
Hi there Thanks for your reply. check your system configuration ... just run from shell script : hostname and what does it show you ... WHen i run 'hostname' i get my ip address shown to me. and then check your /etc/hosts and /etc/resolv.conf my /etc/hosts has the following in it: # Do

Re: Setting up hostname

2002-07-07 Thread Dicky Wahyu Purnomo
the hostname latter on. So, now that mysql is isntalled i need to set up the hostname stuff. My host name is just my ip address. And the message also said that it couldn't lookup my host? I've done searches on google and the mysql documentation but i didn't get any useful info about setting up

Setting up hostname

2002-07-05 Thread Desmond Lee
Hi guys I just managed to install mysql... yippy But, i had to use the '--force option' when executing the /usr/local/mysql/scripts/mysql_install_db . I got a message saying that i needed to configure the hostname latter on. So, now that mysql is isntalled i need to set up the hostname stuff

hostname vs localhost...

2002-05-10 Thread Richard Idalski
I need to connect to a MySQL database from a remote machine but it seems that when the mysql was setup, that it was only setup with localhost, and not it's hostname. IE: When I try these commands: 'mysqladmin -h ren2 --port=3306 version' I get the following : mysqladmin: connect to server

Re: hostname vs localhost...

2002-05-10 Thread Joseph Bueno
Richard Idalski a écrit : I need to connect to a MySQL database from a remote machine but it seems that when the mysql was setup, that it was only setup with localhost, and not it's hostname. IE: When I try these commands: 'mysqladmin -h ren2 --port=3306 version' I get the following

change local hostname

2002-04-10 Thread Jule Slootbeek
Hey, i just installed MySQL and i can't change anything since it's configured to search for localhost, but my localhost name is something else, how do i change this? I know it was stupid of me to change the hostname in the first place, but i didn;t know what i was doing, being a newbie and all

Re: change local hostname

2002-04-10 Thread Steven Hajducko
for localhost, but my localhost name is something else, how do i change this? I know it was stupid of me to change the hostname in the first place, but i didn;t know what i was doing, being a newbie and all. any thoughts? thanks Jule ps. if there is a way that i could change my hostname back

Re: change local hostname

2002-04-10 Thread Jule Slootbeek
I run libranet 1.9.1, and it had an option during install to change hostname, and me not knowing anybetter customized it a little /etc/hosts says: 127.0.0.1 blindjule localhost can i just change the blindjule back to localhost? will that fix it? or will i have to reinstall certain

HOSTNAME-bin.001 ???

2002-01-25 Thread Victoria Reznichenko
Jacob, Thursday, January 24, 2002, 7:49:54 PM, you wrote: JFL I found files whith names like localhost-bin.001, localhost-bin.002 in JFL /tmp/ JFL What are they ? These are log files. You can see more information about log files maintenance at:

HOSTNAME-bin.001 ???

2002-01-24 Thread Jacob Friis Larsen
I found files whith names like localhost-bin.001, localhost-bin.002 in /tmp/ What are they ? Also, what does it mean that my MySQL database version is 3.23.47-log. What does -log mean ? Regards Jacob [ www.sharksforum.com | www.eksperten.dk | +45 70 27 07 67 ]

Re: HOSTNAME-bin.001 ???

2002-01-24 Thread Gerald Clark
Jacob Friis Larsen wrote: I found files whith names like localhost-bin.001, localhost-bin.002 in /tmp/ What are they ? Log files. Also, what does it mean that my MySQL database version is 3.23.47-log. What It means it is logging. does -log mean ? Regards Jacob [ www.sharksforum.com

Error 2003: Can't connect to MySQL server on 'hostname' (110)

2001-12-27 Thread Lucas Vogel
try to connect to the Linux machine I get the error in the Subject of this email. I put my domain name(or at least part of it, since i am on a DHCP client) in /etc/hosts.allow and can connect to the Linux machine via ssh without any problems. But the mysql -h [hostname] -u [user] -p command does

MySQL determination of hostname?

2001-12-12 Thread Shon Stephens
How does MySQL determine hostnames when checking access permissions? I assume it uses whatever methods are available to the system (/etc/hosts, NIS, DNS, etc...). Will it use those services in the order they are listed in nsswitch.conf (Solaris)? What about for determining its local hostname

Re: Can't connect via IP, but can via hostname

2001-11-15 Thread Carl Troein
Alex writes: Yea, but even doesn't check grant tables I think, It just hangs up, waits about 30-40 seconds, and then says something like 'Error 3303: failed to connect (110)' (not sure about numbers, is there any way to find more detailed desription for 3303 error somewhere?) CT

Re: Can't connect via IP, but can via hostname

2001-11-13 Thread Gerald Clark
[mailto:[EMAIL PROTECTED]] Sent: Monday, November 12, 2001 11:33 PM To: [EMAIL PROTECTED] Subject: Re: Can't connect via IP, but can via hostname Please read mysql manual, your question covered by manual. - Before posting

RE: Can't connect via IP, but can via hostname

2001-11-13 Thread Rick Emery
] Subject: Re: Can't connect via IP, but can via hostname Please read mysql manual, your question covered by manual. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: Can't connect via IP, but can via hostname

2001-11-13 Thread Carl Troein
at mysql database probably the problem comes from there My MySQL is not configured properly... I can connect using localhost with -h flag , but when I'm using IP instead of hostname it doesn't connects at all... -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL

Re: Can't connect via IP, but can via hostname

2001-11-13 Thread Carl Troein
Carl Troein writes: http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html Oops. That only convers the difference between 'localhost' and anything else. If whoever posted the question is interested in actually getting things to work, read the manual chapter on how the privilege system

Can't connect via IP, but can via hostname

2001-11-12 Thread Alex
Dear Sirs, My MySQL is not configured properly... I can connect using localhost with -h flag , but when I'm using IP instead of hostname it doesn't connects at all... What'd I do? Thank you. - Before posting, please check

Re: Can't connect via IP, but can via hostname

2001-11-12 Thread Ady Wicaksono
Check your users and db table at mysql database probably the problem comes from there On Tuesday 13 November 2001 02:47 pm, Alex wrote: Dear Sirs, My MySQL is not configured properly... I can connect using localhost with -h flag , but when I'm using IP instead of hostname it doesn't

Re: Can't connect via IP, but can via hostname

2001-11-12 Thread Abu @ Trabas Dot Com
, but when I'm using IP instead of hostname it doesn't connects at all... What'd I do? Thank you. -- ady -- email: ady at ebdesk.com adiwicaksono at yahoo.com ady at students.if.itb.ac.id homepage: http://ady97.hypermart.net/ To request this thread, e-mail [EMAIL

Re: Get real mysqld hostname

2001-11-09 Thread Dan Nelson
not know which server you are really connected to. The get_host_info only returns the name used to connect to the virtual address. I've checked the variables table but the hostname is not there either. I can solve the problem by creating a database with the name of the host but that's not very

Get real mysqld hostname

2001-11-08 Thread Mike Broxterman
to. The get_host_info only returns the name used to connect to the virtual address. I've checked the variables table but the hostname is not there either. I can solve the problem by creating a database with the name of the host but that's not very elegant nor can I use dots for the IP or FQDN as the db name

Problem installing 3.23.43 (@HOSTNAME@ command not found)

2001-10-29 Thread Neil Aggarwal
/etc/rc.d/init.d/mysqld /etc/rc.d/rc6.d/K01mysqld /etc/init.d/mysqld start I then got this error message: /etc/init.d/mysqld: @HOSTNAME@: command not found Starting mysqld daemon with databases from /usr/local/mysql/data 011029 12:23:02 mysqld ended Any ideas why this error is occurring? Thanks

RE: Problem installing 3.23.43 (@HOSTNAME@ command not found)

2001-10-29 Thread Williams, Vincent
I had to replace @HOSTNAME@ with HOSTNAME in the file mysql.server on the line, pid_file=$datadir/HOSTNAME.pid. @HOSTNAME@ wasn't a valid variable. -Original Message- From: Neil Aggarwal [mailto:[EMAIL PROTECTED]] Sent: Monday, October 29, 2001 10:29 AM To: Mysql list Subject

Re: Problem installing 3.23.43 (@HOSTNAME@ command not found)

2001-10-29 Thread Stephen Brownlow
We have the same problem with MySQL (3.23.36) for SCO OpenServer, in script mysql.server. Here is the problem code, showing my workaround. ... if test -z $pid_file then # pid_file=$datadir/`@HOSTNAME@`.pid pid_file=$datadir/`hostname`.pid # changed @HOSTNAME@ to hostname else case

@HOSTNAME@: not found

2001-10-26 Thread Ari Davidow
When I start mysql 3.23.38 on our Solaris 2.8 machine, with or without the /etc/my.cnf file read (i.e., I can move it out of the way or not), I get the following messages: /etc/rc2.d/S99mysql: @HOSTNAME@: not found S99mysql is the script that starts up MySQL when I reboot the machine (I believe

Re: @HOSTNAME@error

2001-09-10 Thread harry amarantidis
I checked my boot log and found the follwing errors /etc/init.d/rc.d/S61mysql: @HOSTNAME@: command not found /etc/init.d/rc.d/S61mysql: my_print_defaults: command not found I have checked the manual but could not figure out if this is a problem or not mysql seems t run fine for now. What

RE: @HOSTNAME@error

2001-09-10 Thread Narvaez, Teresa
Those are the startup scripts to startup MySQL when the server is rebooted. view the file /etc/init.d/rc.d/S61mysql and search for @HOSTNAME@ and my_print_defaults and see how these commands are invoked and if they exists on your system. Hope this helps, -Teresa -Original Message

@HOSTNAME@ ?

2001-08-16 Thread mysql
Hi ! I get: @HOSTNAME@: command not found Does anyone know how to solve that ? I didn't find anything on the net or on the mysql.com homepage. Thanks. Jan-Hendrik - Before posting, please check: http://www.mysql.com

Re: @HOSTNAME@ ?

2001-08-16 Thread Philip Mak
On Thu, 16 Aug 2001, mysql wrote: @HOSTNAME@: command not found Does anyone know how to solve that ? I didn't find anything on the net or on the mysql.com homepage. You're getting that from support-files/mysql.server, yes? I've gotten that message too and was puzzled by it. I just replaced

mysql -h hostname error

2001-06-13 Thread Nancy Yang
Hi, when I try the following command, I got hostname is not allowed to connect to this mysql server. Any clue? Nancy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Fwd: mysql -h hostname error

2001-06-13 Thread Nancy Yang
The command I used was: mysql[2]mysql -u root -h som-host-name ERROR 1130: Host 'some-host-name.bbn.com' is not allowed to connect to this MySQL serv er Date: Wed, 13 Jun 2001 14:18:46 -0400 To: [EMAIL PROTECTED] From: Nancy Yang [EMAIL PROTECTED] Subject: mysql -h hostname error Cc: Danny

Re: mysql -h hostname error

2001-06-13 Thread Neil Zanella
to be a security risk which is why it is disabled by default. Neil On Wed, 13 Jun 2001, Nancy Yang wrote: Hi, when I try the following command, I got hostname is not allowed to connect to this mysql server. Any clue? Nancy

HOSTNAME not found error

2001-05-06 Thread Howard Picken
I've seen this problem posted before but I can't find any replies. When I start the server I get the following ./mysql.server: @HOSTNAME@: command not found ./mysql.server: my_print_defaults: command not found Obviously I've setup something wrong. Running FreeBSD 4.3, Apache 1.3.X, MySQL

Re: HOSTNAME not found error

2001-05-06 Thread Paul DuBois
I've seen this problem posted before but I can't find any replies. When I start the server I get the following ./mysql.server: @HOSTNAME@: command not found ./mysql.server: my_print_defaults: command not found Obviously I've setup something wrong. Looks like you installed mysql.server.sh

mysql.server uses fully-qualified hostname, but mysqld doesn't

2001-05-02 Thread dave
Description: My pidfile name is ldap1.pid However, I get the following error: root@ldap1# sh /usr/local/share/mysql/mysql.server stop No mysqld pid file found. Looked for /var/db/mysql/ldap1.netcarrier.net.pid. My hostname returns ldap1.netcarrier.net. So