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