Re[2]: [PHP] STrange Problem
Hello PHP, Friday, March 12, 2004, 6:25:09 PM, you wrote: P OK, I do get the following error. P 1044: Access denied for user: '@localhost' to database 'mydatabase' P Even though I specify the user in mysql_connect, for some reason, P mysql_select_db is trying to user a blank user, P Any Ideas? You said that you use apache as the username for MySQL - is this something you've configured yourself? If not, it should be root and the password should be blank unless you have also set that? In which case it's missing from your connect command. -- Best regards, Richard Davey http://www.phpcommunity.org/wiki/296.html -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: Re[2]: [PHP] STrange Problem
Yes, I have it configured to run as apache. But, as I mentioned, I have no problems accessing the database and running querys against it, it is only the mysql_select_db function that fails. Hello PHP, Friday, March 12, 2004, 6:25:09 PM, you wrote: P OK, I do get the following error. P 1044: Access denied for user: '@localhost' to database 'mydatabase' P Even though I specify the user in mysql_connect, for some reason, P mysql_select_db is trying to user a blank user, P Any Ideas? You said that you use apache as the username for MySQL - is this something you've configured yourself? If not, it should be root and the password should be blank unless you have also set that? In which case it's missing from your connect command. -- Best regards, Richard Davey http://www.phpcommunity.org/wiki/296.html -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re[2]: [PHP] STrange Problem
Hello trlists, Friday, March 12, 2004, 6:37:34 PM, you wrote: tcc Configuring a MySQL database with a blank root password sounds like a tcc potential security risk to me ... It is, but if he hasn't modified it otherwise, that's what it'll be. Also for local development purposes, there is no harm in it. -- Best regards, Richard Davey http://www.phpcommunity.org/wiki/296.html -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: Re[2]: [PHP] STrange Problem
On 12 Mar 2004 Richard Davey wrote: It is, but if he hasn't modified it otherwise, that's what it'll be. Also for local development purposes, there is no harm in it. Agreed, as long as he's not connected so someone can try to connect to the MySQL port. -- Tom -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re[2]: [PHP] Strange problem...
Hello Daniel, $date = $birth_year.-.$birth_month.-.$birth_day; And you can try inserting such kind o' date to a DATETIME field. There's an alternative way: $time = mktime(0,0,0, $birth_month, $birth_day, $birth_year); That would return a unix timestamp that can be written to a BIGINT field and in future returned by using date(m.d.Y, $time) from your sql query. He. DA Thanks Jim. DA but how would i actually do that? I have studied the date() function in the DA manual - but canĀ“t find a way of inserting a set value from user input as a DA valid date. DA - D Ivan 'Faeton aka xetrix' Danishevsky ICQ(240266) [EMAIL PROTECTED] www.xemichat.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]