Hi Todd,
2003年 8月 4日 月曜日 08:01、Todd Cary さんは書きました: > Nils - > > What is the difference between "*.* " and "* "? Hi Todd I just double checked. There is no difference. Both work the same way. I originally thought that the first one wouldn't have worked, but I checked it now. However I believe that *.* is the prober syntax. > > Does Grant All give the user the rights to create a DB? The below command allows the user todd all privileges (CREATE,INSERT,DELETE, UPDATE etc.) . The "with grant option" will also allow the user todd to create new users. About the command itself, I just doule checked once more. If you specify only the username then a wildcard is insert for the hostname (%) which allows the user todd to be able to login from anywhere. make sure thats what you really want !! In any other case you could specify the user as '[EMAIL PROTECTED]' to limit it to only the one host. Best regards Nils Valentin Tokyo/Japan > > Many thanks.... > > Todd > > Nils Valentin wrote: > >Hi Todd, > > > >try this > > > >grant all > >-> on *.* > >-> to todd indentified by 'my_password' > >-> with grant option; > > > > > >I believe you forgot the ".* " wich I added after grant all on... > > > >Best regards > > > >Nils Valentin > >Tokyo/Japan > > > >2003年 8月 4日 月曜日 01:52、Todd Cary さんは書きました: > >>I have installed Red Hat 9 and it installs MySQL. After logging on as > >>root, I did the following: > >> > >>mysql > >>mysql> use mysql; > >>mysql> grant all > >>-> on * > >>-> to todd indentified by 'my_password' > >>-> with grant option; > >> > >>I then log out of mysql and log out as root. Logged in as "todd" I type > >>the following: > >> > >>mysql -u todd -p > >> > >>I type in my password and I get the following error: > >> > >>Acess denied for [EMAIL PROTECTED] > >> > >>When I was in mysql as root, "select * from user" has "todd" listed. > >> > >>What have I missed? > >> > >>Todd -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]