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'; -- Clayburn W. Juniel, III -- Effective Software Solutions Phone: (602)274-6905 Fax: (602)274-6905 Email: [EMAIL PROTECTED] Mobile: (602)326-7707 http://EffectiveSoftwareSolutions.com -- --------------------------------------------------------------------- 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
