DeveloperSide.NET Forums
July 19, 2019, 02:17:47 PM *
Welcome, Guest. Please login or register.

Login with username, password and session length
News:
 
  Home Help Search Login Register  
  Show Posts
Pages: [1] 2 3
1  DeveloperSide.NET / Web.Developer Server Suite Community Edition,
Public Support Forum
/ Can't get phpmysql to load
on: November 17, 2005, 03:42:13 AM
I can't log in at the log in. So how do I check for the password for root?
2  DeveloperSide.NET / Web.Developer Server Suite Community Edition,
Public Support Forum
/ Can't get phpmysql to load
on: November 16, 2005, 09:58:11 PM
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Sharon>cd\www\mysql\bin

C:\www\mysql\bin>mysqladmin -u root -pnew=password sarahb
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'

C:\www\mysql\bin>mysqladmin -u root -pnew-password sarahb
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'

C:\www\mysql\bin>mysqladmin -u root password trade new-password sarahb
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

C:\www\mysql\bin>mysqladmin -u root -p neww-password
Enter password: ******
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'

C:\www\mysql\bin>mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: N
O)

C:\www\mysql\bin>mysqladmin -u root
mysqladmin  Ver 8.41 Distrib 4.1.14, for Win32 on ia32
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Administration program for the mysqld daemon.
Usage: mysqladmin [OPTIONS] command command....
  -c, --count=#       Number of iterations to make. This works with -i
                      (--sleep) only.
  -#, --debug[=name]  Output debug log. Often this is 'd:t:o,filename'.
  -f, --force         Don't ask for confirmation on drop database; with
                      multiple commands, continue even if an error occurs.
  -C, --compress      Use compression in server/client protocol.
  --character-sets-dir=name
                      Directory where character sets are.
  --default-character-set=name
                      Set the default character set.
  -?, --help          Display this help and exit.
  -h, --host=name     Connect to host.
  -p, --password[=name]
                      Password to use when connecting to server. If password is
                      not given it's asked from the tty.
  -W, --pipe          Use named pipes to connect to server.
  -P, --port=#        Port number to use for connection.
  --protocol=name     The protocol of connection (tcp,socket,pipe,memory).
  -r, --relative      Show difference between current and previous values when
                      used with -i. Currently works only with extended-status.
  -O, --set-variable=name
                      Change the value of a variable. Please note that this
                      option is deprecated; you can set variables directly with
                      --variable-name=value.
  --shared-memory-base-name=name
                      Base name of shared memory.
  -s, --silent        Silently exit if one can't connect to server.
  -S, --socket=name   Socket file to use for connection.
  -i, --sleep=#       Execute commands again and again with a sleep between.
  -u, --user=name     User for login if not current user.
  -v, --verbose       Write more information.
  -V, --version       Output version information and exit.
  -E, --vertical      Print output vertically. Is similar to --relative, but
                      prints output vertically.
  -w, --wait[=#]      Wait and retry if connection is down.
  --connect_timeout=#
  --shutdown_timeout=#

Variables (--variable-name=value)
and boolean options {FALSE|TRUE}  Value (after reading options)
--------------------------------- -----------------------------
count                             0
force                             FALSE
compress                          FALSE
character-sets-dir                (No default value)
default-character-set             (No default value)
host                              (No default value)
port                              3306
relative                          FALSE
shared-memory-base-name           (No default value)
socket                            C:/www/tmp/mysql.sock
sleep                             0
user                              root
verbose                           FALSE
vertical                          FALSE
connect_timeout                   43200
shutdown_timeout                  3600

Default options are read from the following files in the given order:
C:\WINDOWS\my.ini C:\WINDOWS\my.cnf C:\my.ini C:\my.cnf
The following groups are read: mysqladmin client
The following options may be given as the first argument:
--print-defaults        Print the program argument list and exit
--no-defaults           Don't read default options from any options file
--defaults-file=#       Only read default options from the given file #
--defaults-extra-file=# Read this file after the global files are read

Where command is a one or more of: (Commands may be shortened)
  create databasename   Create a new database
  debug                 Instruct server to write debug information to log
  drop databasename     Delete a database and all its tables
  extended-status       Gives an extended status message from the server
  flush-hosts           Flush all cached hosts
  flush-logs            Flush all logs
  flush-status          Clear status variables
  flush-tables          Flush all tables
  flush-threads         Flush the thread cache
  flush-privileges      Reload grant tables (same as reload)
  kill id,id,...        Kill mysql threads
  password new-password Change old password to new-password, MySQL 4.1 hashing.
  old-password new-password Change old password to new-password in old format.

  ping                  Check if mysqld is alive
  processlist           Show list of active threads in server
  reload                Reload grant tables
  refresh               Flush all tables and close and open logfiles
  shutdown              Take server down
  status                Gives a short status message from the server
  start-slave           Start slave
  stop-slave            Stop slave
  variables             Prints variables available
  version               Get version info from server

C:\www\mysql\bin>
3  DeveloperSide.NET / Web.Developer Server Suite Community Edition,
Public Support Forum
/ Can't get phpmysql to load
on: November 16, 2005, 11:14:17 AM
mysqladmin -u root new-password version (mysqladmin:connect to server at localhost failed error 'Access denied for user 'root' @' localhost <using password: NO> )


mysqladmin -u root =p version  * i put both ways ju;st mysqladmin -u root -p the mysql syntax comes up,and if i put  mysqladmin -u root -p sarahb pn the next line ( Enter password:)
4  DeveloperSide.NET / Web.Developer Server Suite Community Edition,
Public Support Forum
/ Can't get phpmysql to load
on: November 16, 2005, 03:26:56 AM
when i type

at the prop  i typed

mysqladmin -u root password new-password

I get the ouput  mysqladmin:connect to server at localhost failed
error 'Access denied for user 'root' @' localhost <using password: NO>

and type

mysqladmin -u root password new-password sarahb

get the same as above


type only mysqladmin -u root

it is all the mysql syntax for the command line


i also tried

mysqladmin -u root -p sarahb
then at the next line it asks for
Enter password: I type here Sarahb


I get the error above except the

mysqladmin:connect to server at localhost failed
error 'Access denied for user 'root' @' localhost <using password:YES>


It seems as if the password got set but I am entering the wrong password.
5  DeveloperSide.NET / Web.Developer Server Suite Community Edition,
Public Support Forum
/ Can't get phpmysql to load
on: November 15, 2005, 02:59:48 AM
Did everything you said still access is denied for user on local etc.


 
Quote
type mysqladmin -u root password new-password sarahb

Quote
mysqladmin -u root -p


What else can I do at this point"
6  DeveloperSide.NET / Web.Developer Server Suite Community Edition,
Public Support Forum
/ Can't get phpmysql to load
on: November 14, 2005, 02:56:20 AM
I am sorry to bother again about this syntax but I cd to \www\mysql\bin and type mysqladmin -u root password new-password sarahb


tried
mysqladmin -u root password sarahb

it says access denied for user root @ local host


??
7  DeveloperSide.NET / Web.Developer Server Suite Community Edition,
Public Support Forum
/ Can't get phpmysql to load
on: November 13, 2005, 10:22:05 PM
That worked thanks! But can you remind me how to set up the password. I removed the old version of your suite and installed the latest and like I said have been programming in another environment and forgot how to set it up.  Thanks for your help!
8  DeveloperSide.NET / Web.Developer Server Suite Community Edition,
Public Support Forum
/ Can't get phpmysql to load
on: November 13, 2005, 01:55:01 PM
I have not used phpmysql with mysql for awhile and installed mx flash and coldfusion. Then when I tried to get www.localhost/phpmyadmin  it can't be found. Does anybody know what happen? Thanks!
9  DeveloperSide.NET / Web.Developer Server Suite Community Edition,
Public Support Forum
/ Uploading to a web host
on: November 24, 2004, 02:00:35 PM
Hi,

My question is about uploading the database and code  to a web hosting site.  I have it  running with youir suite of apache2, mysql and phpmyadmin on my xp home edition.


I have never done this so need a few questions answered.  

I am uploading one database and the webroot directory that has all the code I was told I could not upload the php.ini.  

So how do I connect to the database????

Do I make a file and what kind would it be?? Does it matter what directory I put the database and webroot on the web host

Is there anything else I should change to run on their site other that in the code for the path.  


That you for your help and time and patience.  


Sharon
10  DeveloperSide.NET / Web.Developer Server Suite Community Edition,
Public Support Forum
/ Mysql 5.0
on: November 05, 2004, 09:34:28 PM
Quote
Are you saying you want to upgrade to SP2?


No, I am saying that I have windows xp home edition and i get the automatic updates from windows saying I need to update to service pak 2 for windows xp home edition and I thought there would be a problem with the suite I downloaded from your site and this service pak.  


Quote
Then you will need to configure the firewall that comes with SP2 to pass ports 3306 and 80.


Is this still my answer above.

I want to upgrade to mysql 2.0 for the stored procedures it has.

Sharon
11  DeveloperSide.NET / Web.Developer Server Suite Community Edition,
Public Support Forum
/ Mysql 5.0
on: November 05, 2004, 05:16:42 PM
I would like to upgrade to 5.0 for the stored procedures. Has anybody done this and if so, had any problems.  


Another question I have is there is an automatic update for my computer
which is the service pack 2.
I have windows xp home edition with the suite running from this site.  

Will there be any problems with this and the apache software or anything else?

Sharon
12  DeveloperSide.NET / Web.Developer Server Suite Community Edition,
Public Support Forum
/ mail function not working at. all header problem?
on: November 05, 2004, 03:14:19 AM
That did it  :)

