Hi there, If you go to the MySQL manual (chapter 4.3.1) you'll see that GRANT ALL... does not include the granting of privileges to others. So you must use something like:
GRANT ALL [...] WITH GRANT OPTION; The manual has also downloadable versions. Lian Sebe, M.Sc. Freelance Analyst-Programmer www.programEz.net > -----Original Message----- > From: Charles Cantrell [mailto:[EMAIL PROTECTED] > Sent: Monday, July 28, 2003 11:55 PM > To: '[EMAIL PROTECTED]' > Subject: GRANT command question > > > I have recently set up mySQL on a Mandrake release of Linux (Version 7 of > Mandrake, I believe), using the binary 4.0.13 standard release. > > The set up and start up all were normal, as far as I could tell, with no > warnings or error messages. > > In nearly all respects, the database appears to be running as expected. I > have the book "PHP and mySQL Web Development" by Luke Welling and Laura > Thomson, and have been working through the examples there. > > The question I have is about the GRANT command, and the apparent results > there. I don't know if my problem is one of understanding what the results > should be, or if I have another problem. > > I am attempting to set up an administrative user, that has the same > privileges as root. I have been able to set up a user that appears to have > all privileges, with the exception of GRANT privileges to other > users. This > user can create new database tables, insert records, modify them, delete > them and so on. > > But, when this user tries to GRANT privileges on any database, > even ones it > has created, an 'access denied' error is generated. > > I am obviously missing some part of the process, but I am not sure what it > is. Can you explain the piece I am missing? I would appreciate it > very much. > Thanks. > > Charles Cantrell > > PS: I submitted a much more detailed message showing the GRANT > table set up > and so on, but it was rejected by the filters. If this information would > help someone answer my question, let me know and I can send it directly, > maybe. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]