4 messages in com.mysql.lists.win32Ynt: Authorisation Help| From | Sent On | Attachments |
|---|---|---|
| Terence | 02 May 2001 01:15 | |
| Yusuf Incekara | 02 May 2001 02:08 | |
| Danny Katcher | 02 May 2001 07:45 | |
| ePtOn | 02 May 2001 09:30 |
| Subject: | Ynt: Authorisation Help |
|---|---|
| From: | Yusuf Incekara (avuk...@superonline.com) |
| Date: | 05/02/2001 02:08:43 AM |
| List: | com.mysql.lists.win32 |
well i got same error on both Windows Nt and Windows 95 . then reboot server. saw that mysqld-nt.exe and mysqld-opt.exe are deleted. (version 3.23.37) . I copied exec file from other server and clients. Started services. It works now. But i don't know how to delete executable files.
Regards.
Yusuf Incekara Avukatpro Limited Sirketi.
----- Original Message ----- From: Terence <tere...@sunway.edu.my> To: <win...@lists.mysql.com> Sent: Wednesday, May 02, 2001 11:15 AM Subject: Authorisation Help
Hi,
I have had no problems until a few hours ago when I got this error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[TCX][MyODBC]Access denied for user: 'ODBC@VINE2' (Using password: NO)
/elearning/ecenter.asp, line 79
My permissions are set to:
grant select, update, delete, insert on newvine.* to '%'@'%';
Basically, this is what I am trying to achieve. I want two users to have full access to my databases. I am making my databases
available on the web which is why I need to set the host and username to a wildcard for the above mentioned grants. (is this the way to do it?) I am perhaps opening
a huge security hole, but i see no other way that my users on the web can update their information and insert data into the database via web forms.
Perhaps someone can advise me.
Regards
Terence