Thank you so........ooo much

The username and passworld along with changing the outgoing to  mailhost.worldnet.att.net did it!



Thanks again
Sharon
13  DeveloperSide.NET / Web.Developer Server Suite Community Edition,
Public Support Forum
/ mail function not working at. all header problem?
on: November 05, 2004, 01:52:12 AM
I took the ; out before the sendmail_from = s.buggle@.att.net
and changed it to sendmail_from = s.buggle@worldnet.att.net

This is the whole page of mailtest.php
<?
$recipient = "s.buggle@worldnet.att.net";
$subject = "Test E-mail Message";
$message = "This is the e-mail message.";
$senderemail = "r.buggle@att.net";
mail($recipient,$subject,$message,$senderemail) or die ("Failure");

 ?>
In the error file it has
 [client 127.0.0.1] PHP Warning:  mail(): Failed to connect to mailserver at &quot;postoffice.worldnet.att.net&quot; port 25, verify your &quot;SMTP&quot; and &quot;smtp_port&quot; setting in php.ini or use ini_set() in C:\\www\\webroot\\mailtest.php on line 6


Do you have any suggestions?
14  DeveloperSide.NET / Web.Developer Server Suite Community Edition,
Public Support Forum
/ mail function not working at. all header problem?
on: November 04, 2004, 07:42:08 PM
Having problem with mail fucntion, did this little test and it is giving me the error below in the log directory.

