MySQLadmin permissions, can't create DBs???

Gwailo

B.A. Economics (Hon)
hi all,

I'm getting hugely frustrated with my(sql)self when trying to issue mysqladmin commands. I can't use anything to create databases, either with mysql create database name, or mysqladmin create name.

I've tried
sudo mysql mysqladmin create test1
su; mysqladmin create test1
login mysql;mysqladmin create test1

All of them tell me I don't have access to mysqladmin/test1 (which doesn't exist).

What am I doing wrong? I followed the installation and boot instuctions on (http://www.entropy.ch/software/macosx/mysql/) and still can't seemt o do it correctly. Is it possible that i chown'ed the app incorrectly when I installed it; but even then shouldn't root have access?

All help appreciated. Thanks!
 
[localhost:~] msanford% sudo mysqladmin --user=mysql -p[password] create test1

./bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'mysql@localhost' (Using password: YES)'


AND


[localhost:~] msanford% mysqladmin -u root -p password
Enter password:
./bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: YES)'


What the **** am I doing wrong? I also sometimes get the message that user.cnf (or something similar, I can't reproduce the message to copy it) is missing. I've reinstalled MySQL from the package several times, deleted the user account and recreated it, and deleted all the obvious mySQL stuff about (/usr/local/mysql/*) but all to no avail. And I can't issue fix_permission_db either.

Any ideas?:confused:
 
Back
Top