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
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 si
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/refma
aster_Host: 192.168.12.225
>
> thats the OLD dev IP and not the prd one - even though i have updated the
> master host IP in the my.cnf file. How can i change this value?
>
I don't think you need to flush your bin logs.
CHANGE MASTER TO MASTER HOST = 'hostname'
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
'./devnagios01-
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
'./devnagios01-re
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 userna
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
>
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? (
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
erver.com", I get the following 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
erver.com", I get the following 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
;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" a
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.
>
>>> 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
starte
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]
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]
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
rom 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
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
nc.com'. The machine I'm 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 d
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
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 'user1_pa
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 ent
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
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?
/Per
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 ?
--
http
H,
Ted
At 11:01 PM 10/6/2004, 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` ... >
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
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&
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 hostn
in -u root 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
Is where I ran into troubles.
Echo `hostname` gives me something like xserve1.domain.com
If
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 m
> 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:http://lists.
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 the
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 grants,
"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
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.
__
ked up.
> Please configure the 'hostname' command to return a correct hostname.
> If you want to solve this at a later stage, restart this script with
> the --force option
>
> I believe my hostname *is* in all the right places? e.g., it's in the
> 'hostconfig' fil
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 back
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 i
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
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:
tries to connect to
replies
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
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 pro
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
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 o
Hi,
How can I prevent this and what causes it? I am using mysql 4.02 on
FreeBSD. This is running as a slave.
When I change my machine's hostname mysql starts up fine, but when I slave
start replication I get an unable to initial Master.info error.
If I change the hostname back to th
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." --
ark wrote:
>
>
>>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 hostnam
?
>
>
>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. In the new error log I saw:
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
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
ror in your SQL syntax near '-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 na
he command processor stops 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 postin
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
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/host
>
> 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. My host
> name is just my ip address. And the message also said that it couldn't
> lookup my host?
>
> I've done searche
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 host
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 --po
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: conne
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
onfigured 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.
> any thoughts?
>
> thanks
> Jule
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 newb
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:
http://www.mysql.com/doc/L/o/Log_file_main
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
>
>[ w
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 ]
--
er every time I 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]
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
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 somew
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 wo
ual, your question covered by manual.
> >> Check your users and db table at mysql database
> >> probably the problem comes from there
> >>> My MySQL is not configured properly...
> >>>
> >>> I can connect using localhost with -h flag , but w
-
> From: Abu @ Trabas Dot Com [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
>
>
> P
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, please check:
>http://www.mysql.com/manual.php
roperly...
> >
> > 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.
> >
>
> -- ady --
> email: ady ebdesk.com
>
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
&
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 postin
nnect to mysqld you do 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
ed 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
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
e
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, 200
/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
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
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
-
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 are
When doing what?
mysql wrote:
> 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.c
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 mess
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:
Running 4.2 Freebsd, Apache 1.3.19, Mysql 3.23.37 and Php 4.0.5
(or trying to) inhouse no connection to net.
When I start Mysql get @HOSTNAME@ not found.
If I type hostname at prompt it returns the units name
This is getting frustrating. Any help appreciated. Thanks
Howard Picken
(Server
>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 som
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, Apac
>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 "ld
91 matches
Mail list logo
