[PHP-DB] Fw: cara phpasp bisa jalan bareng|how to make asp php work together
- Original Message - From: gunawan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: php-windows@lists.php.net; php-db@lists.php.net Sent: Friday, March 02, 2007 5:10 PM Subject: cara phpasp bisa jalan bareng|how to make asp php work together wa kirim ke site english jd harap maklum kl pake bahasa inggris i have problem to solve. my office have only limited budget and only able buy one server and it only asp inside.. the problem is, I want to make that server work for php and for asp which that was already inside (since my office using some aplication using asp). 1.how to make the server able to respon both asp and php.. even thought i will not touch the asp?? 2. is better i use apache or iis?? thx for your reply -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Mysql autentication problem
Hello, I'm trying to do a very simple thing: create a database and a user to use it. So, initially, I use the web interface phpmyadmin. Logged as root, I created the database, and the user with some password. But, I could not login using phpmyadmin. Either any php-based system could connect to the BD. So, I make sure that I got the [EMAIL PROTECTED] and [EMAIL PROTECTED] created, with permissions and same password. Nothing. But I *can* log on mysql shell. One more info: when the user is set without password, it works fine on PHP. Does anyone can give me a clue of what is happening? Thanks! Roberto -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Mysql autentication problem
Hi, So it works from PHP w/o a password, but with a password does not? What are you using for a password? I don't mean post it here, but are there any 'funny' characters in it? I've had trouble because of that before, on other systems. Try a dumb, obviously OK password, like 'apples' and see if that works. Increase the password complexity from there... Ted On 3/2/07, Roberto F Tavares Neto [EMAIL PROTECTED] wrote: Hello, I'm trying to do a very simple thing: create a database and a user to use it. So, initially, I use the web interface phpmyadmin. Logged as root, I created the database, and the user with some password. But, I could not login using phpmyadmin. Either any php-based system could connect to the BD. So, I make sure that I got the [EMAIL PROTECTED] and [EMAIL PROTECTED] created, with permissions and same password. Nothing. But I *can* log on mysql shell. One more info: when the user is set without password, it works fine on PHP. Does anyone can give me a clue of what is happening? Thanks! Roberto -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] auto upload
You could use php+gtk to write it that way, but a simple batch file is the best bet since you could then use task scheduler to run this batch file at scheduled times. Just google dos batch files bastien From: bedul [EMAIL PROTECTED] To: Bastien Koert [EMAIL PROTECTED] CC: php-db@lists.php.net Subject: Re: [PHP-DB] auto upload Date: Fri, 2 Mar 2007 17:13:51 +0700 - Original Message - From: Bastien Koert [EMAIL PROTECTED] To: [EMAIL PROTECTED]; php-windows@lists.php.net; php-db@lists.php.net Sent: Thursday, March 01, 2007 9:05 PM Subject: RE: [PHP-DB] auto upload What about just writing a batch script that opens the ftp services and sends the file? Bastien hmm.. that was a good idea.. is that using php?? or i should use desktop programing?? i better use php since this php milis right.. _ http://local.live.com/default.aspx?v=2cp=43.658648~-79.383962style=rlvl=15tilt=-90dir=0alt=-1000scene=3702663cid=7ABE80D1746919B4!1329 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Mysql autentication problem
Ted, I try the classic abc and had the same problem... Roberto Ted Fines escreveu: Hi, So it works from PHP w/o a password, but with a password does not? What are you using for a password? I don't mean post it here, but are there any 'funny' characters in it? I've had trouble because of that before, on other systems. Try a dumb, obviously OK password, like 'apples' and see if that works. Increase the password complexity from there... Ted On 3/2/07, Roberto F Tavares Neto [EMAIL PROTECTED] wrote: Hello, I'm trying to do a very simple thing: create a database and a user to use it. So, initially, I use the web interface phpmyadmin. Logged as root, I created the database, and the user with some password. But, I could not login using phpmyadmin. Either any php-based system could connect to the BD. So, I make sure that I got the [EMAIL PROTECTED] and [EMAIL PROTECTED] created, with permissions and same password. Nothing. But I *can* log on mysql shell. One more info: when the user is set without password, it works fine on PHP. Does anyone can give me a clue of what is happening? Thanks! Roberto -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Roberto Fernandes Tavares Neto Prof. Assistente Departamento de Engenharia de Produção Universidade Federal de São Carlos [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] tel +55 16 3351-9240 http://www.dep.ufscar.br/docentes_desc.php?uid=165 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Fw: cara phpasp bisa jalan bareng|how to make asp php work together
1. install php, we have both running on our iis servers with no problems 2. you can use either one iis or apache ( my work machine runs several servers at once) The trick will be to designate the ports that the servers listen on bastien From: bedul [EMAIL PROTECTED] To: [EMAIL PROTECTED] CC: php-windows@lists.php.net,php-db@lists.php.net Subject: [PHP-DB] Fw: cara phpasp bisa jalan bareng|how to make asp php work together Date: Fri, 2 Mar 2007 17:17:11 +0700 - Original Message - From: gunawan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: php-windows@lists.php.net; php-db@lists.php.net Sent: Friday, March 02, 2007 5:10 PM Subject: cara phpasp bisa jalan bareng|how to make asp php work together wa kirim ke site english jd harap maklum kl pake bahasa inggris i have problem to solve. my office have only limited budget and only able buy one server and it only asp inside.. the problem is, I want to make that server work for php and for asp which that was already inside (since my office using some aplication using asp). 1.how to make the server able to respon both asp and php.. even thought i will not touch the asp?? 2. is better i use apache or iis?? thx for your reply -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php _ Free Alerts : Be smart - let your information find you ! http://alerts.live.com/Alerts/Default.aspx -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Mysql autentication problem
Hi, When you're connecting from your PHP script, are you connecting from the same machine that the db is on, or a different one? If a different one, you'll need to do grant commands like: grant all privileges on mydbname.* to 'mydbuser'@'myhostname.mycompany.net' identified by 'mypassword'; Ted On 3/2/07, Roberto F Tavares Neto [EMAIL PROTECTED] wrote: Ted, I try the classic abc and had the same problem... Roberto Ted Fines escreveu: Hi, So it works from PHP w/o a password, but with a password does not? What are you using for a password? I don't mean post it here, but are there any 'funny' characters in it? I've had trouble because of that before, on other systems. Try a dumb, obviously OK password, like 'apples' and see if that works. Increase the password complexity from there... Ted On 3/2/07, Roberto F Tavares Neto [EMAIL PROTECTED] wrote: Hello, I'm trying to do a very simple thing: create a database and a user to use it. So, initially, I use the web interface phpmyadmin. Logged as root, I created the database, and the user with some password. But, I could not login using phpmyadmin. Either any php-based system could connect to the BD. So, I make sure that I got the [EMAIL PROTECTED] and [EMAIL PROTECTED] created, with permissions and same password. Nothing. But I *can* log on mysql shell. One more info: when the user is set without password, it works fine on PHP. Does anyone can give me a clue of what is happening? Thanks! Roberto -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Roberto Fernandes Tavares Neto Prof. Assistente Departamento de Engenharia de Produção Universidade Federal de São Carlos [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] tel +55 16 3351-9240 http://www.dep.ufscar.br/docentes_desc.php?uid=165
RE: [PHP-DB] Mysql autentication problem
have you tried to 'flush privileges' to get the server to recognize the user account. Another option might be to open the mysqld from the command line and use the GRANT statement to create user without the gui. bastien From: Roberto F Tavares Neto [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] Mysql autentication problem Date: Fri, 02 Mar 2007 10:05:54 -0300 Hello, I'm trying to do a very simple thing: create a database and a user to use it. So, initially, I use the web interface phpmyadmin. Logged as root, I created the database, and the user with some password. But, I could not login using phpmyadmin. Either any php-based system could connect to the BD. So, I make sure that I got the [EMAIL PROTECTED] and [EMAIL PROTECTED] created, with permissions and same password. Nothing. But I *can* log on mysql shell. One more info: when the user is set without password, it works fine on PHP. Does anyone can give me a clue of what is happening? Thanks! Roberto -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php _ Free Alerts : Be smart - let your information find you ! http://alerts.live.com/Alerts/Default.aspx -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Mysql autentication problem
I tried both already. It does not work. Roberto Bastien Koert escreveu: have you tried to 'flush privileges' to get the server to recognize the user account. Another option might be to open the mysqld from the command line and use the GRANT statement to create user without the gui. bastien From: Roberto F Tavares Neto [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] Mysql autentication problem Date: Fri, 02 Mar 2007 10:05:54 -0300 Hello, I'm trying to do a very simple thing: create a database and a user to use it. So, initially, I use the web interface phpmyadmin. Logged as root, I created the database, and the user with some password. But, I could not login using phpmyadmin. Either any php-based system could connect to the BD. So, I make sure that I got the [EMAIL PROTECTED] and [EMAIL PROTECTED] created, with permissions and same password. Nothing. But I *can* log on mysql shell. One more info: when the user is set without password, it works fine on PHP. Does anyone can give me a clue of what is happening? Thanks! Roberto -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php _ Free Alerts : Be smart - let your information find you ! http://alerts.live.com/Alerts/Default.aspx -- Roberto Fernandes Tavares Neto Prof. Assistente Departamento de Engenharia de Produção Universidade Federal de São Carlos [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] tel +55 16 3351-9240 http://www.dep.ufscar.br/docentes_desc.php?uid=165 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Mysql autentication problem
Ted, The [EMAIL PROTECTED] does the same effect as 'mydbuser'@'myhostname.mycompany.net' , right? Btw, for web apps, I got another user, @localhost only. This user is working... I thought it was a problem on the GUI, so I tried a [EMAIL PROTECTED] from mysql command line. It fails too... Tks! Roberto Ted Fines escreveu: Hi, When you're connecting from your PHP script, are you connecting from the same machine that the db is on, or a different one? If a different one, you'll need to do grant commands like: grant all privileges on mydbname.* to 'mydbuser'@'myhostname.mycompany.net' identified by 'mypassword'; Ted On 3/2/07, Roberto F Tavares Neto [EMAIL PROTECTED] wrote: Ted, I try the classic abc and had the same problem... Roberto Ted Fines escreveu: Hi, So it works from PHP w/o a password, but with a password does not? What are you using for a password? I don't mean post it here, but are there any 'funny' characters in it? I've had trouble because of that before, on other systems. Try a dumb, obviously OK password, like 'apples' and see if that works. Increase the password complexity from there... Ted On 3/2/07, Roberto F Tavares Neto [EMAIL PROTECTED] wrote: Hello, I'm trying to do a very simple thing: create a database and a user to use it. So, initially, I use the web interface phpmyadmin. Logged as root, I created the database, and the user with some password. But, I could not login using phpmyadmin. Either any php-based system could connect to the BD. So, I make sure that I got the [EMAIL PROTECTED] and [EMAIL PROTECTED] created, with permissions and same password. Nothing. But I *can* log on mysql shell. One more info: when the user is set without password, it works fine on PHP. Does anyone can give me a clue of what is happening? Thanks! Roberto -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Roberto Fernandes Tavares Neto Prof. Assistente Departamento de Engenharia de Produção Universidade Federal de São Carlos [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] tel +55 16 3351-9240 http://www.dep.ufscar.br/docentes_desc.php?uid=165 -- Roberto Fernandes Tavares Neto Prof. Assistente Departamento de Engenharia de Produção Universidade Federal de São Carlos [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] tel +55 16 3351-9240 http://www.dep.ufscar.br/docentes_desc.php?uid=165 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] recursion in php and mysql
It will complain if your query isn't returning any results. Check for that too. -Micah On 03/01/2007 09:36 PM, Ron Croonenberg wrote: Hi Micah, thanks I have a bunch of things working now. mysql_fetch_array() is complaining. I use it like this: function recursive() { global $connection; $result = mysql_query(SELECT * FROM $table WHERE bthb4='$bthb4', $connection); $row = mysql_fetch_array($result); } the error I got was: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in recursion.php on line 93 I tried: $row = mysql_fetch_array($result, $connection); But I have the impression that $result now isn't correct anymore ? the mysql_fetch_array() is the only function (so far) that complains ? thanks for your earlier very quick response, Ron Micah Stevens [EMAIL PROTECTED] 03/02/07 12:04 AM Yep, just put the connect function outside your recursive loop. You can then access the connection that is returned by the connect function by making it global, or passing it by reference by the recursive function. In other words: $connection = mysql_connect(); mysql_select_db($database, $connection); recursive_function($value); function recursive_function($value) { global $connection; $data = mysql_query($sql, $connection); recursive_function($data); } ... or something.. you get the picture. -Micah On 03/01/2007 08:52 PM, Ron Croonenberg wrote: Hello all, I wrote an app in php and it uses recursion. Problem I have is that when I connect to a database using mysql_connect($dbhost, $username, $password); and select a table with mysql_select_db($database) I cannot access the table anymore from some function. Now I can connect and select a database in that php function but that means that process happens A LOT and connecting and selecting everytime probably slows down the app quite a bit Is there a way to connect to a database and select a table globally so that I have access to it in ever php function I write ? thanks, Ron
Re: [PHP-DB] Mysql autentication problem
Did you give the user permissions to use the database in question? Here's my sequence of actions: . 1) Create DB if it doesn't exist 2) Create the user w/password 3) Give the user permission to use the database. 4) Flush privileges to update the server. 5) login and enjoy. -Micah Roberto F Tavares Neto wrote: Hello, I'm trying to do a very simple thing: create a database and a user to use it. So, initially, I use the web interface phpmyadmin. Logged as root, I created the database, and the user with some password. But, I could not login using phpmyadmin. Either any php-based system could connect to the BD. So, I make sure that I got the [EMAIL PROTECTED] and [EMAIL PROTECTED] created, with permissions and same password. Nothing. But I *can* log on mysql shell. One more info: when the user is set without password, it works fine on PHP. Does anyone can give me a clue of what is happening? Thanks! Roberto -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] recursion in php and mysql
Classes are overrated. :) Bastien Koert wrote: you could make the connection variable global, but the best bet here is to use a class and create a db object that your functions could call Bastien From: Ron Croonenberg [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] recursion in php and mysql Date: Thu, 01 Mar 2007 23:52:54 -0500 Hello all, I wrote an app in php and it uses recursion. Problem I have is that when I connect to a database using mysql_connect($dbhost, $username, $password); and select a table with mysql_select_db($database) I cannot access the table anymore from some function. Now I can connect and select a database in that php function but that means that process happens A LOT and connecting and selecting everytime probably slows down the app quite a bit Is there a way to connect to a database and select a table globally so that I have access to it in ever php function I write ? thanks, Ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php _ Find out the restaurants participating in Winterlicious http://local.live.com/default.aspx?v=2cp=43.658648~-79.383962style=rlvl=15tilt=-90dir=0alt=-1000scene=3702663cid=7ABE80D1746919B4!1329 From January 26 to February 8, 2007 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] auto upload
I think I remember seeing scheduled FTP transfer capability with a couple of backup programs that exist. I uninstalled the one I used, and I don't remember the name, but it worked well enough. Might be worth a google if you don't want to mess with non-gui stuff. (although, console work is like exercise.. it doesn't sound that appealing, but once you start doing it, you will crave more..) Bastien Koert wrote: You could use php+gtk to write it that way, but a simple batch file is the best bet since you could then use task scheduler to run this batch file at scheduled times. Just google dos batch files bastien From: bedul [EMAIL PROTECTED] To: Bastien Koert [EMAIL PROTECTED] CC: php-db@lists.php.net Subject: Re: [PHP-DB] auto upload Date: Fri, 2 Mar 2007 17:13:51 +0700 - Original Message - From: Bastien Koert [EMAIL PROTECTED] To: [EMAIL PROTECTED]; php-windows@lists.php.net; php-db@lists.php.net Sent: Thursday, March 01, 2007 9:05 PM Subject: RE: [PHP-DB] auto upload What about just writing a batch script that opens the ftp services and sends the file? Bastien hmm.. that was a good idea.. is that using php?? or i should use desktop programing?? i better use php since this php milis right.. _ http://local.live.com/default.aspx?v=2cp=43.658648~-79.383962style=rlvl=15tilt=-90dir=0alt=-1000scene=3702663cid=7ABE80D1746919B4!1329 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] recursion in php and mysql
I agree there. Micah Stevens [EMAIL PROTECTED] 03/02/07 12:46 PM Classes are overrated. :) Bastien Koert wrote: you could make the connection variable global, but the best bet here is to use a class and create a db object that your functions could call Bastien From: Ron Croonenberg [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] recursion in php and mysql Date: Thu, 01 Mar 2007 23:52:54 -0500 Hello all, I wrote an app in php and it uses recursion. Problem I have is that when I connect to a database using mysql_connect($dbhost, $username, $password); and select a table with mysql_select_db($database) I cannot access the table anymore from some function. Now I can connect and select a database in that php function but that means that process happens A LOT and connecting and selecting everytime probably slows down the app quite a bit Is there a way to connect to a database and select a table globally so that I have access to it in ever php function I write ? thanks, Ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php _ Find out the restaurants participating in Winterlicious http://local.live.com/default.aspx?v=2cp=43.658648~-79.383962style=rlvl=15tilt=-90dir=0alt=-1000scene=3702663cid=7ABE80D1746919B4!1329 From January 26 to February 8, 2007 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Mysql autentication problem
Micah: I did create the database. Then, I use the: GRANT ALL PRIVILEGES ON db.* TO [EMAIL PROTECTED] IDENTIFIED BY 'password' to do the 2 and 3 steps. FLUSH PRIVILEGES to do the step 4. But the step 5 really does not work... only on the shell or when I remove the password from the user... Roberto Micah Stevens escreveu: Did you give the user permissions to use the database in question? Here's my sequence of actions: . 1) Create DB if it doesn't exist 2) Create the user w/password 3) Give the user permission to use the database. 4) Flush privileges to update the server. 5) login and enjoy. -Micah Roberto F Tavares Neto wrote: Hello, I'm trying to do a very simple thing: create a database and a user to use it. So, initially, I use the web interface phpmyadmin. Logged as root, I created the database, and the user with some password. But, I could not login using phpmyadmin. Either any php-based system could connect to the BD. So, I make sure that I got the [EMAIL PROTECTED] and [EMAIL PROTECTED] created, with permissions and same password. Nothing. But I *can* log on mysql shell. One more info: when the user is set without password, it works fine on PHP. Does anyone can give me a clue of what is happening? Thanks! Roberto -- Roberto Fernandes Tavares Neto Prof. Assistente Departamento de Engenharia de Produção Universidade Federal de São Carlos [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] tel +55 16 3351-9240 http://www.dep.ufscar.br/docentes_desc.php?uid=165 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Mysql autentication problem
Strange. If you look at the users table, is there a password hash in the password field? Roberto F Tavares Neto wrote: Micah: I did create the database. Then, I use the: GRANT ALL PRIVILEGES ON db.* TO [EMAIL PROTECTED] IDENTIFIED BY 'password' to do the 2 and 3 steps. FLUSH PRIVILEGES to do the step 4. But the step 5 really does not work... only on the shell or when I remove the password from the user... Roberto Micah Stevens escreveu: Did you give the user permissions to use the database in question? Here's my sequence of actions: . 1) Create DB if it doesn't exist 2) Create the user w/password 3) Give the user permission to use the database. 4) Flush privileges to update the server. 5) login and enjoy. -Micah Roberto F Tavares Neto wrote: Hello, I'm trying to do a very simple thing: create a database and a user to use it. So, initially, I use the web interface phpmyadmin. Logged as root, I created the database, and the user with some password. But, I could not login using phpmyadmin. Either any php-based system could connect to the BD. So, I make sure that I got the [EMAIL PROTECTED] and [EMAIL PROTECTED] created, with permissions and same password. Nothing. But I *can* log on mysql shell. One more info: when the user is set without password, it works fine on PHP. Does anyone can give me a clue of what is happening? Thanks! Roberto -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] mssql Database name grater than 30 characters
It seems I'm not able to select a MS SQL database that has a name greater than 29 characters? Is their a work around for this? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Mysql autentication problem
- Original Message - From: Micah Stevens [EMAIL PROTECTED] To: Roberto F Tavares Neto [EMAIL PROTECTED] Cc: php-db@lists.php.net Sent: Saturday, March 03, 2007 3:17 AM Subject: Re: [PHP-DB] Mysql autentication problem Strange. If you look at the users table, is there a password hash in the password field? i think this must be reload?? not just flush?? it happen to me.. or perhaps need some times to realy reload?? Roberto F Tavares Neto wrote: Micah: I did create the database. Then, I use the: GRANT ALL PRIVILEGES ON db.* TO [EMAIL PROTECTED] IDENTIFIED BY 'password' to do the 2 and 3 steps. FLUSH PRIVILEGES to do the step 4. But the step 5 really does not work... only on the shell or when I remove the password from the user... Roberto Micah Stevens escreveu: Did you give the user permissions to use the database in question? Here's my sequence of actions: . 1) Create DB if it doesn't exist 2) Create the user w/password 3) Give the user permission to use the database. 4) Flush privileges to update the server. 5) login and enjoy. -Micah Roberto F Tavares Neto wrote: Hello, I'm trying to do a very simple thing: create a database and a user to use it. So, initially, I use the web interface phpmyadmin. Logged as root, I created the database, and the user with some password. But, I could not login using phpmyadmin. Either any php-based system could connect to the BD. So, I make sure that I got the [EMAIL PROTECTED] and [EMAIL PROTECTED] created, with permissions and same password. Nothing. But I *can* log on mysql shell. One more info: when the user is set without password, it works fine on PHP. Does anyone can give me a clue of what is happening? Thanks! Roberto -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Mysql autentication problem
Reloading the grant tables should happen almost immediately unless you have an extremely large set of users, very little memory, or a very slow computer. On 03/02/2007 06:17 PM, bedul wrote: - Original Message - From: Micah Stevens [EMAIL PROTECTED] To: Roberto F Tavares Neto [EMAIL PROTECTED] Cc: php-db@lists.php.net Sent: Saturday, March 03, 2007 3:17 AM Subject: Re: [PHP-DB] Mysql autentication problem Strange. If you look at the users table, is there a password hash in the password field? i think this must be reload?? not just flush?? it happen to me.. or perhaps need some times to realy reload?? Roberto F Tavares Neto wrote: Micah: I did create the database. Then, I use the: GRANT ALL PRIVILEGES ON db.* TO [EMAIL PROTECTED] IDENTIFIED BY 'password' to do the 2 and 3 steps. FLUSH PRIVILEGES to do the step 4. But the step 5 really does not work... only on the shell or when I remove the password from the user... Roberto Micah Stevens escreveu: Did you give the user permissions to use the database in question? Here's my sequence of actions: . 1) Create DB if it doesn't exist 2) Create the user w/password 3) Give the user permission to use the database. 4) Flush privileges to update the server. 5) login and enjoy. -Micah Roberto F Tavares Neto wrote: Hello, I'm trying to do a very simple thing: create a database and a user to use it. So, initially, I use the web interface phpmyadmin. Logged as root, I created the database, and the user with some password. But, I could not login using phpmyadmin. Either any php-based system could connect to the BD. So, I make sure that I got the [EMAIL PROTECTED] and [EMAIL PROTECTED] created, with permissions and same password. Nothing. But I *can* log on mysql shell. One more info: when the user is set without password, it works fine on PHP. Does anyone can give me a clue of what is happening? Thanks! Roberto -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Mysql autentication problem
now you mention it. i hope the same problem will solve. i use in windows (own pc)..not in real-life server.. thx for your repair on my missuderstanding - Original Message - From: Micah Stevens To: bedul Cc: php-db@lists.php.net Sent: Saturday, March 03, 2007 1:48 PM Subject: Re: [PHP-DB] Mysql autentication problem Reloading the grant tables should happen almost immediately unless you have an extremely large set of users, very little memory, or a very slow computer. On 03/02/2007 06:17 PM, bedul wrote: - Original Message - From: Micah Stevens [EMAIL PROTECTED] To: Roberto F Tavares Neto [EMAIL PROTECTED] Cc: php-db@lists.php.net Sent: Saturday, March 03, 2007 3:17 AM Subject: Re: [PHP-DB] Mysql autentication problem Strange. If you look at the users table, is there a password hash in the password field? i think this must be reload?? not just flush?? it happen to me.. or perhaps need some times to realy reload?? Roberto F Tavares Neto wrote: Micah: I did create the database. Then, I use the: GRANT ALL PRIVILEGES ON db.* TO [EMAIL PROTECTED] IDENTIFIED BY 'password' to do the 2 and 3 steps. FLUSH PRIVILEGES to do the step 4. But the step 5 really does not work... only on the shell or when I remove the password from the user... Roberto Micah Stevens escreveu: Did you give the user permissions to use the database in question? Here's my sequence of actions: . 1) Create DB if it doesn't exist 2) Create the user w/password 3) Give the user permission to use the database. 4) Flush privileges to update the server. 5) login and enjoy. -Micah Roberto F Tavares Neto wrote: Hello, I'm trying to do a very simple thing: create a database and a user to use it. So, initially, I use the web interface phpmyadmin. Logged as root, I created the database, and the user with some password. But, I could not login using phpmyadmin. Either any php-based system could connect to the BD. So, I make sure that I got the [EMAIL PROTECTED] and [EMAIL PROTECTED] created, with permissions and same password. Nothing. But I *can* log on mysql shell. One more info: when the user is set without password, it works fine on PHP. Does anyone can give me a clue of what is happening? Thanks! Roberto -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php