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.
View Complete Forum Thread with Replies
Related Forum Messages:
MySQL And Codd's Rules
Could anyone point me to any articles showing an analysis of Codds Rules in relation to MySQL? Like how mysql does or does not confirm to each rule?
View Replies !
Setting MYSQL Rules
i got table with one column of dates - time(). how i can set a rule inside the mysql -not on asp pages... the rule- take the maximum value and delete all the values that "smaller" than the maximum value, in 20 min
View Replies !
How To Represent Calendar "rules" In MySQL
I can't seem to come up with a decent way to represent calendar "rules" in a MySQL table. Ideally I want a calendar that somebody can enter items as wide ranging as: April 18, 2009, from 6PM to 7PM Every Monday-Friday, 9-5PM Every First Saturday of the Month, 10PM to 4AM (on the next day) Every First and Third Tuesday of the Month, 4PM to 8PM Every July 4th, 2PM to 11PM The 7th of Every Month, 5AM to 6AM I have thought of a lot of different possibilities. One thing I know is that I need the following columns in a table, for weekly schedules. Code: sundayBegin sundayEnd mondayBegin mondayEnd tuesdayBegin tuesdayEnd wednesdayBegin wednesdayEnd thursdayBegin thursdayEnd fridayBegin fridayEnd saturdayBegin saturdayEnd EDIT: One idea I had was to have a main table for calendar entries, and then 3 subtables to represent the 3 main rules that might be used to represent a calendar schedule: 1. one with beginning/ending timestamps and times for specific days (i.e. what I had above) 2. one with specific columns for day/month which would represent repetition for a single day every month (if month was empty) or every year on the given month (if month was not empty) 3. one with specific columns for weekday and week offset, which could be used to specify "the second tuesday of every month" etc. These would all be LEFT JOIN'd on to the main calendar table using their own matching conditions, and whenever searching, I would GROUP BY the id of the main calendar table.
View Replies !
Signature Rules
I am developing a web authoring tool and want to link my app to the MySql database. So it is very important for me to learn how to use MySql I would like to learn MySql by using my application which makes websites to document what I know about MySql and putting this information on my Website. In other words some of my website will be dedicated to MySQL.
View Replies !
What Are The Rules For Dropping Tables?
I have run into a weird problem. Sometimes when I do this: DROP TABLE IF EXISTS `This_Is_My_Table` if won't work, but if I'll do (e.g. without the quotes) DROP TABLE IF EXISTS This_Is_My_Table the table will get dropped fine. So what are the rules? Do I need the quotes? Do I need the quotes on statements such as alter table `tablename` alter column `column_name`?
View Replies !
Enforce Password Rules
I want to know if there is a way to enforce password rules for the root user account for MySQL Server? We need this to satisfy our security requirements for our system. Can anyone help me out?
View Replies !
Modelling Recurrence Using Scheduling Rules
I'm currently up against a common problem in application design - scheduling of recurring events. I've read through a lot of literature on the subject (including the threads I could find here) and there are lots of different methods. Each rule (what Fowler calls mysqloral Expressions), have a different set of arguments. "Second Monday in a month" for example can be stored as (1, 2), where 1 represents Monday and 2 represents the 2nd occurence. "11th of the month" can be stored simply as (11). "Every 2 months" requires a start month and an interval ("2008-08-01", 2). To complicate matters, set operations such as union, intersection and difference can also occur, whose functionality I need. Are there any general patterns of storage for storing these kinds of rules, which are similar but have different parameters? I'd quite like to avoid column names like "arg1", "arg2" if possible. I'm not adverse to having a table per rule type, i.e. day_in_month, day_of_month, month_interval tables, however, it is the set operations storage that confuses me the most. The data will obviously have to be queried regularly to see if a date matches all the rules. If I have to write a stored proc, I'd rather just do that in application code to keep it portable. At the moment, the hacky solution I have is stored a serialized PHP object that represents a rule set. A less worse option could be using an XML datatype, but ideally I'd like a normalised set-based solution.
View Replies !
Rules Of Thumb For Creating Index
I'm redoing the database indexes because of some changes to the PHP's SQL query. So, I'm wondering what's the rules of thumb here for creating an index? I thought it would help with someone who are experienced here because I started using MySQL for hte first time almost a year ago and I'm not alway right.. :-) 1) Create an Index only for one of those fields after the "WHERE" cause that doesn't contain a primary key or secondary key.. Correct? 2) Is there an effective or efficient way to create an Index that will index the 2 fields if the "WHERE" clause use 3 or more fields?
View Replies !
Users Password Enforcement Rules
I am wondering if there is a way to enforce password rules on mysql users to satisfy my security person? Is there a way to specify password length, complexity, etc? I am using mysql server 5.0.51 on RHEL4 Also I am using the general query log for logging. The only requirement I have wr to logging is success failure atmysqlts at authentication to mysql......general query log provides that and TOO much more. Is there a way to log authentication only and not queries?
View Replies !
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....................................
View Replies !
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 .
View Replies !
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.
View Replies !
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.
View Replies !
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 ?
View Replies !
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.
View Replies !
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?
View Replies !
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.
View Replies !
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.
View Replies !
Starting With MySQL Administrator
I have just installed XAMPP on Ubuntu, and then i have installed MySQL Admin. After open MySQL Admin, i can see a window with "Server hostname", "Username" and "Password". I have written this: Server hostname: localhost Username: (blank) Password: (blank) I don't write any Username or Password because i can enter to MySQL server just with "mysql".
View Replies !
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.
View Replies !
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)
View Replies !
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.
View Replies !
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
View Replies !
Setting Up MySQL Administrator (have WHM)
I would like to set up MySQL Administrator. (MySQL is taking up 50+ % of my CPU, and I'm not sure why...) I'm having difficulty connecting to my MySQL db. I'm fairly sure I have the correct username and password. For the host, I just used my server's IP and for the Port, I have 3306. When I try to connect, I receive the following error... MySQL Error Number 1130 Host '<IP address>' is not allowed to connect to this MySQL server. I tried adding <IP address> to the MySQL Access Hosts using WHM, but don't think it's working. In fact, I think when I initially tried it... my phpmyadmin stopped working and I had to go in manually to the config file and fix it up.
View Replies !
Installing Mysql-administrator On Redhat
I am unable to install mysql-administrator on Redhat AS 4. #rpm -i mysql-administrator-1.1.6-1.i386.rpm erreur: Dépendances requises: libstdc++.so.6(GLIBCXX_3.4.4) est nécessaire pour mysql-administrator-1.1.6-1.i386 But I already have the library: #ls -l /usr/lib/libstdc++.so.6 lrwxrwxrwx 1 root root 18 nov 16 17:27 /usr/lib/libstdc++.so.6 -> libstdc++.so.6.0.3 Anybody have had such installation problem?
View Replies !
Error Running MySQL Administrator On RH8
I have downloaded the latest version of mysql administrator 1.0.18. I followed the installation instructions, but when i am unable to run the program. I get an error saying: ./mysql-administrator-bin: relocation error: ./mysql-administrator-bin: undefined symbol: gdk_display_get_type Do you have any clue about what is happening?
View Replies !
MySQL Administrator GUI Running Slowly... WHY?
We have created an instance or schema that contains over 14000 tables. It is a lot of tables. When we attempt to browse the tables in the GUI it literally takes 5 minutes or more for it to come back. Granted when using the Microsoft SQL Server Management Studio it is slow but doesn't take that long. After about a minute or so it gives the list and is kind of slow to scroll. Can this be fixed by optimizing the database? Is this just too many tables for mySQL to handle?
View Replies !
MySQL Administrator Client Installation
Can MySQL administrator installed on a client machine which has no MySQL database installed? We have two MySQL installation on Linux. I want to check things from my desktop which is Windows via some graphical administration software. Any possibility? When I try to connect one of the server I got error. Admin tool added my computer's domain suffix after the user name which I typed in...
View Replies !
Settings Up Mysql Administrator With 1and1
I just created a 1and1 account and configured WordPress to work with it. Now I am trying to access the backup with a GUI tool and setup MySQL Administrator on my local box. I set this up using the same settings that I entered while configuring the blog but I keep getting the error message: Could not connect to the specific instance. MySQL error number 2005 and if I press ping it says: Could not resolve hostname. Has anyone setup this tool to work with 1and1 before? Does anyone know what this issue could be?
View Replies !
Trouble Logging Into MySQL Administrator
I've installed MySQL and it appears to running properly because I can enter data in the command line format but I'd like to use the graphical user interface of MySQL Administrator. When I try to log in, I can not get through. Is there someplace on the MySQL website that I can go to send me a reminder of the information I used to set-up the server and how to properly fill-out this form? When I hit contol and skip, it shows that my server is running. I did save the original information I gave on the website during the server configuration and download procedures but when I try different combinations of this information, I'm still not able to access the Administrator functions.
View Replies !
Adding Users With MySQL Administrator
how do you add a new user to MySQL? I am using the Administrator (1.1), MySQL 5.0 and clone the 'root' user, complete the name and a password, and get a message 'Error while storing the user infromation. The user might have been deleted. Please refresh the user list' When I refresh the user list the new user entry disappears! Same thing happens when using the 'New User' button This is a fresh install - any ideas anyone??
View Replies !
MySQL Administrator - Password Storage
I am scheduling backups using MySQL Administrator and have to set the Password Storage options for it to work. What I am wondering is how does the 'OS Specific' password storage method work? Are any of these password storage methods secure? If not, how else can I automatically backup the server?
View Replies !
MySQL Administrator On A Remote Machine
On my internal network i have mysql running on a test/development webserver (windows), and im trying to use the GUI tool MySQL Administrator on another networked pc but it wont work. It keeps saying 'Error 1045 Access Denied....' I can ping it fine, and MySQL Administrator GUI works on the server itself.
View Replies !
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?
View Replies !
Backup DB From PHPMyAdmin Over To MySQL Administrator
I recently exported my database from PHPMyAdmin to a zip file to give to another person. The person is trying to import this file with MySQL Administrator 1.2 and keeps getting errors. Is there some sort of special export I should do to get this to work? I have never worked with mysql admin before.
View Replies !
FreeBSD 5.4 And Poor Performance Using MySQL Administrator
It has been over 5 years since I have messed with FreeBSD and I have never messed with MySQL until now so forgive me if my issue is trivial and I thank everyone for the help. The hospital I work for is finally getting off of Micrisift IIS to server the Hospital website. i built a FreeBSD server with Apache 2.0.54 and PHP5 as well as MySQl 5.x.x. Running queries on the server locally is fast as lighting as well as is creating db's and tables. How ever if I use MySQL query or Administrator it takes what seems like like about a minute or more to finally connect. I believe I have ruled out all network issues as this server also sits in our corporate dmz by attempting to connect directly to the server via cross over cable with a laptop.
View Replies !
MySQL Administrator Install (service Already Exists)
I've installed MySQL 4.1 on a W2k machine and would now like to install MySQL Administrator. Whenever I try to do so, however, I get an error message saying that the specified service (which service is isn't specified!) already exists and the installation fails. I get the same error trying to install the Query Browser. It was suggested elsewhere that this may be due to my version of MSI being out of date, so I've updated to V2, de-installed MySQL (including removing all traces from the registry and HD) and re-installed using the latest MSI. Same result.
View Replies !
|
TRACKER
