I have a problem with MySQL installed in my home
directory(I am not a root).
The server runs, but I can't manage it. I can't create
a database etc.
For example, when I write as below, I get message:
/a/grdfsv1/home3/m5051236/mysql/bin/mysqladmin create
testdb
/a/grdfsv1/home3/m5051236/mysql/bin/mysqladmin: CREATE
DATABASE failed; error: '
Access denied for user: '@localhost' to database
'testdb''
(my home is in m5051236, mysql.sock is in
/a/grdfsv1/home3/m5051236/mysql/tmp/),
so if I do :
/a/grdfsv1/home3/m5051236/mysql/bin/mysqladmin
--socket=/a/grdfsv1/home3/m505123
6/mysql/tmp/mysql.sock -u m5051236 -p create testdb
I get
Enter password:
/a/grdfsv1/home3/m5051236/mysql/bin/mysqladmin:
connect to server at 'localhost'
failed
error: 'Access denied for user: 'm5051236@localhost'
(Using password: YES)'
I tried to change the password but
/a/grdfsv1/home3/m5051236/mysql/bin/mysqladmin
password mypassword
/a/grdfsv1/home3/m5051236/mysql/bin/mysqladmin: unable
to change password; error
: 'You are using MySQL as an anonymous users and
anonymous users are not allowed
to change passwords'
I don't understand how to solve the problem. Could you
possibly tell me?
Thank you in advance.
Roman.
__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php