MySQL Administrator Tool
I'd like to use MySQL Administrator application remotely from home. Possible? Will I have to open up port 3306? If so, is that safe?
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
MySQL GUI Tool
I just downloaded mysql but i would like to use a tool that would let me create/drop/alter tables , delete, add files etc. Which tool do you think is the BEST one for this?
Mysql Optimization Tool
Is there any tools that you can just run on your server that will automatically optimize your mysql database? Like to speed it up,clean it etc.
Regarding Mysql Front End Tool
could someone please suggest me any mysql front end gui tool which covers features of MySql 5.0.3 beta including stored procedures, views and especially triggers.
Case Tool For Mysql?
the version of erwin i have does not support mysql. is there a gpl-type case tool for mysql?
MySQL Diag Tool For XP
I have MySQL v5 installed on my XP PC. MySQL is used by another program on the same PC. Currently this other program, which I create scripts with in its' native scripting language and run within the program, is coming back with an error that says Error: Table is Read Only. I have used the MySQL GUI admin tool to look at the database that this program uses to see if I can see anything wrong, but it all looks OK. Is there a tool I can use to try and write/access the tables within this programs MySQL database so I can try and identify the offending table and maybe fix the problem.
MySQL Migration Tool
how trustworthy and capable is the Migration Tool? If it says everything went smoothly does it mean that everything went smoothly? Just a little example, Access stores dates on the background in US format although it displays it to me normally in EU/Dutch format (day-month-year). This I could easily check to see if it migrated things well because I'm aware of this issue with Access. But are there any pitfalls I should look out for with this migration tool? Not sure if others have experience with it.
MySQL Monitoring Tool
I have an application thats running 24/7 but every night its loosing connection to the database. When I restart the app in the morning it works fine again. I want to monitor the DB and the server for 24 hours to see what is causing the application to loose connection at night. The provider of the app said that the DB could be tying up too many resources and its loosing connectivity.
MySQL GUI Client Tool
I am looking for a gui-based open source client tool for mysql. Does anybody have any suggestion besides those listed in the first few posts in the beginning of the forum?
MySQL DB Designing And Programming Tool
Are there any software for MySQL developers that you could recommend? I`ve been using MSSQL and its Server Management Studio makes my life easier. I can easily make diagrams during planning and creating DB structure, programming SP, Functions, Triggers... and many more in one place. I`ve downloaded DB Designer but it seems to be good only for creating a diagrams. Of course I can generate the code for my diagram and then paste it to phpMyAdmin but... I`m looking rather for one (complex) tool which could make my work more efficient. Is there any?
Nice Reporting Tool For MySQL
Just found a nice db reporting tool for MySQL. It connects to your database and then you can easely create reports on the fly. It alos allows you to export your data to MS Excel, chart
Tool Compatible With SQLLoader In MYSQL
Are there any tools compatible with SQLLoader in MySQL. I have seen Loader in MAXDB. Is it works in the same way as SQL Loader works. Whether is MAxDB is same as other engines.
Adhoc Reporting Tool For MySQL?
Is there an Open Source reporting tool for mySQL? I would need it to run on Mac OS X. I have a few I am looking at but they are very hard to configure and use. It would be nice to have something like Business Objects or Crystal Reports. (There is a Business Objects version for the OS X but my boss does not want to spend $25K on a reporting tool.)
Mysql Database Builder Tool?
i just want to understand the basics and then try a find my way round. or maybe a website that provides a onsite builder?
Mysql Data Input Tool
i was wondering if there were any free data input tools for mysql instead of using the command line client?
MySql Query Checker Tool
I want to test my web site for the query load checking. Basically mine is a dynamic site where there is lots of traffic. I want to check my query with multiple requests at same time to see how it is affecting my server and how mysqld service is behaving? I have rectified all the things for my query however still some time my mysql service reaches 99% load under high traffic which leads to server crash. So if I can check my query with heavy traffic, then only I ll be able to find actual problem.
Mysql-administrator
Having just upgraded to from Suse 10.0 to 10.1 mysql-administrator will not work. When I try to acccess it I get the following message. linux:/home/grabro # mysql-administrator /usr/bin/mysql-administrator-bin: Symbol `_ZTIN4Glib9InterfaceE' has different size in shared object, consider re-linking /usr/bin/mysql-administrator-bin: Symbol `_ZTIN4Glib10ObjectBaseE' has different size in shared object, consider re-linking /usr/bin/mysql-administrator-bin: Symbol `_ZTIN3Gtk9ListStoreE' has different size in shared object, consider re-linking /usr/bin/mysql-administrator-bin: Symbol `_ZTIN3Gtk5EntryE' has different size in shared object, consider re-linking /usr/bin/mysql-administrator-bin: Symbol `_ZTIN4Glib6ObjectE' has different size in shared object, consider re-linking /usr/bin/mysql-administrator-bin: Symbol `_ZTIN3Gtk6WidgetE' has different size in shared object, consider re-linking *** glibc detected *** /usr/bin/mysql-administrator-bin: free(): invalid pointer: 0x083ca0e0 *** ======= Backtrace: ========= /lib/libc.so.6[0xb716d911] /lib/libc.so.6(__libc_free+0x84)[0xb716ef84] /usr/lib/libstdc++.so.6(_ZdlPv+0x21)[0xb72e6e51] /usr/lib/libstdc++.so.6(_ZNSs4_Rep10_M_destroyERKSaIcE+0x1d )[0xb72c2fed] /usr/lib/libstdc++.so.6....................................
MySQL Administrator 1.1.9
I am running mySQL database version 3.23.58, but I'm using mySQL Administrator 1.1.9 for scheduled backups. When connecting to the database I get a message saying that this version of database is not supported and I might get unexpected behaviour. Am I OK to use this version of mySQL Administrator to backup my database and what unexpected behaviour can I expect ?
MySQL 5.0 Administrator
I have installed a new MySQL 5.0 administrator and since I am so used to deleting a database directly through data folder in my old mysql 3.23 that I do it now also in MySQL 5.0 rather than deleting it through administrator . Now the problem , if the db is deleted not through administrator , it somehow creates a same name cache of the database and it creates a problem if I try to run a sql script because it gives a error of duplicate name. My question is , Is there a way to delete old cache names of the db's so that new db's can be created or a script can run the db which has been created and deleted before .
MySQL Administrator
I am using the MySQL Administrator version 1.1.3. Why is the "Edit Table Data" grayed out when i right click on a table? Is there a way to ungrayed this? Or is this not part of version 1.1.3 anymore?.
Mysql Administrator 1.0.19
when i click catalogs -> my schemata ; right-click on any InnoDB table i am not able to "edit table data" it is grayed out. What do I have to do to be able to edit table data with mysql admin.
MySQL Administrator
My mysql server's version is 4.1.11_win32 and my MySQL Administrator's version is 1.0.19. When I use MySQL Administrator to modify the user administration, it always shows me "Error while storing the user information!".
MySQL Administrator
I want to view the config file in MySQL Administrator but it says I must be connected to localhost to see it. Can I grant myself permissions to be localhost as well?
MySQL Administrator
I am trying to make one of my fields UNIQUE, however the MySQL table editor has the 'index settings' greyed out so I can not select "UNIQUE". How do I make field unique
MySQL Administrator
I have setup MySQL Admin to run scheduled backups on my databases... do I have to keep the program open in order to run them?
MySQL Administrator 1.0.13
I've just downloaded MySQL Administrator 1.0.13 and wish to connect to a mySQL server v3. When connecting I get a message saying that this server version is not support, which I can ignore. Can someone please advise what problems i might encounter if connecting to an unsupported server version ? My main requirement for the mySQL Administrator program is scheduled backups of the data and table structures.
MySQL Administrator
I have a site hosted with a company. I created a testing sub-domain called testlab.swattle.com In this sub I have created a database called swattle_test and I also added a user called swattle_testuser Now when I go into the MySQL Administrator program on my local machine and try to logon to the server I keep getting an error 1045 I put up the screen shots of at http://testlab.swattle.com I also fired off an email to my hosting company
Mysql Administrator
i installed it for windows i can't seem to get it to connect to the database though, the mysql server is on the same machine as this one. for the hostname i typed in localhost port:3308 (is that the right port?) and my root username and password it gave me an error that it couldnt ping to "localhost" i dont get it
Mysql Administrator
How do I edit table data using Mysql administrator. If I click on edit table data the table opens, but then there is no way to edit the table. At the bottom there is a button to apply changes but this is grayed out.
MySql Administrator
I'm using Innodb on windows server 2003.I noticed today that some of my tables are reported by MySql Administrator to have a far greater number of rows than what is return in a query for all rows. For example, one table shows 51,600 rows in Administrator but when I do a SELECT * on the same table from Query Browser I get a mere 5,293 (this is the correct or "real" number of rows) So, what's up? Why is administrator showing so many more rows? I've also noticed that each time I press the refresh button in Administrator the number of rows changes. one time it might be 50k+ then 30k then 43k, etc, etc. being a newb I'm a bit freaked out by all of this. I've heard that innodb can do some funny things, but this seems REALLY strange. I'm sure it's nothing, I just need to hear it from an experienced user
Mysql Commandline Tool -- Port Broken
the "mysql" command allows me to use any ridiculous number after "--port=", even "80", as shown below. I can even use a random string like "abcd" in place of "80". Exactly what I want to do? I need to experiment with the "mysql" commandline tool together with tcpdump. So far, my tcpdump command cannot detect *any* thing about mysql. yes my tcpdump can detect http traffic. yes my tcpdump can detect something when i run "telnet loalhost 3306". ------------- snip --------------- $ mysql -u xxx -pxxxxxx -h localhost --port=80 -vvv Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 8319 to server version: 3.23.58 Reading history-file /home/httpd/vhosts/portal.crpp.servy.net/.mysql_history Type 'help;' or 'h' for help. Type 'c' to clear the buffer.
Is There A MYSQL Tool That Maps/Exports A Database?
I am new to MYSQL. And I have several databases that I need to diagram. Is there a MYSQL tool that will do this for me and allow me to export the diagrams? Or, does it have to be done manually/externally to MYSQL?
Good MySQL Administration And Development Tool
I got MySQL working on my Windows 2003 Server and found a program called Navicat (www.Navicat.com) to create my databases and update them, but it was a trial version and it ran out. I am looking for an administration/development tool similar to Navicat that uses GUI instead of command line but is Free or really cheap. If I had an extra $125 I would buy the Navicat, but unfortunately I dont, so I was wondering if there was a Free alternative?
MySQL Administrator & QueryBuilder
I have installed MySQL 4.0, MySQL Administrator and Querybuilder. In general all functions well. But two things do not function, which I would like to, because I need them: (1) In the menu of Querybuilder --> Tools the link to Administrator is greyed out. How can I make it function? (Administrator to querybuilder is ok) (2) More Important: in Administrator, loggedin as root with all grants, the (context-)menue eintry "edit tables values" is greyed out on any table. - How to make it function? How to edit values in the tables then? (System: WXP-SP2, logged in with admin-rights)
New User [MySQL Administrator]
I'm getting an error when adding a new user: After I've entered MySQL User: XXX-WEB, Password and Confirm Password, I click Apply Changes a message box shows MySQL Administrator Exception: Error while storing the user informaiton. The user might have been deleted. Please refresh the user. I've refreshed, sooo many times... I think I may have messed up the MySQL schema and may have damaged some locks.
MySQL Administrator Disabled
I've just installed MySQL 4.1.5 gamma following the instructions in the documention, and MySQL Administrator 1.0.13 on my home machine. I'm the only user :( ! MySQL seems to be working OK but when I use the Administrator program, which appears to connect to the MySQL service OK, all of the Startup Variable options are disabled on all the panels. I thought I'd be able to tweak these options from here.
Cannot Connect To MySQL Administrator
I am running MySQL 4.1 on Windows XP. I am trying to connect to MySQL administrator. But it is giving the following error when I try to connect: Could not connect to the specified instatnce. MySQL error number 2003 Can’t connect to MySQL server on ‘localhost’(10061) When I run ‘MySQL Command Line Client’ it asks me to enter the password and it takes me to ‘mysql>’. What do I have to do to connect to MySQL Administrator? Or what am I missing?
Having Problems Getting Mysql-administrator To Run
When I run mysql-administrator I get the following error. I installed the generic rpm on a Fedora Core 3 system. I have the latest version of pango. /usr/bin/mysql-administrator-bin: symbol lookup error: /usr/bin/mysql-administrator-bin: undefined symbol: pango_renderer_get_type
MySQL Administrator For Web Administration
Can MySQL Administrator (from this website) be used to administer MySQL database over the web (a far off machine accessible via IP). If not, what is(are) other free software(s) that can easily do it for Windows platform.
MySql Administrator Rules
I find that MySql Administrator is a much more powerful and intuitive way to access databases than phpMyAdmin. I think I will be using this for all my projects now.
Setting Up MySQL Administrator
I just downloaded MySQL Administrator and am trying to install it. I'm trying "localhost" and "root" for Server Host and Username, along with the default setting for Port, 3306. However, I don't have a clue what a "Stored Connection" is. What am I supposed to enter there?
MySQL Administrator Logs
I have been using mysql database on two servers for about three years now. I recently downloaded the new MySQL Administrator and I love it. My only problem is I cannot see logs. I am connected on the local machine and cannot find the option to turn on the logs or anything. I have looked through my.ini and everywhere.
MySQL Administrator Password
I have just installed mySQL 5 Community Edition and also all its tools viz. Administrator, Migration etc.. Presently I have installed it on a machines with no other machines connected to it. I also selected "Developer Machine" option while installing it. When I open mySQL Administrator, it asks for Username and Password. I remember the password, but what is the default Username and Schema Name. If I am running on a standalone machine, what to type in "Server Host" in the administrator window.
Mysql Administrator Issue
I have installed MYSQL 4.1.7, administrator & control center on Windows XP. Mysql server runs fine, I can connect to Mysql administrator or windows command line client. My problem is: 1] While trying to connect in MYSQL Control Center , I get error: === Error 2003: Can't connect to Mysql server on 'THESERVER' (10061) === [host name is fine, port no is also fine, then where I am doing wrong.... ???] 2] I can connect to Mysql Administrator , BUT.. 1) Startup Variables are disabled [I can't alter them...] 2) Clicking SERVICE CONTROL page stops the service and then I could not restart the service again. [seems goophy to me... why its like that ???] 3) While surfing in Mysql Administrator, after a while I get error message: === Mysql Error Number 1226 User 'root' has exceeded the 'max_questions' resource (Current value 100)=== [I set max question value to default (0) or any number, it dosent make difference, and I can't work on administrator unless I re-login] 3] I have created a .sql file containing all tables & relationships I want. How can I load that file in Mysql database. [How can I call/import that .sql file to create tables in Mysql database ??] I am stuck in above little mess, would you please help me out from above problem ?
Installing Mysql-administrator
(This is also posted in the install forum) For some reason I can't get the rpm to install so I tried using the tarball and when I do this, the /opt/mysql-administrator-1.0.19/bin directory does not get created. Command I used to install mysql-administrator: shell> tar --directory=/opt -xzvf mysql-administrator-1.0.19.tar.gz Does anyone have any suggestions or another way to install this application on Linux? ...or am I missing a step? The rpm is preferred, but anything that works would be great.
Tool For Converting MySQL Export Into SQL Server 2005
I'm changing hosts and I've got the opportunity to swap DBs over to SQL Server 2k5. I've got a SQL dump from a mySQL 4.0.x install. Of course when I try to import that file into SQL Server it breaks. Does anyone know of a tool that can convert this SQL file into a structure that can be understood by SQL Server?
MySQL Catalogs Not Listing In Administrator
I have mysql 4.1 installed and working well. The problem is that neither Administrator or Query Browser will list my catalogs. The catalogs exist and I can run queries against them using php. Any ideas on what is causing my catalogs to not show up?
|
TRACKER
