Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
From: Ben Clewett (benclewett.org.uk)
Date: Fri Apr 18 2008 - 08:33:04 CDT
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?
Pam Astor wrote:
>> 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 command generated a
> list. For root it showed in the host
> column local host, the second row for root showed the name of the web server
> the mysql install is on. The third and
> fourth rows showed no users, however the third and fourth rows showed in the
> host columns localhost and the server name, respectively.
> The fifth and sixth lines showed the first non root user I created
> and for this user it showed in the host Colum the % character, and the other
> line for this user showed localhost as the host.
> The seventh line shows the second non root user I created –
> it has just one line and shows localhost as the host. All the rest of the users I created show the
> % character in the host column.
> No IP addresses are listed anywhere.
> More immediate than e-mail? Get instant access with Windows Live Messenger.
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql