PhpMyAdmin is good, of course, but you see, it really hides a lot of
details that you'll step on while you're a developer, it would be good
if you learn the commands (console, SQL) instead of using this kind of
wizard. Even if your machine isn't the server, you can install the
client and connect to the database via console. The command "grant all
privileges on *.* to 'jf'" might work... To import data, the command
"load data infile" is a good way.
Best regards,
On Sun, 21 Nov 2004 13:07:28 +1100, John Fitzsimons
<johnf@stripped> wrote:
>
> Hi,
>
> I still haven't solved my "1044 Access Denied" error...
>
> http://www.aspects.org.au/sqdb4.jpg
>
> even though Randy suggested that some edition of phpMyAdmin might
> have a 'Privileges' tab that could be the answer.
>
> As can be seen at ;
>
> http://www.aspects.org.au/sun1.jpg
>
> There is no 'Privileges' tab. :-(
>
> I thought however that someone here might be able to at least tell me
> whether I am taking the correct steps to importing data into a
> database and creating a table from it. Here are the steps I take....
>
> (A) I go to phpMyAdmin 2.6.0
>
> (B) Then double Click on my database jf_invcomma
>
> (C) Then click on SQL tab.
>
> (D) Where it says "Location of the textfile" I browse to my .sql
> tables file on my PC.
>
> (E) I then press "go"
>
> Does anyone know whether these are the correct steps please ?
> Or perhaps know a solution to the original problem ?
>
> I am attempting this on a web server's Unix host.
>
> Regards, John.
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=1
>
>
--
Daniel da Veiga
Computer Operator - RS - Brazil