Colm,
> I had no problem with installing mysql, just connecting to it with
user@localhost, see connection example,
> I`ll try your suggestion re setting up root@% but not too sure this will
> work. Can connect though with user@% or username from individual ip's as
well.
>
I think you misunderstand. You need to check that you have user@localhost
set up.
Really you shouldn't have root@% set up at all, other than in the initial
set up phase to make life a little easier.
When you're setting up users in mySQL you have to specify where they are
accessing the database from. joebloggs@localhost means that a user called
"joebloggs" can access the database from localhost (ie. the same machine as
the dbms). joebloggs@% means that user "joebloggs" can access the database
from anywhere.
So from your connection session where you issue the command line "mysql -h
127.0.0.1 test" and get the error
"ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)"
This means that the user "root" has been denied access to the database
"test" from the address "localhost".
Two reasons this could be happening :
1) "root" has not been given permission to access the database from
"localhost"
2) "root" may have a password, which you haven't specified in the
command line.
I suspect that in this case the problem is that root does not have
permission to access the database from "localhost" as your third command
line "mysql -h www.domain test" is working. I suspect that mysql thinks
that user root is connecting from www.domain as well as to www.domain in
this instance.
Hope this helps
Regards
Stephen
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=14
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=14
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.14
