An idea; Did you try to set user name with ip address of the computer you are running instead of localhost? I think it is worth to try and hope it helps.
grant all on myFineDb.* to [EMAIL PROTECTED] identified by "abcpass";
[EMAIL PROTECTED] wrote:
What works for me with mysql 3.23.49 of Debian GNU/Linux (Woody), does not any more with mysql 3.23.56 of fink (current-stable, for fink cf. fink.sf.net) - I am not sure, if this problem is caused by the mysql version (some security changes between .49 and .56) or by the fink configuration - I might ask at the fink-users list later.
I am trying to create a database and a mysql user with privileges to use it - a rather simple thing to do (my knowledge is mostly from Paul Du Bois' books: "MySQL" and "MySQL Recipes")
I start creating the database as the mysql root user
$ mysqladmin -u root -p*** create myFineDb
Next, I create the user and give him privileges to use myFineDb (again as the mysql root user)
$ mysql -u root -p*** mysql> grant all on myFineDb.* to [EMAIL PROTECTED] identified by "abcpass"; mysql> ^D (to leave mysql)
(So far no problems, now comes the thing:)
$ mysql -u abc -pabcpass myFineDb
Works fine in Debian (.49) but not in fink (.56):
[mac:~] reuleaux% mysql -u abc -pabcpass myFineDb
ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'myfinedb'
[mac:~] reuleaux%
If I look closer at the problem I see that I can at least log in but not use the database:
[mac:~] reuleaux% mysql -u abc -pabcpass Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 24 to server version: 3.23.56
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use myFineDb; ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'myfinedb' mysql>
I have tried variations of the upper grant command with no succes either:
...to 'abc'@'localhost' ...
Any help is appreciated.
Andreas
--
Veysel Harun Sahin [EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
