Ok, I have posted some things like this yesterday, but I have some new
things to add...
Yesterday I made a posting about having issues connecting my coldfusion to
mySQL. Well I am pretty sure I have narrowed it down to mySQL being the
issue...
(NOTE - mySQL and CF are on the same server)
The reason I think that MySQL is the issue is because when I start mySQL
with:
# cd /usr/bin/
# ./safe_mysqld --skip-grant-tables &
(I know this is a security hole, but this was just for testing.)
I am able to connect to the database no problem (through coldfusion)
. So now - (being new to mysql) I assume I have an issue with the way I
configured MySQL or the user.
So to confirm - Here is how I created the user:
Mysql> GRANT SELECT, INSERT, UPDATE, DELETE,
->CREATE, DROP, ALTER, INDEX, FILE ON
->addressbook.* TO [EMAIL PROTECTED]
->IDENTIFIED BY 'password';
This was taken direct from a mysql book, and I have recreated the user over
15 times, so the chances of me fudging that every time are slim... BUT if
you see an error in the syntax, maybe my book is wrong.
I also created one like this too:
Mysql> GRANT SELECT, INSERT, UPDATE, DELETE,
->CREATE, DROP, ALTER, INDEX, FILE ON
->addressbook.* TO user@'%'
->IDENTIFIED BY 'password';
The other thing to add is that when I am SSH'd into the box, and I can
connect with mysqladmin, mysql and mysqlcc no problem. And since CF is
located on the same box, and there is no firewall enabled on itself (IE Port
3306 being blocked), I do not see what could be keeping it from connecting..
And like I said - when I start with that mysql command and disable user id's
it connects fine....
Oh please help me get some rest! ;-)
.::d::.
• --- THEbeatingsWILLcontinueUNTILmoraleIMPROVES --- •
---------------------------------------------------------------------
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
