Re: Remote admin of MySQL from Win 2K
That was the answer and solution to my MySQL problem!! Many thanks Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Remote admin of MySQL from Win 2K
/me uses mySQL-Front and PHPMyAdmin for all his Admin tasks .b > -Original Message- > From: Gerald Clark [mailto:[EMAIL PROTECTED]] > Sent: 20 May 2002 15:45 > To: Todd Cary > Cc: David Ayliffe; 'MYSQL-List (E-mail)' > Subject: Re: Remote admin of MySQL from Win 2K > > > It is asking for myslq's root password, not the su password. > If you have not set it yet, skip the -p option. > > > Todd Cary wrote: > > >YES! I was missing something: Telnet!! I can log in *BUT* I am > unable to > >change the MySQL password. > > > >mysqladmin -h www.myhost.org -u root -p password 'new_password' > asks me for the > >password and when I use the root password (su password), I get > Access Denied. > > > >Todd > > > >-- > >Todd Cary > >Ariste Software > >2200 D Street Extension > >Petaluma, CA 94952 > >707-773-4523 > >[EMAIL PROTECTED] > > > > > > > >- > >Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > >To request this thread, e-mail <[EMAIL PROTECTED]> > >To unsubscribe, e-mail > <[EMAIL PROTECTED]> > >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Remote admin of MySQL from Win 2K
It is asking for myslq's root password, not the su password. If you have not set it yet, skip the -p option. Todd Cary wrote: >YES! I was missing something: Telnet!! I can log in *BUT* I am unable to >change the MySQL password. > >mysqladmin -h www.myhost.org -u root -p password 'new_password' asks me for the >password and when I use the root password (su password), I get Access Denied. > >Todd > >-- >Todd Cary >Ariste Software >2200 D Street Extension >Petaluma, CA 94952 >707-773-4523 >[EMAIL PROTECTED] > > > >- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Remote admin of MySQL from Win 2K
YES! I was missing something: Telnet!! I can log in *BUT* I am unable to change the MySQL password. mysqladmin -h www.myhost.org -u root -p password 'new_password' asks me for the password and when I use the root password (su password), I get Access Denied. Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Remote admin of MySQL from Win 2K
Unless I am missing something (and that is very likely), MySQL is installed on the "closed" Yahoo RaQ-4 Cobalt server. Now on my Linux server*, I had to go in as root and enter a user and give what servers are allowed to access it. With the yahoo server, the *only* access is via a Web page. When I tried to access MySQL mysqladmin, it said the the URL that was attempting the access was not allowed. Of course, the URL was that of my ISP. I have told my client that either they need a server with full access rights *or* put the DB on my Linux server (not really on the top of my list - not my business). Todd * This is the first time I have ever used MySQL and I am trying to see if I can around not being able to access Interbase (my usual DBMS). -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Remote admin of MySQL from Win 2K
Told my client that dealing with Yahoo would have it's problems...they will not do anything to the server once they wipe the disk clean and install RaQ-4 :-) !! Thanks for the MySQL advice.. Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Remote admin of MySQL from Win 2K
Uhh, Hmm you probably are the owner, aren't you? (Wasn't reading that as a server, was reading just a name) Contact your supplier or sun directly (whomever installed the software) and ask them for the root password for your mysql server ( default installation however does not require a password, it doesnt have a password ) Later you can use the mysql client GRANT function to create users for mysql ( or whatever your interface calls the user permission process) -Original Message- From: Luc Foisy [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 4:23 PM To: 'Todd Cary'; MYSQL-List (E-mail) Subject: RE: Remote admin of MySQL from Win 2K Do you want to access the whole MySQL server? Or do you just want to administer a single database on a MySQL server? You could contact the owners of the database server and ask them to create a user for you to be able to connect to your MySQL database. You do not need to be root to administer a mysql database, it has its own permissions tables. -Original Message- From: Todd Cary [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 3:56 PM To: [EMAIL PROTECTED] Subject: Re: Remote admin of MySQL from Win 2K Just installed MySQL Manger...great! But I cannot get into a Cobalt RaQ-4 - problem due to my inability to be root since I can only admin the server by a Web page. H Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Remote admin of MySQL from Win 2K
Do you want to access the whole MySQL server? Or do you just want to administer a single database on a MySQL server? You could contact the owners of the database server and ask them to create a user for you to be able to connect to your MySQL database. You do not need to be root to administer a mysql database, it has its own permissions tables. -Original Message- From: Todd Cary [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 3:56 PM To: [EMAIL PROTECTED] Subject: Re: Remote admin of MySQL from Win 2K Just installed MySQL Manger...great! But I cannot get into a Cobalt RaQ-4 - problem due to my inability to be root since I can only admin the server by a Web page. H Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Remote admin of MySQL from Win 2K
Just installed MySQL Manger...great! But I cannot get into a Cobalt RaQ-4 - problem due to my inability to be root since I can only admin the server by a Web page. H Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Remote admin of MySQL from Win 2K
Have you tried using phpMyAdmin?? It allows you to connect to several different host quiteeasily. You can download it at: http://www.phpwizard.net/projects/phpMyAdmin/index.html And actually any of the GUI front end apps for M$ should be able to connect to a remote server (I think). You just have tomake sure your MySQL permissions allow for outside users to log on. -Nick > Is there an appl for administering MySQL on a remote Linux server from > a Win 2K client? > > Todd > > -- > Todd Cary > Ariste Software > 2200 D Street Extension > Petaluma, CA 94952 > 707-773-4523 > [EMAIL PROTECTED] > > > > - > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail To > unsubscribe, e-mail > Trouble > unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Remote admin of MySQL from Win 2K
You might try MyCC ( available at mysql.com somewhere) -Original Message- From: Todd Cary [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 1:54 PM To: [EMAIL PROTECTED] Subject: Remote admin of MySQL from Win 2K Is there an appl for administering MySQL on a remote Linux server from a Win 2K client? Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Remote admin of MySQL from Win 2K
Is there an appl for administering MySQL on a remote Linux server from a Win 2K client? Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php