MYSQL Neophite

:hr:
I installed MYSQL 4.0x on my local machine and set the username on MYSQL Admin to a name other then root.

Now, when I launch mysql.exe I can’t get to the shell prompt and I only have access rights to work with the test database. I can’t create a new database with code like:

CREATE DATABASE ironworks;

The reults are: Error 1044 Access Denied.

Any ideas appreciated.

try it with this program mysql-front i believe you can get it form www.mysqlfront.de

Where did you start the exe from ?
install it as a service might help

how?
shell> C:\mysql\bin\mysqld --install

if you’ve already tried ‘root’ and no password, you could also try editing the my.ini file. if that doesn’t work, download this: http://dev.mysql.com/downloads/mysqlcc.html (it’s the mysql GUI), and repeat the last two steps. lastly if none of that works, reinstall.