[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
[PHP-DB] Syncing two tables in mysql
Hey all, Is there a way i can sync two tables in mysql on two totaly different servers over the internet via php4 or mysql? I'm using php4.0.6 thanks Thomas omega Henning -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Syncing two tables in mysql
On Sunday 12 May 2002 01:34, Thomas \omega\ Henning wrote: Hey all, Is there a way i can sync two tables in mysql on two totaly different servers over the internet via php4 or mysql? I'm using php4.0.6 mysql has it's own replication mechanism. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* In Christianity neither morality nor religion come into contact with reality at any point. -- Friedrich Nietzsche */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Easy one for you guru's :-)
Hi All Can someone breakdown the logic of adding and subtracting products to a shopping cart using sessions. I can't quite get the logic so something in plain English would help very much. Any helpful advice, pointers or even code examples are very much appreciated. Thank you fully in advance for any help you may give. Dave C
[PHP-DB] Pestgres+ Perl
I wanted to know how I can do to create a database from php if it is not created from Postgres. Another problem is how to insert Perl code in php or how can I do to call a perl program from the web. Thank in advance!! Sabina Alejandra Schneider[EMAIL PROTECTED]
RE: [PHP-DB] Easy one for you guru's :-)
I have one that uses a database, is that any use, or do you specifically want a php session based bit of coding?? Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 --- -Original Message- From: Dave Carrera [mailto:[EMAIL PROTECTED]] Sent: 11 May 2002 19:03 To: [EMAIL PROTECTED] Subject: [PHP-DB] Easy one for you guru's :-) Hi All Can someone breakdown the logic of adding and subtracting products to a shopping cart using sessions. I can't quite get the logic so something in plain English would help very much. Any helpful advice, pointers or even code examples are very much appreciated. Thank you fully in advance for any help you may give. Dave C -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Getting error using mssql_next_result
Hello.. If I'm not wrong, it should be : mysql_connect not mssql_connect unless
you've defined a function somewhere...
- Original Message -
From: Jason Wong
To: [EMAIL PROTECTED]
Sent: Thursday, May 09, 2002 3:44 p
Subject: Re: [PHP-DB] Getting error using mssql_next_result
On Thursday 09 May 2002 10:26, Jim Wentz wrote:
In a phpfile, I am using the following:
$link = mssql_connect($dbservername, $dbusername, $dbpassword) or
DIE(DATABASE FAILED TO RESPOND.);
mssql_select_db($dbserverdbnameacct) or DIE(Table unavailable);
$sql = insert into test (descrip) values ('another test record') select
@@identity;
$result = mssql_query($sql, $link);
$i = mssql_next_result($result);
Inspection of the table test proves that the first of the two sql
statements in $sql is functioning. However, I constantly get the following
error: Warning: Supplied argument is not a valid MS SQL-result resource in
C:\Inetpub\wwwroot\VisionCall\SubmitLoginRequest.php on line 11
Any ideas? Any help is greatly appreciated!
Add some error checking?
1) Echo $sql to see what it holds
2) Use mssql_get_last_message()?
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development *
/*
Hanlon's Razor:
Never attribute to malice that which is adequately explained
by stupidity.
*/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Getting error using mssql_next_result
At 01:37 AM 5/11/2002 +0300, Khalid A.S. posted the following... Hello.. If I'm not wrong, it should be : mysql_connect not mssql_connect unless you've defined a function somewhere... If your'e connecting to a MySQL database, yes, but if you're connecting to a MS SQL database, then he's correct. :) Glenn --- The original portions of this message are the copyright of the author (c)1998-2002 Glenn E. Sieb.ICQ UIN: 300395IRC Nick: Rainbear All acts of Love and Pleasure are Her rituals-Charge of the Goddess -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Syncing two tables in mysql
And how can i use it? Jason Wong [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]... On Sunday 12 May 2002 01:34, Thomas \omega\ Henning wrote: Hey all, Is there a way i can sync two tables in mysql on two totaly different servers over the internet via php4 or mysql? I'm using php4.0.6 mysql has it's own replication mechanism. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* In Christianity neither morality nor religion come into contact with reality at any point. -- Friedrich Nietzsche */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
