[PHP-DB] problem with grant
Hi there, I am trying to understand the use of grant. do have some probs. Maybe someone can give me hint.. I did try this command: grant all privileges on *.* to [EMAIL PROTECTED] (xxx... = ip adress) Then I did try to connect from this remote machine to the server using this user The errormsg is: Connection failed: 1045- Access denied for user: [EMAIL PROTECTED] (using password NO) What's wrong with my grant table statement? Or is there somehow a firewal involved? php works with db access. I am running it on suse7.2 Thanx for your help guys Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] problem with grant
On Saturday 11 May 2002 19:19, andy wrote: Hi there, I am trying to understand the use of grant. do have some probs. Maybe someone can give me hint.. I did try this command: grant all privileges on *.* to [EMAIL PROTECTED] (xxx... = ip adress) Then I did try to connect from this remote machine to the server using this user The errormsg is: Connection failed: 1045- Access denied for user: [EMAIL PROTECTED] (using password NO) What's wrong with my grant table statement? Or is there somehow a firewal involved? php works with db access. I am running it on suse7.2 You're better off asking on the mysql list. You do know that the above statement would grant privileges to /ALL/ your databases to the user mysqladmin connecting at xxx.xxx.xxx.xxx /WITHOUT/ requiring the use of a password? After doing a grant you need to flush privileges before it will take effect. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Let me do my TRIBUTE to FISHNET STOCKINGS ... */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] problem with grant
can you send me the link for the english mysql user group, please. I did search a while for this link on mysql.com but did not find any. Thanx in advance, Andy Jason Wong [EMAIL PROTECTED] schrieb im Newsbeitrag news:[EMAIL PROTECTED]... On Saturday 11 May 2002 19:19, andy wrote: Hi there, I am trying to understand the use of grant. do have some probs. Maybe someone can give me hint.. I did try this command: grant all privileges on *.* to [EMAIL PROTECTED] (xxx... = ip adress) Then I did try to connect from this remote machine to the server using this user The errormsg is: Connection failed: 1045- Access denied for user: [EMAIL PROTECTED] (using password NO) What's wrong with my grant table statement? Or is there somehow a firewal involved? php works with db access. I am running it on suse7.2 You're better off asking on the mysql list. You do know that the above statement would grant privileges to /ALL/ your databases to the user mysqladmin connecting at xxx.xxx.xxx.xxx /WITHOUT/ requiring the use of a password? After doing a grant you need to flush privileges before it will take effect. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Let me do my TRIBUTE to FISHNET STOCKINGS ... */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] problem with grant
On Saturday 11 May 2002 21:37, andy wrote: can you send me the link for the english mysql user group, please. I did search a while for this link on mysql.com but did not find any. I can't believe you have searched very hard :) google - mysql mailing list -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Just because he's dead is no reason to lay off work. */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php