>>> The ANSI-SQL syntax is to just use GRANT to create users. You will
>>> still need to use GRANT twice for both users: joe@'%' and joe@'localhost'.
>>>
>>> But I find the MySql syntax for creating user with CREATE USER and then
>>> GRANT easier to follow:
>>>
>>> CREATE USER joe@'%' IDENTIFIE
Pam Astor wrote:
The ANSI-SQL syntax is to just use GRANT to create users. You will
still need to use GRANT twice for both users: joe@'%' and joe@'localhost'.
But I find the MySql syntax for creating user with CREATE USER and then
GRANT easier to follow:
CREATE USER joe@'%' IDENTIFIED BY
>> One more thing, I have already created these users and don't want to mess
>> their
>> passwords up or break their associated php scripts access.
>>
>> So how do I grant users, who already have a password, localhost
>> access?
>
> just copy the row in the mysql table
>
> --
> Sebastian Mend
> The ANSI-SQL syntax is to just use GRANT to create users. You will
> still need to use GRANT twice for both users: joe@'%' and joe@'localhost'.
>
> But I find the MySql syntax for creating user with CREATE USER and then
> GRANT easier to follow:
>
> CREATE USER joe@'%' IDENTIFIED BY 'whatev
Pam Astor wrote:
A user in MySql is not just a username, but a username and a host.
The host of '%' denotes all hosts accept 'localhost'.
Therefore you usually require two entries for each user:
CREATE USER ben@'%' INDENTIFIED BY 'ben';
CREATE USER ben@'localhost' INDENTIFIED BY 'ben';
Does
> A user in MySql is not just a username, but a username and a host.
>
> The host of '%' denotes all hosts accept 'localhost'.
>
> Therefore you usually require two entries for each user:
>
> CREATE USER ben@'%' INDENTIFIED BY 'ben';
> CREATE USER ben@'localhost' INDENTIFIED BY 'ben';
>
> Does
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> would be much more easier if you would send this output here (with faked
> names, passwords and hosts ...)
OK...here it is:
SELECT * from mysql.
A user in MySql is not just a username, but a username and a host.
The host of '%' denotes all hosts accept 'localhost'.
Therefore you usually require two entries for each user:
CREATE USER ben@'%' INDENTIFIED BY 'ben';
CREATE USER ben@'localhost' INDENTIFIED BY 'ben';
Does this help?
Ben
P
Pam Astor schrieb:
connectiong from shell means connecting as localhost by default, connecting
from PHP can be some different server and/or PHP uses the full IP
address/hostname of the server
check/compare the privileges for your users for 'localhost' and '%'
[...]
The seventh line shows th
> connectiong from shell means connecting as localhost by default, connecting
> from PHP can be some different server and/or PHP uses the full IP
> address/hostname of the server
>
> check/compare the privileges for your users for 'localhost' and '%'
I ran “SELECT * from mysql.user;” the com
Pam Astor schrieb:
Hi,
I have about a half dozen small databases associated with a
couple of small shopping carts, discussion forums, etc. All six databases have
usernames and
passwords associated with them, and all the databases are connected to the php
based forums and shopping carts, no pro
Hi,
I have about a half dozen small databases associated with a
couple of small shopping carts, discussion forums, etc. All six databases have
usernames and
passwords associated with them, and all the databases are connected to the php
based forums and shopping carts, no problems wi
12 matches
Mail list logo