>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.
No, I understand it allright and had configured manually localhost with a
username and password
which does not work in Cold Fusion having thought this was the problem
already. However, checking with your
suggestion I notice a user was not set up for
localhost, so once again to check CF connection to the database, tried the
following:
mysql> grant all on *.* to root@localhost identified by "" with grant
option;
Query OK, 0 rows affected (0.00 sec)
mysql> mysql -h localhost test
->
->
-> q
-> quit
But still the connection on localhost fails,
[root@www admin]# mysql -h localhost test
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)
[root@www admin]# mysql -h www.cbweb.net test
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 96 to server version: 3.22.32
Type 'help' for help.
mysql>
It's not the socket as it can connect on the domain name and has been
configured toi look for the socket in the right place.
What I suspect is there is a problem with the generic dns and domain
raq***etc setup on the raq, I`ll let you know
if this is the case.
thanks
Colm
-----Original Message-----
From: Stephen Moretti [mailto:[EMAIL PROTECTED]]
Sent: 11 February 2003 13:25
To: CF-Linux
Subject: Re: CF5, Mysql, Red Hat
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
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.14
