On Thursday, September 12, 2002, at 09:58 PM, Clayburn W. Juniel, III wrote:
> > On Thursday, September 12, 2002, at 05:03 AM, philipp ringli wrote: > >> hi all, >> >> i am running OS X 10.2 and >> this version of mysql: >> >> mysql> status >> -------------- >> ./bin/mysql Ver 11.18 Distrib 3.23.51, for apple-darwin6.0 (powerpc) >> >> Connection id: 117 >> Current database: mysql >> Current user: root@localhost >> Current pager: stdout >> Using outfile: '' >> Server version: 3.23.51-entropy.ch >> Protocol version: 10 >> Connection: Localhost via UNIX socket >> Client characterset: latin1 >> Server characterset: latin1 >> UNIX socket: /tmp/mysql.sock >> Uptime: 4 hours 15 min 17 sec >> >> php 4.2.1 also by entropy.ch >> >> >> >> my problem is the following: >> >> let's say i want to add the following user (just as a test): >> >> mysql> grant all >> -> on * >> -> to test >> -> with grant option; >> >> i do that and then i do a >> mysql> use mysql; >> mysql> SELECT * FROM user; >> >> the thing is, that all the permissions are still set to 'N'!! it won't >> accept the grant arguments. also after a mysqladmin reload! >> i also have phpMyAdmin 2.3.0 installed and if i change the user's >> permissions in there, it accepts them. then also the terminal will >> list them >> properly. >> >> why is this happening? >> >> please advise, >> >> phil >> > > I assume you started with: > > whoever% mysql -uroot -p > Enter password: xxxxxxxxxxx > > mysql> > > You need to add users like this: > > mysql> grant create, delete, drop, insert, select, update on > mysql> Database_Name to someone@"%" identified by 'password'; > > and > > mysql> grant create, delete, drop, insert, select, update on > mysql> Database_Name to someone@localhost identified by 'password'; > "Database_Name" should have been "Database_Name.*" Clay __ Warning! Opinions will change due to new information. -- Clayburn W. Juniel, III Phone: (602)274-6905 Fax: (602)274-6905 Mobile: (602)326-7707 -- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
