We use host aliases to connect to MySQL all the time, never had an
issue before. Today we added a new alias, and we cannot connect to the
server using that one alias but only when we are on the local machine.
Here is the NIS entry for this host:
# ypmatch -k ubshp2 hosts
ubshp2 192.132.2.143
Found the problem. There was cached DNS info on the host. Restarted
nscd and then it worked.
On Thu, Apr 18, 2013 at 10:59 AM, Larry Martell wrote:
> We use host aliases to connect to MySQL all the time, never had an
> issue before. Today we added a new alias, and we cannot connect
On Monday, July 05, 2010 01:17:57 pm burhan.kha...@gmail.com wrote:
> Michael:
>
> It could be that MySQL is only listening on localhost (127.0.0.1) and not
> your net IP. Check your network settings in your server config.
> Alternately, you can also do a
>
> netstat -anp | grep mysql
>
> As r
BlackBerry® smartphone from Wataniya Telecom
-Original Message-
From: Michael Satterwhite
Date: Mon, 5 Jul 2010 10:04:22
To: Martin Clarke
Cc:
Subject: Re: Why is Host option Failing?
On Monday, July 05, 2010 08:26:03 am you wrote:
> Hi,
>
> dig should be in /usr/bin but its possible
On Monday, July 05, 2010 10:46:48 am Bob Cole wrote:
>
> The remote computer let me into mysql and I typed:
> mysql> use mysql
> mysql> select host, user, Password, Select_priv from user;
> +--+--+---+
> --
-h photon -u michael -p??
On my home computer I entered the following
(note there is no space between the -p and the password):
$ mysql -h www.my_abc_xyz.com -u myUserNm -pMyPasswrd
The remote computer let me into mysql and I typed:
mysql> use mysql
m
On Monday, July 05, 2010 08:26:03 am you wrote:
> Hi,
>
> dig should be in /usr/bin but its possible it isn't installed
> I'm not sure about PcLinuxOS but it's in the dnsutils package on
> debian/Ubuntu.
As you said earlier, it's not necessary to use dig to check the ip address.
Ping does the jo
On Sunday, July 04, 2010 06:36:00 pm you wrote:
> What user are you at the time you are running these tests. Would I be
> correct in guessing 'root'?
>
> The reason localhost works is because, in some distros, root is
> enabled localhost with no password .. which is dangerous enough..
> granting
What user are you at the time you are running these tests. Would I be
correct in guessing 'root'?
The reason localhost works is because, in some distros, root is
enabled localhost with no password .. which is dangerous enough..
granting root@'%" would be an invitation to disaster..
>From that sa
I've recently reloaded my box (PCLinuxOS). The machine name on the network is
photon. I've set this in the hosts table, in hostname, and on the network. in
my.cnf I have the following 2 lines:
bind-address= photon
bind-address= localhost
The "skip-networking" directive
Hi All,
How can I log user/host in the bin-log so I can get to know who from which host
did some updates on my database?
2010-06-23
xufengnju
Hi,
I plan to migrate a 32 bit MySQL installation to a 64bit host.
(mysql-5.0.77)
Both servers are RedHat EL 5.4 with the original mysql rpm.
The "simpel" plan was to shut down mysql and than copy the db-files from
/var/lib/mysql/ from host to host.
Any suggestions? Or comments? O
Can someone help me. I am trying to make calls to Mysql from VBscript via ASP
But I'm experiencing difficulties with passing host variables to mysql
See examples below
isbn =34373
sql= "select isbn, book_title, publisher_name FROM cs443.books_available where
isbn= " &isbn
T
Can someone help me. I am trying to make calls to Mysql from VBscript via=
=20ASP But I'm experiencing difficulties with passing host variables to my
SQL=20 See example below
isbn =3D 717192=20
sql=3D "select isbn, book_title, publisher_name FROM cs443.books_availabl= e
where isbn=
nnections.
>
> Regards,
> Gavin Towey
>
> -Original Message-
> From: Andrew Braithwaite [mailto:andrew.braithwa...@lovefilm.com]
> Sent: Tuesday, August 11, 2009 8:38 AM
> To: mysql@lists.mysql.com
> Subject: RE: Replication - connecting a slave to a master on the
2009 8:38 AM
To: mysql@lists.mysql.com
Subject: RE: Replication - connecting a slave to a master on the same host via
a port or socket
Ah. I have found that if you use 'localhost' to connect, you cannot
specify a port, it silently fails...
You can connect using a hostname (even though
..@lovefilm.com]
Sent: 11 August 2009 16:12
To: mysql@lists.mysql.com
Subject: Replication - connecting a slave to a master on the same host
via a port or socket
Hi,
I have 2 mysql instances running on a server on different ports with
different datadirs and different .sock files.
I can connect
Hi,
I have 2 mysql instances running on a server on different ports with
different datadirs and different .sock files.
I can connect locally via the sock with the -S flag to mysql but I
cannot connect locally via port (-P flag).
Does anyone know if there is a way to configure a mysql slave to us
Hi.
If you know chinese, I advise that you should visit the website called
http://yueliangdao0608.cublog.cn
On Sat, Jun 20, 2009 at 10:44 AM, michel wrote:
> I have MySQL set up and running, but I am under the impression that I am
> unable to password protect it properly because I can't protec
I have MySQL set up and running, but I am under the impression that I am unable
to password protect it properly because I can't protect it as root user. From
what I've been reading I should be setting it up as
mysqladmin -u root password _thepassword_
But with phpMyAdmin I can still log in as
You can set max_connect_errors=9 to "disable" the host
blocking. It's common to do this with load balancers because tcp/ip
health checks count as connection errors.
-Eric
On Sat, Apr 11, 2009 at 1:01 PM, Shawn Green wrote:
>
> Hello Gary,
>
> Gary Smith wrote
have this
bouncing across a couple different firewalls, so for some reason, the
conneciton to mysql is generating a larger number of these:
090407 12:26:42 [Warning] Aborted connection 972479 to db: 'db' user: 'user'
host: 'host' (Got an error reading communicatio
s a couple different firewalls, so for some reason, the
conneciton to mysql is generating a larger number of these:
090407 12:26:42 [Warning] Aborted connection 972479 to db: 'db' user: 'user'
host: 'host' (Got an error reading communication packets)
We do know the network
higher level than normal of bad
connections before banning the host.
What happens is that when we have 300-500 connections a few random ones
will get mucked up during a heavier than normal load on the client. I
have set the max connections to 3000 (which we never get close to).
So, if there a
before banning
the host.
What happens is that when we have 300-500 connections a few random ones will
get mucked up during a heavier than normal load on the client. I have set the
max connections to 3000 (which we never get close to).
So, if there a config/startup setting to tweak to ease
Thanks. That works great.
On 10-Mar-09, at 9:36 PM, Rob Wultsch wrote:
On Tue, Mar 10, 2009 at 7:16 PM, René Fournier
wrote:
OK, I've managed to do the same thing with just the mysql command
line
program:
mysql -h 192.168.0.224 -u root -p alba2 <
/Backup/Latest/alba2_2009-03-10_0
zcat /Backup/Latest/alba2_2009-03-10_00h45m.Tuesday.sql.gz | mysql -h
192.168.0.224 -u root -p alba2
Cheers
Claudio
2009/3/11 Rob Wultsch
> On Tue, Mar 10, 2009 at 7:16 PM, René Fournier
> wrote:
>
> > OK, I've managed to do the same thing with just the mysql command line
> > program:
> >
>
On Tue, Mar 10, 2009 at 7:16 PM, René Fournier wrote:
> OK, I've managed to do the same thing with just the mysql command line
> program:
>
>mysql -h 192.168.0.224 -u root -p alba2 <
> /Backup/Latest/alba2_2009-03-10_00h45m.Tuesday.sql
>
> Works great. However, the sql file is normally gz
info if we had
ill intents.
Sent from my Verizon Wireless BlackBerry
-Original Message-
From: Darryle Steplight
Date: Tue, 10 Mar 2009 22:20:26
To: René Fournier
Cc: mysql
Subject: Re: mysqlimport remote host problem
Hi Rene,
Just a head's up. You might want to keep your use
hat, each night, copies a small database to my laptop
>> on the local network. I'm having trouble getting it to work. Here's my
>> syntax so far (run on the server):
>>
>> mysqlimport --host=192.168.0.224 --user=root --password alba2
>> alba2_2009-03-10_00h45m.
é Fournier wrote:
I'm writing script that, each night, copies a small database to my
laptop on the local network. I'm having trouble getting it to work.
Here's my syntax so far (run on the server):
mysqlimport --host=192.168.0.224 --user=root --password alba2
alba2_2009-0
I'm writing script that, each night, copies a small database to my
laptop on the local network. I'm having trouble getting it to work.
Here's my syntax so far (run on the server):
mysqlimport --host=192.168.0.224 --user=root --password alba2
alba2_2009-03-10_00h45m.Tues
Hello,
After a system host name had changed, my organization updated the MySQL user
records, changing the old (and now non-existent) host name to the new one.
This caused any views that were created by users accessing the MtSQL server
from the old host to become invalid as the view&#
his database
User '[EMAIL PROTECTED]' should be able to run SELECTs and INSERTs
on this database
I read in the MySQL manual that between the 'db' and 'host' tables, if
the 'db.host' field is empty, MySQL will look up the 'host' table for a
list of a
t; GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0
> |> MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
> |>
> |>
> |> FLUSH PRIVILEGES ;
> |>
> |>
> |> $ mysql -h mynewserver -u testuser -p
> |> Enter password:
> |> ERROR 1045 (28000): Acce
HOUR 0
> MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
>
>
> FLUSH PRIVILEGES ;
>
>
> $ mysql -h mynewserver -u testuser -p
> Enter password:
> ERROR 1045 (28000): Access denied for user 'testuser'@'myoldserver' (using
> password: YES)
>
>
>
HOUR 0
> MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
>
>
> FLUSH PRIVILEGES ;
>
>
> $ mysql -h mynewserver -u testuser -p
> Enter password:
> ERROR 1045 (28000): Access denied for user 'testuser'@'myoldserver' (using
> password: YES)
>
>
>
ED]> wrote:
I'm also having this strange problem just as stated here, anybody find a
fix for this yet?
Again, using wildcards (%) for the Host don't work while the FQDN does from
the exact same remote machine, the exact same username, etc. There is
something about the wildcard ACL that
PM, Joe Auty <[EMAIL PROTECTED]> wrote:
> I'm also having this strange problem just as stated here, anybody find a
> fix for this yet?
>
> Again, using wildcards (%) for the Host don't work while the FQDN does from
> the exact same remote machine, the exact same usern
I'm also having this strange problem just as stated here, anybody find a
fix for this yet?
Again, using wildcards (%) for the Host don't work while the FQDN does
from the exact same remote machine, the exact same username, etc. There
is something about the wildcard ACL that is n
T01 - E-ENABLING); Raghavendra Hosabettu (WT01 -
Innovation Group)
Subject: FW: Problem - "Host 'abc.def.com' is not allowed to connect to
this MySQL server", Please advice..
Ok It means that DNS not configured so better give the IP address
instead of hsostname and check
, July 14, 2008 3:34 PM
To: Ahmadbasha Shaik (WT01 - E-ENABLING); Raghavendra Hosabettu (WT01 -
Innovation Group)
Subject: FW: Problem - "Host 'abc.def.com' is not allowed to connect to
this MySQL server", Please advice..
Ok It means that DNS not configured so better give the IP
make sure to FLUSH PRIVILAGES;
- Original Message
> From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]; mysql@lists.mysql.com
> Cc: [EMAIL PROTECTED]
> Sent: Monday, 14 July, 2008 10:59:35 AM
> Subject: RE: Problem - "Host '
ion this in my earlier
mail. Can you please let me know if there is any other way out.
Regards
Ahmad
-Original Message-
From: Parikh, Dilip Kumar [mailto:[EMAIL PROTECTED]
Sent: Monday, July 14, 2008 3:26 PM
To: Ahmadbasha Shaik (WT01 - E-ENABLING); Raghavendra Hosabettu (WT01 -
Inn
Hi All,
I am facing a particular problem which i have explained here. Can
you please let me know a solution for this.
>From my web application, I am trying to connect the MySQL server by
using the IP address as the server name, and it says the following
error:
"Host 'abc.de
Yes, I did "FLUSH PRIVILEGES" and I think I only have one username/host
entry for this user.
Adam
Erik Giberti wrote:
Did you "FLUSH PRIVILEGES"?
I'd also check that the username and passwords are the same for each
host entry, I've had problems if passwor
Did you "FLUSH PRIVILEGES"?
I'd also check that the username and passwords are the same for each
host entry, I've had problems if passwords were different for a shared
username from different hosts.
On Apr 24, 2008, at 8:58 AM, Adam Gerson wrote:
I set up a user and en
I set up a user and entered % for the host. I am not able to connect.
However, if I change the host value to my FQDN it works fine. Shouldn't
the wildcard allow me to connect from any host?
Thanks,
Adam
--
Adam Gerson
Assistant Director of Technology
Apple Certified System Administ
ou insert
> new records.
>
> Saravanan
>
>
> --- On Wed, 1/16/08, meridklt <[EMAIL PROTECTED]> wrote:
>
> > From: meridklt <[EMAIL PROTECTED]>
> > Subject: Help with HOST LOGIN PASS NAME
> > To: mysql@lists.mysql.com
> > Date: Wednesday, January 16
> Subject: Help with HOST LOGIN PASS NAME
> To: mysql@lists.mysql.com
> Date: Wednesday, January 16, 2008, 2:35 AM
> Firstly I know nothing about MySQL but had to move hosts and
> followed the
> export from old server to import to new server and all went
> well in that the
>
d I find that info.
Thanks
--
View this message in context:
http://www.nabble.com/Help-with-HOST-LOGIN-PASS-NAME-tp14845571p14845571.html
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> QUESTION: What are the most secure permissions settings for
> administrator
> access to connect to my server without using a static IP address?
Assuming a unix server (or even a windows server running SSH), use an
SSH tunnel, and then connect to 127.0.0.1:whatever_port_you_chose. You
get the e
My take on this never have no password..
At no time any data you have someone else will also want therefore
running a open query with nopasword on the system for a couple of
hours will get access to your system..
Allways use passwords, If the users dont want passwords then you dont
need any membe
Sign up for dyndns.com or some other similiar service. Create
permissions to the domain and run a script that updates you IP with
dyndns whenever it changes. (such scripts already exist).
As far as "'username'@'%' with no password with SELECT, INSERT, UPDATE
and DELETE privileges"... worst ide
QUESTION: What are the most secure permissions settings for administrator
access to connect to my server without using a static IP address?
MY ISP changes my DSL ip address almost daily so when I log on to MySQL
Administrator with 'myusername'@'currentipaddress' using password
'mypassword'
I
name (SHOW VARIABLES LIKE 'server_id') as it is unique.
Ben - just curious, why is heartbeat tied in with the server IP? Is it
monitoring the server instead of the mysql daemon to check if it's up? :)
Cheers,
Atle
On Wed, 13 Jun 2007, Scott Tanner wrote:
> There's a
There's a 'report-host' option that can be set in the conf file to
mask the host name. Sounds like this may be set.
If you want to get the server's actual host name from within mysql,
how about running a system command:
mysql> \! hostname;
or
mysql
find a way for MySQL to report the
server host name on which it's currently sitting. Without any luck.
Would any kind members know of a way of getting this information
from MySQL?
Many thanks,
Ben
Heartbeat moves the IP address around as well as the services.
Your hostname should n
round from server to server when a
failure occures. I am trying to find a way for MySQL to report the
server host name on which it's currently sitting. Without any luck.
Would any kind members know of a way of getting this information
from MySQL?
Many thanks,
Ben
Heartbeat moves the
erver when a failure
occures. I am trying to find a way for MySQL to report the server
host name on which it's currently sitting. Without any luck.
Would any kind members know of a way of getting this information from
MySQL?
Many thanks,
Ben
Heartbeat moves the IP address around as w
s. I am trying to find a way for MySQL to report the server
host name on which it's currently sitting. Without any luck.
Would any kind members know of a way of getting this information from
MySQL?
Many thanks,
Ben
Heartbeat moves the IP address around as well as the services.
You
erver
host name on which it's currently sitting. Without any luck.
Would any kind members know of a way of getting this information from
MySQL?
I only know of two ways, though there may be more.
1) The hostname system variable, which was added in 5.0.41
(http://dev.mysql.com/doc/ref
a way for MySQL to report the server host
name on which it's currently sitting. Without any luck.
Would any kind members know of a way of getting this information from
MySQL?
Many thanks,
Ben
Heartbeat moves the IP address around as well as the services.
Your hostname should
ind a way for MySQL to report the server host
name on which it's currently sitting. Without any luck.
Would any kind members know of a way of getting this information from
MySQL?
I only know of two ways, though there may be more.
1) The hostname system variable, which was added in 5.0
eport the server host
name on which it's currently sitting. Without any luck.
Would any kind members know of a way of getting this information from MySQL?
Many thanks,
Ben
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.
Hi Andreas,
On the local host using mysql database. Execute the following command at
mysql prompt:
Mysql>grant all privileges on [database_name].* to 'user'@'remote_host'
identified by 'password'
Please read more about this at
http://dev.mysql.com/doc/ref
You ought to look at the field Host in the table Users In the db Mysql. This
field set from where this user can access. If you put a % simbol in it the
user could access from any host, or if this user can access only from on
host, you must put in this field the IP of the host.
Hope help
Hello,
I have a mysql DB running on a Windows XP machine.
I can access it locally via mysql command, I have also a ODBC driver
installed and the test says it works ok.
When I try to connect from a remote host via JDBC I get the error
message that this host is not allowed to access the db
\msentissi>mysql -u root -h 192.168.3.60
ERROR 1130 (0): Host '192.168.3.10' is not allowed to connect to this MySQL
server
I looked for the my.cnf file and it is nowhere to be found ? some guidance please.
Thanks
Simo Sentissi
Collaboration Networks
406-579-8256
The
oot -h 192.168.3.60
ERROR 1130 (0): Host '192.168.3.10' is not allowed to connect to this MySQL
server
I looked for the my.cnf file and it is nowhere to be found ? some guidance
please.
Thanks
Simo Sentissi
Collaboration Networks
406-579-8256
--
MySQL General Mailing List
For
Better late than never
I believe the reason is because (at least on unix) if you connect to a
database on the same machine (using -h localhost or just omitting the
host) it will use the socket -- and therefore saying "host=localhost"
is like saying "if they come from the unix
fore asking more stupid questions.
On Jun 14, 2006, at 11:55 AM, James Barros wrote:
Hey guys, I'm running mysql 5.1.9 and I've got a user who's
mysql.user host is set to "%" and can log in from any domain except
localhost. if I change to localhost, and flush privileges th
rote:
Hey guys, I'm running mysql 5.1.9 and I've got a user who's
mysql.user host is set to "%" and can log in from any domain except
localhost. if I change to localhost, and flush privileges they can
log in.
Is this intended behavior, or should % be inclusiv
Hey guys, I'm running mysql 5.1.9 and I've got a user who's
mysql.user host is set to "%" and can log in from any domain except
localhost. if I change to localhost, and flush privileges they can
log in.
Is this intended behavior, or should % be inclusive of local
Takanobu Kawabe schrieb:
>
> Hello, my name is Takanobu Kawabe.
>
> I use MySQL 4.1.19 server now.
> I don't know how to set Host table in mysql database.
>
> For db table,tables_priv table and so on, can set using GRANT SQL
> statement.
>
> Can I
Hello, my name is Takanobu Kawabe.
I use MySQL 4.1.19 server now.
I don't know how to set Host table in mysql database.
For db table,tables_priv table and so on, can set using GRANT SQL
statement.
Can I use this statement for setting Host table?
If I can, what
I am not really sure why you would need this , but I am just throwing in
a possible solution..
First I would say since you need to kill connections on a specific
interface (eth0), It would be fair to assume that you have more than one
interface, if thats the case and you don't have the "--bind
On 4/28/06, Dominik Klein <[EMAIL PROTECTED]> wrote:
Hi
I'd like to know if there is anything to kill connections from a
specific client ip that came to the server on a specific interface.
I do not want to block them on layer 2 (which could easily be done with
netfilter), I would like to be abl
Hi
I'd like to know if there is anything to kill connections from a
specific client ip that came to the server on a specific interface.
I do not want to block them on layer 2 (which could easily be done with
netfilter), I would like to be able to kill active connections.
For example: I would
Hi all -
I'm looking for a way to have a group of mysql servers that are all slaves
to a single master. That part I can do.
However, what I'd like is a way to put another server in front of the
entire cluster and have that pretend to be the mysql database, except that
it would simply redire
In mysql-5.1-reference manual:
Each data node is usually located on a separate computer. However, it
is also possible to host multiple data nodes on a single computer
having more than one processor. In such cases, it is feasible to run
one instance of ndbd per physical CPU. (Note that a processor
IP should work just fine. However, if the source webserver is behind a
firewall or otherwise NAT'd, your mysql server may see them coming from an
in between IP instead of the actual webserver. The quickest way to figure
it out is to have the webserver host try to connect and send you the
Little confused, can not seem to locate the docs on this. Trying to set up
mysql to allow a remote webserver to talk to it, using a user/pass/host
setting with host set to allow anything, of course works.
If the IP I am connecting from has a valid PTR, I can use the hostname as
well, and that
--- Peter Brawley <[EMAIL PROTECTED]> wrote:
> Angelo,
>
> >Upload the data
>
> If phpMyAdmin is your only access to your webhost
> db, you can paste the
> contents of your local dump.sql into phpMyAdmin's
> SQL window, and run it
> (all at once, or piece by piece).
>
> PB
Hello Peter. Tha
IK MySQL does not provide upgrade scripts to any
version, so if there
is a version difference between your internal and
web hosts, you may
have to make adjustments to the script which
mysqldump generates.
Thankyou for the reply Peter.
What I am trying to do copy data from a local ho
the reply Peter.
What I am trying to do copy data from a local host to
my webhost server. I will make sure the local host is
always the same version, I didn't think of that :)
Here is what I have so far -
Dump the data
mysqldump -q -uusername -ppassword mydbname > dump.sql
Upload the da
to copy (replicate?) to an external webhost. I do
not have shell access to the remote host which is why
I cannot perform proper replication. How should I go
about doing this?
Is there any scripts that people know of that can be
called from cron that I can use to copy the latest
database to the
Hello List. I have an internal MySQL db that I would
like to copy (replicate?) to an external webhost. I do
not have shell access to the remote host which is why
I cannot perform proper replication. How should I go
about doing this?
Is there any scripts that people know of that can be
called
ixed. See below
>>
>> "Xiaobo Chen" <[EMAIL PROTECTED]> wrote on 11/03/2005 04:28:08 PM:
>> > Thank so much for the detailed explaination. I do appreciate it.
>> >
>> > It's more clear now. But I still have a question:
>> >
&g
iaobo Chen" <[EMAIL PROTECTED]> wrote on 11/03/2005 04:28:08 PM:
>
>> Thank so much for the detailed explaination. I do appreciate it.
>>
>> It's more clear now. But I still have a question:
>>
>> I do see 'root' after: select user,host f
ow
>
> "Xiaobo Chen" <[EMAIL PROTECTED]> wrote on 11/03/2005 04:28:08 PM:
> > Thank so much for the detailed explaination. I do appreciate it.
> >
> > It's more clear now. But I still have a question:
> >
> > I do see 'root' a
Answers intermixed. See below
"Xiaobo Chen" <[EMAIL PROTECTED]> wrote on 11/03/2005 04:28:08 PM:
> Thank so much for the detailed explaination. I do appreciate it.
>
> It's more clear now. But I still have a question:
>
> I do see 'root' after:
Thank so much for the detailed explaination. I do appreciate it.
It's more clear now. But I still have a question:
I do see 'root' after: select user,host from mysql.user;
Then I did this as you said:
GRANT SELECT ON mydatabase.* TO [EMAIL PROTECTED] IDENTIFIED BY 'mypass
"Xiaobo Chen" <[EMAIL PROTECTED]> wrote on 11/03/2005 02:54:16 PM:
> I have a question related to connection control.
>
> If I want to connect to one database A in the server from another
> computer. I am using 'root' and it password. But how shall I a
I have a question related to connection control.
If I want to connect to one database A in the server from another
computer. I am using 'root' and it password. But how shall I add the host
in which table of which database (mysql?) so that the user 'root' can
connect to the
ser to a database and table on a remote host.
>
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ /
Can someone please tell me what the command would look like to grant access
for the root user to a database and table on a remote host.
Thanks in advance
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: 27 October 2005 23:12
To: mysql@lists.mysql.com
Subject: Re
Miguel Cardenas wrote:
Hello list
I have a doubt... Do I need to set a password to a user for each host the user
has permission to connect from?
To mysql, a user is '[EMAIL PROTECTED]'. That is, [EMAIL PROTECTED] and [EMAIL PROTECTED] are
two different users from mysql'
Hello list
I have a doubt... Do I need to set a password to a user for each host the user
has permission to connect from?
Let's supose
// add user 'somebody'
GRANT ALL PRIVILEGES ON *.* TO somebody@"192.168.0.%" IDENTIFIED BY 'onepass';
if I want 'so
essage -
From: "Stanton, Brian" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, April 27, 2005 2:07 PM
Subject: RE: host info
The 'Connection' output from the 'status' command is actually what I was
looking for. However, most likely it will be a jdbc connection to m
1 - 100 of 336 matches
Mail list logo
