sql

--_----------=_1163473366227871
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain; charset="iso-8859-1"

Hello!

I install mysql version 4.0.26 on my WINDOWS XP

I have error 1044 Access denied for user. When I did type use testDB;

Error 1064 No Database Selected. When I did type create table test_table=20
(test_id int, test_note text);

On C directory I created MY.CNF file and also on Windows directory I
created my.ini file.

Did not help.

I was on this page http://www.mysql.com/documantation/index.html

I can not find anything which will help me in this problem on your web
page.

Do you have any other idea run this program.

Thank you in advance,

Kazimierz Bogusz.

--=20

Search for products and services at:=20
http://search.mail.com


--_----------=_1163473366227871--

Re: sql

Kazimierz,

First, do not keep both configuration files, it only confuses things.
When the program loads, it first looks at my.ini, then looks at my.cnf.
Anything set in my.ini can be reset in my.cnf. I suggest you delete my.cnf.

The default installation creates a db named 'test', not testDB. Once you
get the client connected you can issue "show databases;" to list the
databases that are available.

MySql installs a user named 'root' with admin privileges. Sign into that
account. It has no password until you set one.

Errors are logged in your mysql/data folder. The file will have your
server's name with a .err extension. There may be something there that
will help you resolve most errors.

That should get you going.

Randy Clamons
Systems Programming
randy@novaspace.com


Kazimierz Bogusz wrote:
> Hello!
>
> I install mysql version 4.0.26 on my WINDOWS XP
>
> I have error 1044 Access denied for user. When I did type use testDB;
>
> Error 1064 No Database Selected. When I did type create table test_table
> (test_id int, test_note text);
>
> On C directory I created MY.CNF file and also on Windows directory I
> created my.ini file.
>
> Did not help.
>
> I was on this page http://www.mysql.com/documantation/index.html
>
> I can not find anything which will help me in this problem on your web
> page.
>
> Do you have any other idea run this program.
>
> Thank you in advance,
>
> Kazimierz Bogusz.
>

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org