Here is the code:

<?
$recipient = "s.buggle@att.net";
$subject = "Test E-mail Message";
$message = "This is the e-mail message.";
$senderemail = "From:r.buggle@att.net";
mail($recipient , $subject,$message);

 ?>
I have tried it various ways with the  from:etc) or without.
I read another email about the same subject and said to go to the php file and change the code here is that below

SMTP = postoffice.worldnet.att.net
smtp_port = 25

; For Win32 only.
;sendmail_from = s.buggle@.att.net


Help!



[client 127.0.0.1] PHP Warning:  mail(): &quot;sendmail_from&quot; not set in php.ini or custom &quot;From:&quot; header missing in C:\\www\\webroot\\mailtest.php on line 6
15  DeveloperSide.NET / Web.Developer Server Suite Community Edition,
Public Support Forum
/ reading file using php
on: October 04, 2004, 09:44:15 AM
Does anybody know how to just read a txt file that has all states below

ALASKA,AK


and parse them into two variables line by line

insert into table that is in mysql.



$filename = "c:/www/webroot.states.txt";
if (file_exists($filename));
 {
$array = file($filename);

foreach ($array as $row){

$thefirst = explode($row,",");
$variable1 = $thefirst[$i];
$variable2 = $thefirst[$i];
print count($array);

}
Pages: [1] 2 3
Powered by MySQL Powered by PHP Powered by SMF 1.1.9 | SMF © 2006-2009, Simple Machines LLC Valid XHTML 1.0! Valid CSS!