Am 08.04.2004, 19:38 Uhr schrähb Shane Hathaway <shane@zope.com>:
What are the steps, starting with no /var/lib/mysql at all, that one should take to grant one user access to create, read, and write all tables in one database?
Admittedly I never used the GRANT-Syntax, instead I always worked directly with the tables. Assuming you connect to MySQL via localhost, user "myuser" with password "mypasswd" for database "mydb" at the MySQL prompt type: mysql> use mysql mysql> insert into db values -> ("localhost","mydb","myuser", -> "Y","Y","Y","Y","Y","Y","N","N","N","N","N"); mysql> insert into user values -> ("localhost","myuser",password("mypasswd"), -> "Y","Y","Y","Y","Y","N","N","N","N","N","N","N","N"); mysql> select * from host; should result in "Empty set [...]" Of course you'll have to create the database as well: mysql> create database mydb; Now exit from the MySQL prompt and execute mysqladmin reload; (optionally supplying the appropriate -u and -p parameters) and you should ready to go. Hope this helps. Jo. -- internetmanufaktur jo----------------------------- Berlin, Germany |||||||||||||||meder-------------------fon: ++49-30-417 17 63 33 http://www.meder.de/ ------------------- fax: ++49-30-417 17 63 45 Kollwitzstr. 75 ------------------------ mob: ++49-170- 2 98 89 97 10435 Berlin ---------------http://www.meder.de/keys/jo-pubkey.txt