Jaspreet Singh wrote:
The problem is that MySQL users can only be 16 chars loong (bad !!) and
cannot have '@' or '#' in the name.
If you think 16 characters is not enough, you can file this as a bug/feature
request at http://bugs.mysql.com
Is there a way out ... Is there a way so that i can
At 12:53 + 5/1/04, shaun thornburgh wrote:
Hi,
I have just installed MySQL on Windows 2000, after inspecting the
mysql users table I have noticed that there are four users:
Host User
localhost root
gcw root
% root
gcw
Three of the accounts have a root name and one ha
your hostname ?
-Original Message-
From: shaun thornburgh [mailto:[EMAIL PROTECTED]
Sent: Saturday, May 01, 2004 10:53 PM
To: [EMAIL PROTECTED]
Subject: MySQL Users Table
Hi,
I have just installed MySQL on Windows 2000, after inspecting the mysql
users table I have noticed that there ar
hing in DB table and restart.
Hope this helps.
Thanks
Emery
- Original Message -
From: "m i l e s" <[EMAIL PROTECTED]>
To: "Director General: NEFACOMP" <[EMAIL PROTECTED]>
Sent: Saturday, November 29, 2003 02:26
Subject: Re: MySQL users.
> Emeyr
>
Use GRANT ___your_permissions on database[s] to 'username'@'%'
IDENTIFIED BY 'his/her password'
% will be used if you don't want to restrict that user on a given host or
network
Otherwise, use 'username'@'host_name_or_ip_address' like
'emery'@'192.168.0.50'
if you omit the @ part, MySQL will
Thanks for the quick reply Simon!
I checked in the file, and just as you said the info was there. No, I
actually solved the problem myself shortly after setting up phpMyAdmin
from sourceforge.net Top notch little software package there(free too)!
For newbies like me, it works out great, hopef
Look in db mysql.user to see what users can do what.
GRANT ALL ON *.* TO user@% IDENTIFIED BY "password";
Simon
-Original Message-
From: Unix Newbie [mailto:[EMAIL PROTECTED]]
Sent: 24 April 2002 10:15
To: [EMAIL PROTECTED]
Subject: Mysql users setup.
Hello all!
I am just starti
Marnix,
Friday, April 05, 2002, 10:15:56 AM, you wrote:
MV> I am setting up a mysql database and have a questions about users.
MV> I would like everybody to have the possibility to consult the database
MV> without having to introduce a user and /or password (even not showing the
MV> screen for us
