There are permissions that are set for users and have to be set for access
over the network.
By default localhost can access it for specified users and you GRANT
access to users, hosts, db combinations.
Check mysql's documentation, for GRANT syntax
Ex., GRANT SELECT ON dbnam.* TO [EMAIL
Not a problem!
Do look into the database mysql after you log in. There are different
privileges that you assign to different users and hosts on databases.
GRANT and REVOKE are used for access control on databases / tables /
columns.
Regards
Aman Raheja
http://www.techquotes.com
On Mon,
]
Sent: Friday, December 06, 2002 5:06 PM
Subject: RE: mysql port number
show variables
that will show you what you need.
you can use a like statement, because there is a lot of stuff
hope that helps
brian
-Original Message-
From: Mike At Spy [mailto:[EMAIL PROTECTED]]
Sent: Friday
Actually, I do google searches first before asking on any list - and it
didn't turn up a darn thing.
-Mike
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 04, 2002 6:19 PM
To: Mike At Spy
Cc: [EMAIL PROTECTED]
Subject: Re: mysql port
04, 2002 6:19 PM
To: Mike At Spy
Cc: [EMAIL PROTECTED]
Subject: Re: mysql port number
On Wed, Dec 04, 2002 at 12:04:52PM -0500, Mike At Spy wrote:
How can I tell what port number mysql is running on? I need it
for a chat
program. :)
3306
A google search would have found
show variables
that will show you what you need.
you can use a like statement, because there is a lot of stuff
hope that helps
brian
-Original Message-
From: Mike At Spy [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 06, 2002 9:51 AM
To: [EMAIL PROTECTED]
Subject: RE: mysql port
On 12/4/02 9:04 AM, Mike At Spy [EMAIL PROTECTED] wrote:
How can I tell what port number mysql is running on? I need it for a chat
program. :)
Thanks,
-Mike
Default is 3306
/h
-
Before posting, please check:
Show Variables Like 'port';
PB
-
How can I tell what port number mysql is running on? I need it for a chat
program. :)
Thanks,
-Mike
-
Before posting, please check:
http://www.mysql.com/manual.php
On Wed, Dec 04, 2002 at 12:04:52PM -0500, Mike At Spy wrote:
How can I tell what port number mysql is running on? I need it for a chat
program. :)
3306
A google search would have found the answer in no time.
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL
mysql show variables;
3306 is the default.
-Original Message-
From: Mike At Spy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 04, 2002 9:05 AM
To: [EMAIL PROTECTED]
Subject: mysql port number
How can I tell what port number mysql is running on? I need it for a chat
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 4 Dec 2002, R. Hannes Niedner wrote:
On 12/4/02 9:04 AM, Mike At Spy [EMAIL PROTECTED] wrote:
How can I tell what port number mysql is running on? I need it for a chat
program. :)
Default is 3306
And with -P=123 or --port=123
'status' will show that.
- Original Message -
From: Laura Findley [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Friday, June 14, 2002 1:44 PM
Subject: MySQL port # ?
Does anyone know how to determine what port MySQL is using?
I need to know the port so that I can use it in
Take a look in the my.cnf file.
-Original Message-
From: Laura Findley [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 14, 2002 2:45 PM
To: MySQL List
Subject: MySQL port # ?
Does anyone know how to determine what port MySQL is using?
I need to know the port so that I can use it in a
default port is 3306, or look in the my.cnf
and if that doesn't work, since your using outlook, i'm guessing your on
windows, you can goto a command line and type
netstat -a
and see what ports are being used, and try those.
On Friday 14 June 2002 3:44, Laura Findley wrote:
Does anyone know
At 16:44 -0400 6/14/02, Laura Findley wrote:
Does anyone know how to determine what port MySQL is using?
I need to know the port so that I can use it in a JDBC connection URL.
Any suggestions on how to get this info?
mysql SHOW VARIABLES LIKE 'port';
+---+---+
| Variable_name |
On 14/6/02 at 16:44, [EMAIL PROTECTED] (Laura Findley) wrote:
Does anyone know how to determine what port MySQL is using?
I need to know the port so that I can use it in a JDBC connection URL.
Any suggestions on how to get this info?
I believe `\s' is the command you need (without the
telnet your.mysql.server 3306
On Tue, 5 Jun 2001, sanborn wrote:
How is MySQL used over a network? I assume there is a port involved, and
some kind of transaction server built into mysql? How do I configure, test
this? In the several documents I have read so far, I haven't found much on
I would suggest you obtain a book on the subject, or visit mysql.com and
read the documents under documentation. You are asking questions that
have very large answers. To get you started, MySQL is accessed over the
web by using a scripting language like PHP or Perl.
-Ken
At 07:35 PM 6/5/01
Default mysql port is 3306.
Tyler
-Original Message-
From: sanborn [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 05, 2001 9:36 PM
To: MySQL Mailing List
Subject: MySQL Port number
How is MySQL used over a network? I assume there is a port involved, and
some kind of
On 6/5/01 7:35 PM, sanborn [EMAIL PROTECTED] wrote:
How is MySQL used over a network? I assume there is a port involved, and
some kind of transaction server built into mysql? How do I configure, test
this? In the several documents I have read so far, I haven't found much on
the subject.
At 7:35 PM -0700 6/5/01, sanborn wrote:
How is MySQL used over a network? I assume there is a port involved, and
some kind of transaction server built into mysql? How do I configure, test
this? In the several documents I have read so far, I haven't found much on
the subject. Thanks for your
21 matches
Mail list logo