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
[email protected]


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/[email protected]