MySQL Forums
Forum List  »  Install & Repo

grant all won't grant global privileges
Posted by: Paul webber
Date: March 26, 2006 03:20PM

I'm running mysql on Linux, version 4.0.24_Debian-10-log.

At the mysql prompt I do:
mysql> grant all on *.* to 'root'@'192.%.%.%';
Query OK, 0 rows affected (0.00 sec)

This should (I think) grant all access to ALL databases, not just the current one. But it only grants access to the current one. On my other pc, which is also on the 192. network, I do a show databases. I only see the database that was currently selected on the mysql server. If on the server I do a 'use database2', then run the same grant command, now database2 shows up on the client. So the above grant statement is only granting access to the currently used database. How do I grant access to ALL databases on the server. According to the docs, it seems this should work.

Thanks

Options: ReplyQuote


Subject
Written By
Posted
grant all won't grant global privileges
March 26, 2006 03:20PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.