I'm a newbie in mysql and I've a question about user definition in
Mysql.
According to informations collected from manuals I believed that a
user definition specifying host="%" on mysql server 'A' granted me
connection from whatever client (with command "mysql -hA -uuser -p");
but executing that command from server, to say, 'B', mysql denies
access to user@B. The matter can be solved defining a new user with
host B (it's to say user@B), but, in that case what's the meaning of a
generic user@%?
Thanks
Andrea Paventi 6 4973
Lord Asriel wrote: I'm a newbie in mysql and I've a question about user definition in Mysql. According to informations collected from manuals I believed that a user definition specifying host="%" on mysql server 'A' granted me connection from whatever client (with command "mysql -hA -uuser -p"); but executing that command from server, to say, 'B', mysql denies access to user@B. The matter can be solved defining a new user with host B (it's to say user@B), but, in that case what's the meaning of a generic user@%?
I've been bothered by the same behavior even though http://www.mysql.com/doc/en/GRANT.html seems to imply that it is doable:
In order to accommodate granting rights to users from arbitrary
hosts, MySQL supports specifying the |user_name| value in the form
|user@host|. If you want to specify a |user| string containing
special characters (such as `-'), or a |host| string containing
special characters or wildcard characters (such as `%'), you can
quote the user or host name (for example,
|'test-user'@'test-hostname'|).
You can specify wildcards in the hostname. For example,
|user@'%.loc.gov'| applies to |user| for any host in the |loc.gov|
domain, and |user@'144.155.166.%'| applies to |user| for any host in
the |144.155.166| class C subnet.
The simple form |user| is a synonym for |user@"%"|.
Don't know why it doesn't work for you and me.
--
I have seen the truth and it makes no sense.
Lord Asriel wrote: I'm a newbie in mysql and I've a question about user definition in Mysql. According to informations collected from manuals I believed that a user definition specifying host="%" on mysql server 'A' granted me connection from whatever client (with command "mysql -hA -uuser -p"); but executing that command from server, to say, 'B', mysql denies access to user@B. The matter can be solved defining a new user with host B (it's to say user@B), but, in that case what's the meaning of a generic user@%?
I've been bothered by the same behavior even though http://www.mysql.com/doc/en/GRANT.html seems to imply that it is doable:
In order to accommodate granting rights to users from arbitrary
hosts, MySQL supports specifying the |user_name| value in the form
|user@host|. If you want to specify a |user| string containing
special characters (such as `-'), or a |host| string containing
special characters or wildcard characters (such as `%'), you can
quote the user or host name (for example,
|'test-user'@'test-hostname'|).
You can specify wildcards in the hostname. For example,
|user@'%.loc.gov'| applies to |user| for any host in the |loc.gov|
domain, and |user@'144.155.166.%'| applies to |user| for any host in
the |144.155.166| class C subnet.
The simple form |user| is a synonym for |user@"%"|.
Don't know why it doesn't work for you and me.
--
I have seen the truth and it makes no sense.
Lord Asriel wrote: I'm a newbie in mysql and I've a question about user definition in Mysql. According to informations collected from manuals I believed that a user definition specifying host="%" on mysql server 'A' granted me connection from whatever client (with command "mysql -hA -uuser -p"); but executing that command from server, to say, 'B', mysql denies access to user@B. The matter can be solved defining a new user with host B (it's to say user@B), but, in that case what's the meaning of a generic user@%?
I've been bothered by the same behavior even though http://www.mysql.com/doc/en/GRANT.html seems to imply that it is doable:
In order to accommodate granting rights to users from arbitrary
hosts, MySQL supports specifying the |user_name| value in the form
|user@host|. If you want to specify a |user| string containing
special characters (such as `-'), or a |host| string containing
special characters or wildcard characters (such as `%'), you can
quote the user or host name (for example,
|'test-user'@'test-hostname'|).
You can specify wildcards in the hostname. For example,
|user@'%.loc.gov'| applies to |user| for any host in the |loc.gov|
domain, and |user@'144.155.166.%'| applies to |user| for any host in
the |144.155.166| class C subnet.
The simple form |user| is a synonym for |user@"%"|.
Don't know why it doesn't work for you and me.
--
I have seen the truth and it makes no sense.
> I've been bothered by the same behavior even though http://www.mysql.com/doc/en/GRANT.html seems to imply that it is doable:
In order to accommodate granting rights to users from arbitrary hosts, MySQL supports specifying the |user_name| value in the form |user@host|. If you want to specify a |user| string containing special characters (such as `-'), or a |host| string containing special characters or wildcard characters (such as `%'), you can quote the user or host name (for example, |'test-user'@'test-hostname'|).
You can specify wildcards in the hostname. For example, |user@'%.loc.gov'| applies to |user| for any host in the |loc.gov| domain, and |user@'144.155.166.%'| applies to |user| for any host in the |144.155.166| class C subnet.
The simple form |user| is a synonym for |user@"%"|.
Don't know why it doesn't work for you and me.
Thanks for your answer even though it doesn't solve the problem it
gives me a hint: I'm going to try defining a "user@%.mydomain.it";
let's see if it works
Andrea Paventi
> I've been bothered by the same behavior even though http://www.mysql.com/doc/en/GRANT.html seems to imply that it is doable:
In order to accommodate granting rights to users from arbitrary hosts, MySQL supports specifying the |user_name| value in the form |user@host|. If you want to specify a |user| string containing special characters (such as `-'), or a |host| string containing special characters or wildcard characters (such as `%'), you can quote the user or host name (for example, |'test-user'@'test-hostname'|).
You can specify wildcards in the hostname. For example, |user@'%.loc.gov'| applies to |user| for any host in the |loc.gov| domain, and |user@'144.155.166.%'| applies to |user| for any host in the |144.155.166| class C subnet.
The simple form |user| is a synonym for |user@"%"|.
Don't know why it doesn't work for you and me.
Thanks for your answer even though it doesn't solve the problem it
gives me a hint: I'm going to try defining a "user@%.mydomain.it";
let's see if it works
Andrea Paventi
> I've been bothered by the same behavior even though http://www.mysql.com/doc/en/GRANT.html seems to imply that it is doable:
In order to accommodate granting rights to users from arbitrary hosts, MySQL supports specifying the |user_name| value in the form |user@host|. If you want to specify a |user| string containing special characters (such as `-'), or a |host| string containing special characters or wildcard characters (such as `%'), you can quote the user or host name (for example, |'test-user'@'test-hostname'|).
You can specify wildcards in the hostname. For example, |user@'%.loc.gov'| applies to |user| for any host in the |loc.gov| domain, and |user@'144.155.166.%'| applies to |user| for any host in the |144.155.166| class C subnet.
The simple form |user| is a synonym for |user@"%"|.
Don't know why it doesn't work for you and me.
Thanks for your answer even though it doesn't solve the problem it
gives me a hint: I'm going to try defining a "user@%.mydomain.it";
let's see if it works
Andrea Paventi This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: John R |
last post by:
I found this old thread while looking for some type of compression
solution myself. Long story short, I contacted Lester and ended up
writing an LZO solution just as Mark had mentioned below....
|
by: David |
last post by:
Hi,
I have a quick question.
I have a .asp application in which certain parts, clients can now
edit/update/add information to their records in our DB.
I basically use an include statement at...
|
by: Sai Hertz And Control Systems |
last post by:
Dear all,
Their was a huge rore about MySQL recently for something in java functions
now theirs one more
http://www.mysql.com/doc/en/News-5.0.x.html
Does this concern anyone.
What I...
|
by: AnhTai |
last post by:
Hi all,
I've just installed MySQL 5.0 on my sun box (runing Solaris 10, install
from blastwave). This is my first time with MySQL so I don't have any
exp with it.
I have some troubles as:
-...
|
by: Atli |
last post by:
This is an easy to digest 12 step guide on basics of using MySQL. It's a great refresher for those who need it and it work's great for first time MySQL users.
Anyone should be able to get...
|
by: JamieHowarth0 |
last post by:
I have been trying to find a solution to this on the Internet for months. Literally, ages and ages and ages, praying that someone in the open-source community has enough knowledge to put together an...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
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...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
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...
|
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,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
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...
|
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,...
| |