Im sorry to do this but could someone repost the link to the mysql:// port scheme. For
some reason it appears I removed my message on it.
Brady
On Tue, Mar 20, 2001 at 07:37:27AM -0600, <[EMAIL PROTECTED]> wrote:
> 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.
--
To unsubscribe from this list, please send an email to
[EMAIL PROTECTED] with "unsubscribe" in the
subject, without the quotes.
