473,398 Members | 2,188 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,398 software developers and data experts.

dumb syntax question

Hi,
I apologize for my ignorance. I'm trying to execute a GRANT
statement giving select to us**@host-host.domainname.
Mysql doesn't like the dash in the hostname, or the dots in an ip.
I tried various combinations of single and double quotes, but I can't get
it to work.
What is the proper syntax. I would appreciate a straight answer- I already
have the FM.

Mike
Jul 20 '05 #1
2 1272
fonzz wrote:
Hi,
I apologize for my ignorance. I'm trying to execute a GRANT
statement giving select to us**@host-host.domainname.
Mysql doesn't like the dash in the hostname, or the dots in an ip.
I tried various combinations of single and double quotes, but I can't get
it to work.
What is the proper syntax. I would appreciate a straight answer- I already
have the FM.


For example:

grant select on databasename.* to user@'host-host.domainname';

or:

grant select on databasename.* to user@'192.168.0.4' identified by
'password';
Jul 20 '05 #2
fonzz wrote:
Hi,
I apologize for my ignorance. I'm trying to execute a GRANT
statement giving select to us**@host-host.domainname.
Mysql doesn't like the dash in the hostname, or the dots in an ip.
I tried various combinations of single and double quotes, but I can't get
it to work.
What is the proper syntax. I would appreciate a straight answer- I already
have the FM.


For example:

grant select on databasename.* to user@'host-host.domainname';

or:

grant select on databasename.* to user@'192.168.0.4' identified by
'password';
Jul 20 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Raymond Arthur St. Marie II of III | last post by:
very Very VERY dumb ? about the new Set( ) 's Please be kind and read this like you know I've been up 33-34 hours reading PEP's but... Doc\ref 2.6 Delimiters show's three unused characters "@...
1
by: | last post by:
Hi, I apologize for my ignorance. I'm trying to execute a GRANT statement giving select to user@host-host.domainname. Mysql doesn't like the dash in the hostname, or the dots in an ip. I tried...
4
by: sigi | last post by:
i've got something like this in a headerfile: const char* const StringList= { "FirstString", "SecondString", .... } (haven't checked the syntax yet, but i guess it's ok?)
9
by: Bob Stearns | last post by:
I have a (somewhat complicated) query that returns the rows from a table and its self join in the correct order. I want to call a procedure on each of the returned rows, in the order returned. Is...
11
by: dhnriverside | last post by:
Hi peeps Ok, so I thought I'd have a go at making a console app in VS2k5... I haven't written any windows apps for years, let alone dos apps (been web programming) and I've hit a dumb error... ...
14
by: Bill Nguyen | last post by:
what's the equivalent syntax for app.path in VB.NET? Thanks Bill
2
by: Bill Nguyen | last post by:
I would like to add a new VB.NET project using the same folder being used by another project so that I can share several forms already creaded by the other project. However, .NET created a new...
1
by: Chris | last post by:
Dumb question about c# web services Posted on: 11/30/2005 12:14:16 Ok guys, here is what I am trying to do or what I need to know. I am creating a webservice called db_update. This...
1
by: Peter Hunt | last post by:
Hi everyone - I like playing around with language syntax and semantics. I'm thinking about pulling down the PyPy code and messing around to see what I can accomplish. My first idea is most...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.