Maybe your password not set correctly, try
% mysqladmin -u root password "your password"
or you need to update the user grant tables, try
% mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD("your password")
WHERE User="root"
After setting the grant tables you might need to reload them,
% mysqladmin -u root status
If the server allows connecting through root without password, try
% mysqladmin -u root reload
rgds
Colm
-----Original Message-----
From: Jim Finucane [mailto:[EMAIL PROTECTED]]
Sent: 20 January 2003 21:46
To: CF-Linux
Subject: [Fwd: RE: mysql permissions problem]
The real problem is understanding the way mysql deals w/ permissions
precedence, if you installed mysql
and initialized it with the mysql_install_db script you still have the
anon users in the user table, these users
take precedence over your user, first thing to do is delete these users
and try again, 9 times out of 10
this is the problem.
A second cause is how mysql deals with host permissions in combination w/
users. mysql sorts by host first (going from more specific to less i.e.
mydomian.com would come before
entries for %.mydomain.com and so on) then by user, in some ways this
behaves counter to how you
would expect, to make a long story short use the mysqlaccess program to
test your permissions, it
returns good diagnostics which will help isolate the problem.
What is the exact error message you are receiving?
Regards,
Jim
OK, you've all said the same thing but looking in the db and user table, the
host is set to % - which is any address. Isnt it?
Will try it though
-----Original Message-----
From: Todd [mailto:[EMAIL PROTECTED]]
Sent: 20 January 2003 17:36
To: CF-Linux
Subject: Re: mysql permissions problem
GRANT ALL on dbname.* to user@% IDENTIFIED BY 'password'
or
GRANT ALL on dbname.* to user@'ipaddress' IDENTIFIED BY 'password'
because this: GRANT ALL ON dbname.* TO user IDENTIFIED BY 'password';
Means you've given him a user@localhost account.
~Todd
At 05:24 PM 1/20/2003 +0000, you wrote:
>Hi All,
>
>Having some trouble connecting top a Mysql db on Redhat7.2 with CFMX.
>
>Ive used:
>
>GRANT ALL ON dbname.* TO user IDENTIFIED BY 'password';
>
>But I cant logon to the mysql db using that name - any ideas?
>
>The user table had N in all provs whilst the db table has Y in all privs
(as
>it should be).
>
>Any ideas?
>
>Cheers,
>Douglas McKenzie
>
>----------------------------------------
>Internet Developer / Designer
>[EMAIL PROTECTED]
>020 7267 6718
>----------------------------------------
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=14
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=14
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.14
