Hi there, I am still having issues creating a user that can access a
database. The only time the user can access is if I SSH into my linux box
(redhat 8) and connect with:
# mysql -u id -p
It works fine when doing that, and I can create and do everything I need to
do.
Now - I am trying to connect my database to coldfusion (create the data
source) and that is pretty straight forward. So the ONLY thing I can think
of is that I am fudging my user id's when I create them in mysql. SO.. I
just want to double check this syntax with all of you to make sure I created
the user in such a way that I can access mySQL from anyhostname, etc.
# mysql -u root -p
Mysql> GRANT SELECT, INSERT, UPDATE, DELETE,
->CREATE, DROP, ALTER, INDEX, FILE ON
->database.* TO [EMAIL PROTECTED]
->IDENTIFIED BY 'password';
So that should give me access from the box that the MySQL server is on. This
so happenes to be the same box coldfusion is on.
But to be safe, I wanted to grant this user access from any host name, so I
did the following:
# mysql -u root -p
Mysql> GRANT SELECT, INSERT, UPDATE, DELETE,
->CREATE, DROP, ALTER, INDEX, FILE ON
->database.* TO id@'%'
->IDENTIFIED BY 'password';
I saw the single quotes in the book I am reading, but I have seen it
referenced to double quoters as well - so which is right.. Well at any rate
- to be safe, I tried this as well:
# mysql -u root -p
Mysql> GRANT SELECT, INSERT, UPDATE, DELETE,
->CREATE, DROP, ALTER, INDEX, FILE ON
->database.* TO id@"%"
->IDENTIFIED BY 'password';
So am I fudging this somewhere when creating this id? I also deleted and
tried creating them in mysqlcc - and I still have the same issues.....
And in there when adding the % one, it seems to us no quotes.... (IE [EMAIL
PROTECTED]),
so that is confusing me a bit too!
In a nut shell I want this user to be able to access the database from any
hostname. This has been a frustrating thing for me.... So I am hoping
someone can clarify!
Thanks!
d
---------------------------------------------------------------------
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
