If I wanted say joe smith(or anyone from the internet) to be able to enter data in my database can i do it so they can enter data but not change anything ?
mysql> GRANT SELECT,INSERT,UPDATE,DELETE,INDEX,ALTER,CREATE,DROP,RELOAD,SHUTDOWN -> ON netbingodb.*
-> TO cxteam@localhost
-> INDENTIFIED BY xxxx
-> WITH GRANT OPTION;
ERROR 1064: You have an error in your SQL syntax near 'INDENTIFIED BY xxxx
WITH GRANT OPTION' at line 4
I thank...
mysql> GRANT SELECT,INSERT,UPDATE,DELETE,INDEX,ALTER,CREATE,DROP,RELOAD,SHUTDOWN,
-> ON newone.*
-> TO cxteam@localhost
-> INDENTIFIED BY xxxxxxx
-> WITH GRANT OPTION;
is this correct i get a
ERROR 1064: You have an error in your SQL syntax near 'ON netbingodb.*
TO...
Thanks for you help. I am useing Red Hat 8. I will look for the php-mysql rpm. I am just not really sure on the syntax of the grant command but I will seach alittle be to see if I can find the correct why I doing it.
But thanks for helping me in the correct direction
cxteam
Bare with me to see if I am doing this correct. Thanks
I need to create a database this i know. (newone being the db)
create database newone;
I have a newone.sql file with a the table I need.
mysql newone -uxxx -pxxx < /root/newone.sql
So far i have checked this and its all there...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.