MYSQL Neophite

[flashermx]

: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.

[ol4pr0]

try it with this program mysql-front i believe you can get it form www.mysqlfront.de (http://www.mysql-front.de)

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

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

[norie]

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.