On Monday, March 28, 2005 15:07, Philippe Reynolds wrote:
> Hi,
>
> I've just create an account and given it all privileges for
> "database_name.*". However when I try to 'load data infile' it
> tell's me that the account doesn't permit it.
>
> When I use the 'root' account everything is fine.
Thanks Paul.
Fully understand!!
cheers,
feng
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Wang Feng" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, October 06, 2003 4:38 AM
Subject: Re: mysql account
> At 14:00
At 14:00 +1000 10/5/03, Wang Feng wrote:
> If you deleted the rows with a DELETE statement, you'll need to also
issue a FLUSH PRIVILEGES statement to cause the server to reread the
grant tables.
In order to try the FLUSH PRIVILEGES statement, I inserted a new user
account into the 'user' table o
Paul,
> I am assuming that the 'alan' account that you're planning to use has
> all privileges. Otherwise, you will find after flushing the privileges
> that you'll no longer be able to administer your server without starting
> it with the --skip-grant-tables option...
The *alan* account does h
e -
From: "Thada, Shantalaxmi (NIH/CC/PET)" <[EMAIL PROTECTED]>
To: "'Wang Feng '" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, October 05, 2003 5:57 AM
Subject: RE: mysql account
>
> do u have a .my.cnf in c:\ dir or c:\windows d
At 4:35 +1000 10/5/03, Wang Feng wrote:
Hi, folks.
I use WinXP + MySQL.
I deleted all the rows from the 'user' table of the 'mysql' database except
my own account (host: localhost, user: alan, password:alan). --- I was
hoping only I have the access to the MySQL databases.
The problem is that I st
do u have a .my.cnf in c:\ dir or c:\windows dir ? from DOS when
u issue a mysql command it usually picks up the username and password from
the .my.cnf file.
- Shanta
-Original Message-
From: Wang Feng
To: [EMAIL PROTECTED]
Sent: 10/4/2003 2:35 PM
Subject: mysql account
Hi, folks.
I
On Tuesday 31 July 2001 08:40, [EMAIL PROTECTED] wrote:
> say i am running a server with mysql and phpmyadmin and i have some
> dbs (including of course the mysql db)...
>
> so when someone says to "set them up a 'MySQL account'" what exactly
> do they mean? and how do i do it?
In alomost all cas
