Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
2 part question newbie in Mysql
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 ? -
2 part question newbie in Mysql
lolol K i am losing it lol thanks alot :) -
2 part question newbie in Mysql
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... -
2 part question newbie in Mysql
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... -
2 part question newbie in Mysql
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 -
2 part question newbie in Mysql
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...
