Mailing List Archive: 49091 messages
  • Home
  • Script library
  • AltME Archive
  • Mailing list
  • Articles Index
  • Site search

[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