RE: Newbie Can't Add a User to MySQL

2004-03-21 Thread Matt Chatterley
o mysql_connect. Thanks, Matt -Original Message- From: Lee Zelyck [mailto:[EMAIL PROTECTED] Sent: 21 March 2004 18:10 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Newbie Can't Add a User to MySQL Greetings Michael, Daniel, et al, Good news, I can get in! As evidenced

Re: Newbie Can't Add a User to MySQL

2004-03-21 Thread Lee Zelyck
Greetings Michael, Daniel, et al, Good news, I can get in! As evidenced below, however, my php forum script will not authenticate forumuser to insert data. Further, I tried to run a php/mysql authorization test, and still an error. I know this is not a php mailing list, but please find the pr

Re: Newbie Can't Add a User to MySQL

2004-03-20 Thread Michael Stassen
Lee Zelyck wrote: Greetings all, I have taken it upon myself to try and learn MySQL management this weekend! No more using root for everything anymore! However, I cannot seem to do anything but create a login. I have tried to build an extrmely simply Forum using MySQL and PHP. I can creat

Re: Newbie Can't Add a User to MySQL

2004-03-20 Thread daniel
Nowhere have i seen that it tells u to do this ? mysql> INSERT INTO user VALUES('localhost','ForumUser',PASSWORD ('forum123'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'); for a forum i would do GRANT SELECT,INSERT,UPDATE ON *.* TO [EMAIL PROTECTED] identified 'somepass' > Greetin

Newbie Can't Add a User to MySQL

2004-03-20 Thread Lee Zelyck
Greetings all, I have taken it upon myself to try and learn MySQL management this weekend! No more using root for everything anymore! However, I cannot seem to do anything but create a login. I have tried to build an extrmely simply Forum using MySQL and PHP. I can create the DB and TABLE