>>> 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
> Date: Sat, 19 Apr 2008 20:06:49 +0200
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> CC: mysql@lists.mysql.com
> Subject: Re: Granting users localhost access
>
> Hi Pam,
>
> If you want to grant a specific user remote access i.e. from a shell or
> from an application that resides on a
> > I am sorry I do not understand you.> > > > If I Flush privilages, will this
> > flush all privilages for the user?> > If so, I can not do that because
> > these users> > are already used to log into an existing database via a
> > functioning php script and have> > privilages to edit tables,
> > OK I tried running:> > > > update mysql.user set host = 'locahost' where
> > user = 'AUserName';> > Substituting AUserName for a real username,> > > >
> > got the return:> > > > Query OK, 0 rows affected (0.00 sec)> > Rows
> > matched: 1 Changed: 0 Warnings: 0> > > > and I tried to login an
> This should do the trick:
> update mysql.user set host = 'locahost' where user = 'username'
>
Hi Thanks,
OK I tried running:
update mysql.user set host = 'locahost' where user = 'AUserName';
Substituting AUserName for a real username,
got the return:
Query OK, 0 rows affected (0.00 sec)
Ro
How do I grant users, who already have a password, localhost
access? I don’t want to change their passwords at this time.
_
Use video conversation to talk face-to-face with Windows Live Messenger.
http://www.windowslive.com/messenger
>> 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
> 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.
> 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
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
Hi,
Is there a way to view mysql user passwords once logged in as the MySQL root
user in v 5.0.22? Or are they encrypted even from the MySQL toot user?
_
More immediate than e-mail? Get instant access with Windows Live Messenger.
13 matches
Mail list logo
