mysql not working fine.WHY?

I've installed mysql 4.0.18 on my WinXP Pro OS.After installation, i open the MySQLAdmin 1.4 window.Now i wanted to creat a database,but the is not creat database selection on the right-click menu.And under MyODBC in the environment tab,it says driver 3.5 not found.I've checked the ODBC in my computer,its installed and is version4.0.Now i can't add database,can anyone help me?What is going wrong?Or what have i not done?hmmm.....

im having the same problem....

You can always use the command line to create the database.

On my box mysql is installed at c:\mysql

the mysql.exe is located in the \bin directory.

C:\mysql\bin> mysql.exe

You'll get a mysql prompt.

mysql>

just create the database from there.

mysql> CREATE DATABASE example_database;

The Windows mysql admin utility isnt really good for anything but browsing around. At least thats my experience.
I usually do all my admin stuff via phpMyAdmin.

I hope that helps.

i've tried that but I received this error...

ERROR 2003: Can't connect to MySQL server on 'localhost' <10061>

Any suggestion?

The first thing I would check is to make sure the MySQL service has been started and is running.

If it is and you're still having a problem, certain Firewall programs like ZoneAlarm have been known to cause connection problems because by default they don't think localhost 127.0.0.1 is a trusted source.

same here have installed MySQL on my computer, it won't connect to the server, any idea why?

When I start WinMySQLAdmin, this is what appears in the Environment tab under MyODBC:

Not Found
Driver 3.51 Not Found
And also try to create database through command prompt but im getting this error
ERROR 1044 (42000): Access denied for user: ''@'localhost' to database 'test'

pls give me some tips to fix the problem

thanks

First you need to establish the default password.

then log into mysql via: c:/mysql -u <username> -p

it will ask you for you password and then it will let you in.

Itamar

download the odbc driver and install it from here
http://dev.mysql.com/downloads/connector/odbc/3.51.html

What do you need the odbc driver for if you're connecting from the MySQL Command Line Client?

im wondering why people need odbc driver?
i use phpmyadmin as to help me to create database instead using mysql cmmd line client.
try to use phpmyadmin and it is easier

-novice user for mysql,phpmyadmin-