Remote Administration
Hi, How would I go about setting up remote administration of MySQL. MySQL is running on Windows 2000 and I will be connecting from Windows XP. I saw something in the MySQL docs about using an SSH client like Secure CRT, but it loses me at the linking OBDC. Any help on this or another similar way to do remote administration is appreciated.. - 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 Administration
There are a few tools you can use to remotely administer MySQL graphically, if that's what you're looking for. You might be interested in MySQL Control Center http://www.mysql.com/products/mysqlcc/index.html although I'm not entirely certain about it's support for secure data transmission. Brian McCain - Original Message - From: C. Reeve [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Friday, March 14, 2003 10:49 AM Subject: Remote Administration Hi, How would I go about setting up remote administration of MySQL. MySQL is running on Windows 2000 and I will be connecting from Windows XP. I saw something in the MySQL docs about using an SSH client like Secure CRT, but it loses me at the linking OBDC. Any help on this or another similar way to do remote administration is appreciated.. - 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
Help with remote Administration
Hi - I have read extensively the MySQL database security chapter in SAMS TY MySQL - and I must be missing something. I have allowed myself to connect from any host by adding a % kev record to my users file and a 10.0.0.142 % record to my hosts file and a % % kev to my db file - when I try and telnet internally to the database I get Host '10.0.0.142 is not allowed to connect to this MySQL server. needless to say all the priv flags are set to 'Y' Is there something I need to do on setup - I can telnet to my Linux server then start mysql -p -u root no problem. I am trying to use mysql front to connect to the database on my pc and the database on the server so that I can transfer what's on my pc over to the Linux server. What have I missed. Thanks Kevin - 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 administration - replication questions
Sorry for the below questions: perhaps are obviously ! 1) Which is the correct tool to administrate a remote mysql db in my network ? 2) In my network I have: server A = MASTER server B,C as slaves running always server D running sometimes used to develop. Every night server A stop service, make a local copy of DATADIR in other place, restart and make a mysqldump opt; which is the method to verify is all slaves had updated own db, from remote in order to delete the obsolete log-file on master ? Because every day I produce arount 200 Mb of log files. - But if I cancel some log-file, when I restart the server D ? It is possibile to move log-file to use after for server-D using then CHANGE MASTER TO MASTER_HOST Other Question: - WINMYSQLADMIN a) there is a way to change the path for this program to read the mysql.err in the correct way ? Because today I have mysql.err in the datadir position wich isi different from the original ? b) it is possible to use WINMYSQLADMIN to connect a remote MYSQL ? - 3.23.53 It is confirmed the 17/10/2002 as the release date ? - LOAD DATA FROM MASTER: in which future version it will be implemented for INNODB ? Tks in advance Massimo - Massimo Petrini c/o Omt spa Via Ferrero 67/a 10090 Cascine Vica (TO) Tel.+39 011 9505334 Fax +39 011 9575474 E-mail [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
mysql remote administration
I am looking for a good programme to admin the database on the remote server. Any advice? Anyone using one they could recommend? I have DBTools and using this I can view the database names on the remote but I cannot connect. I can only connect to the local MySql server. I am using Windows 2000 as my development OS. TIA Mike - 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: mysql remote administration
I think mysqlfront is excellent. http://www.mysqlfront.de/ HTH Andrew Braund -Original Message- From: mike [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 25 September 2001 14:36 To: Mysql Subject: mysql remote administration I am looking for a good programme to admin the database on the remote server. Any advice? Anyone using one they could recommend? I have DBTools and using this I can view the database names on the remote but I cannot connect. I can only connect to the local MySql server. I am using Windows 2000 as my development OS. TIA Mike - 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