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]
RE: GRANT command question
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]
Re: The GRANT command question
Hi! On Jul 25, Charles Cantrell wrote: 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. compare GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED]; and GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED] WITH GRANT OPTION; Only after the second comamnd [EMAIL PROTECTED] can give grants to others. Regards, Sergei -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
The 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]