[REBOL] Re: mysql access denied for user
From: kracik:mbox:dkm:cz at: 20-Mar-2001 10:31
> 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
