Thanks for pointing me in the right direction. I found it here in the docs...
shell> mysql --user=root mysql
mysql> GRANT ALL PRIVILEGES ON *.* TO monty@localhost
IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON *.* TO monty@"%"
IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
A full superuser who can connect to the server from
anywhere, but who must use a password 'some_pass' to
do so. Note that we must issue GRANT statements for
both monty@localhost and monty@"%". If we don't
add the entry with localhost, the anonymous user
entry for localhost that is created by
mysql_install_db will take precedence when we
connect from the local host, because it has a more
specific Host field value and thus comes earlier in the
user table sort order.
>> So does that mean the mysql:// protocol will only work using scripts
>> executed on the server where the database resides?
>>
>
>With default MySQL privileges, yes. It's not specific to mysql://
>protocol, it's the same with PHP, Perl, ODBC driver or any other
>client.
>
>But MySQL administrator can grant access to specific or all users,
>domains or IP addresses. I tried it with Nenad when testing
>the mysql:// protocol and it worked. But it took some time to set up
>the privileges, and I don't remember the exact commands. This should
>allow connection and grant all privileges to all databases to user
>with name rebtest and password reb from any domain. It's good for
>testing, but it's insecure since it allows the user to accidentally
>delete all databases on the server.
>
>telnet as any user
>shell> mysql -uroot -p
>The only MySQL user with administrative rights is root by default.
>His password is by default empty, it's different from root's UNIX
>password.
>mysql> use mysql;
>mysql> GRANT ALL PRIVILEGES ON *.* TO rebol@"%" IDENTIFIED BY 'reb';
>mysql> quit;
>
>Hope this helps,
>
>--
>Michal Kracik
>--
>To unsubscribe from this list, please send an email to
>[EMAIL PROTECTED] with "unsubscribe" in the
>subject, without the quotes.
>
>
--
To unsubscribe from this list, please send an email to
[EMAIL PROTECTED] with "unsubscribe" in the
subject, without the quotes.
