restore from Mysql Administrator
I have an SQL file from a Mysql Administrator backup. Database and tables are encoded in latin1, but the sql file is encoded in utf-8. Fine so far. However, some varchars have been hexdumped, and strings have been converted to utf-8 before these hexdumps. When I try to import the sql via command line, hexdumps are turned to strings again but they are not converted back to latin1, so restore process fail. 1) Why are some varchars hexdumped? 2) Why are they recoded to utf-8 before hexdump? 3) Is there a way to restore this file via command line on another server? 4) Is there any other tool to restore such file on another server? Mysql 5.0.67 Mysql Administrator 1.2.12 Thanks in advance, -Eduardo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: MySQL Administrator Job Spain
On 27/10/2011 16:54, Néstor wrote: Is 26K Euros enought money to live in Europe? On Thu, Oct 27, 2011 at 8:14 AM, Garcia, Monicawrote: They say 40k which I would assume is in Euros already. € 26k is considerably more than minimum wage. I live in Spain when not working and there are plenty of decent small flats for rent ~ €400 euro's per month (which should give you an idea of the cost of living.) € 40k would be about average for a UNIX sysadmin role in Spain. If you were based in Madrid or in Northern Europe, then I'd consider roles offering quite a bit higher. I'm not sure they're looking for anyone to relocate, and Spanish would probably be a plus (but not always necessary). Hello people, We are looking for a MySQL DBA, based in Malaga (Spain). If you have 5+ years experience administering MySQL and you are interested in join an international company, please send your CV to: monica.gar...@hays.es. Salary from 40k and different employee benefits. smime.p7s Description: S/MIME Cryptographic Signature
Re: MySQL Administrator Job Spain
Is 26K Euros enought money to live in Europe? On Thu, Oct 27, 2011 at 8:14 AM, Garcia, Monica wrote: > Hello people, > > We are looking for a MySQL DBA, based in Malaga (Spain). If you have > 5+ years experience administering MySQL and you are interested in join > an international company, please send your CV to: monica.gar...@hays.es. > Salary from 40k and different employee benefits. > > I > * > Disclaimer > This message (including any attachments) is confidential and may be legally > privileged. If you are not the intended recipient, you should not disclose, > copy or use any part of it. If you have received this email in error, please > delete the email and any attachments immediately and notify the Hays plc > group of companies (“Hays”) helpdesk at hsrsupp...@hays.com. > > Any information, statements or opinions contained in this message > (including any attachments) are given by the author. They are not given on > behalf of Hays unless subsequently confirmed by an individual other than the > author who is duly authorised to represent Hays. > > Whilst all reasonable care has been taken to avoid the transmission of > viruses, it is your responsibility as recipient to ensure that the opening > or other use of this message and any attachments will not adversely affect > your systems. Hays accepts no responsibility for damage caused by viruses > and you should, therefore, carry out such virus and other checks as you > consider appropriate. > > Hays plc is registered in England and Wales with company number 2150950. > Hays plc’s registered office is at 250 Euston Road, London NW1 2AF. > > > Opt Out (where applicable) > Should you wish to opt out of receiving further information about our > services, please email customerserv...@hays.com to unsubscribe or > alternatively write to our Customer Helpline Team at the following address: > Hays Specialist Recruitment Limited, 1st Floor Atlas House 173 Victoria > Street London SW1E 5NA. > > To update your contact details or relevant information, please contact the > sender. > * >
MySQL Administrator Job Spain
Hello people, We are looking for a MySQL DBA, based in Malaga (Spain). If you have 5+ years experience administering MySQL and you are interested in join an international company, please send your CV to: monica.gar...@hays.es. Salary from 40k and different employee benefits. I * Disclaimer This message (including any attachments) is confidential and may be legally privileged. If you are not the intended recipient, you should not disclose, copy or use any part of it. If you have received this email in error, please delete the email and any attachments immediately and notify the Hays plc group of companies (“Hays”) helpdesk at hsrsupp...@hays.com. Any information, statements or opinions contained in this message (including any attachments) are given by the author. They are not given on behalf of Hays unless subsequently confirmed by an individual other than the author who is duly authorised to represent Hays. Whilst all reasonable care has been taken to avoid the transmission of viruses, it is your responsibility as recipient to ensure that the opening or other use of this message and any attachments will not adversely affect your systems. Hays accepts no responsibility for damage caused by viruses and you should, therefore, carry out such virus and other checks as you consider appropriate. Hays plc is registered in England and Wales with company number 2150950. Hays plc’s registered office is at 250 Euston Road, London NW1 2AF. Opt Out (where applicable) Should you wish to opt out of receiving further information about our services, please email customerserv...@hays.com to unsubscribe or alternatively write to our Customer Helpline Team at the following address: Hays Specialist Recruitment Limited, 1st Floor Atlas House 173 Victoria Street London SW1E 5NA. To update your contact details or relevant information, please contact the sender. *
Re: MySQL Administrator
On Fri, Feb 4, 2011 at 8:03 AM, Angela liu wrote: > Is MySQL Administrator still available for MySQL 5.1 and 5.5? > I believe that line of applications has been superceded by the MySQL Workbench. If you must use MySQL administrator for some reason, they will undoubtedly connect to 5.1 and 5.5, but newer functionality will not be available. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel
MySQL Administrator
Hi, Anybody knows: Is MySQL Administrator still available for MySQL 5.1 and 5.5?
Re: Newbie Question - MySQL Administrator
The online help for mysql administrator is here: http://dev.mysql.com/doc/administrator/en/index.html OlinData: Professional services for MySQL Support * Consulting * Administration http://www.olindata.com On Fri, Feb 20, 2009 at 7:17 AM, Jeff Murdock wrote: > This is on a Mac OS X (v10.5.6) system in case that matters. > > > > 1. - MySQL Administrator Help button says: > > HELP > > Help isn't available for MySQL Administrator. > > > Really, no help or did I screw-up the install somehow? > > > > 2. - I tried to create my first Table in MySQL Administrator but got this > message: > > ERROR > > Error executing SQL commands to create table. > You have an error in your SQL syntax; check the manual that corresponds to > your MySQL server version for the right syntax to use near 'DEFAULT NULL, > `LastName` VARCHAR DEFAULT NULL, > `Street1` VARCHAR DEFAULT NUL' at line 3 (error 1064) > > > Trying to Execute this: > > > CREATE TABLE `test`.`AddressBook` ( > `RecNo` INT NOT NULL AUTO_INCREMENT, > `FirstName` VARCHAR DEFAULT NULL, > `LastName` VARCHAR DEFAULT NULL, > `Street1` VARCHAR DEFAULT NULL, > `Street2` VARCHAR DEFAULT NULL, > `City` VARCHAR DEFAULT NULL, > `State` VARCHAR DEFAULT NULL, > `Zip` VARCHAR DEFAULT NULL, > `HomePhone` VARCHAR DEFAULT NULL, > `CellPhone` VARCHAR DEFAULT NULL, > PRIMARY KEY (`RecNo`) > ) > CHARACTER SET utf8 > COMMENT = 'Sample'; > > > > > > > > Jeff > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Newbie Question - MySQL Administrator
Jeff, For starters, it looks like you need a value for VARCHAR. Try the same statement but with VARCHAR(255) . On Fri, Feb 20, 2009 at 1:17 AM, Jeff Murdock wrote: > This is on a Mac OS X (v10.5.6) system in case that matters. > > > > 1. - MySQL Administrator Help button says: > > HELP > > Help isn't available for MySQL Administrator. > > > Really, no help or did I screw-up the install somehow? > > > > 2. - I tried to create my first Table in MySQL Administrator but got this > message: > > ERROR > > Error executing SQL commands to create table. > You have an error in your SQL syntax; check the manual that corresponds to > your MySQL server version for the right syntax to use near 'DEFAULT NULL, > `LastName` VARCHAR DEFAULT NULL, > `Street1` VARCHAR DEFAULT NUL' at line 3 (error 1064) > > > Trying to Execute this: > > > CREATE TABLE `test`.`AddressBook` ( > `RecNo` INT NOT NULL AUTO_INCREMENT, > `FirstName` VARCHAR DEFAULT NULL, > `LastName` VARCHAR DEFAULT NULL, > `Street1` VARCHAR DEFAULT NULL, > `Street2` VARCHAR DEFAULT NULL, > `City` VARCHAR DEFAULT NULL, > `State` VARCHAR DEFAULT NULL, > `Zip` VARCHAR DEFAULT NULL, > `HomePhone` VARCHAR DEFAULT NULL, > `CellPhone` VARCHAR DEFAULT NULL, > PRIMARY KEY (`RecNo`) > ) > CHARACTER SET utf8 > COMMENT = 'Sample'; > > > > > > > > Jeff > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Newbie Question - MySQL Administrator
This is on a Mac OS X (v10.5.6) system in case that matters. 1. - MySQL Administrator Help button says: HELP Help isn’t available for MySQL Administrator. Really, no help or did I screw-up the install somehow? 2. - I tried to create my first Table in MySQL Administrator but got this message: ERROR Error executing SQL commands to create table. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT NULL, `LastName` VARCHAR DEFAULT NULL, `Street1` VARCHAR DEFAULT NUL' at line 3 (error 1064) Trying to Execute this: CREATE TABLE `test`.`AddressBook` ( `RecNo` INT NOT NULL AUTO_INCREMENT, `FirstName` VARCHAR DEFAULT NULL, `LastName` VARCHAR DEFAULT NULL, `Street1` VARCHAR DEFAULT NULL, `Street2` VARCHAR DEFAULT NULL, `City` VARCHAR DEFAULT NULL, `State` VARCHAR DEFAULT NULL, `Zip` VARCHAR DEFAULT NULL, `HomePhone` VARCHAR DEFAULT NULL, `CellPhone` VARCHAR DEFAULT NULL, PRIMARY KEY (`RecNo`) ) CHARACTER SET utf8 COMMENT = 'Sample'; Jeff
mysql administrator and different cache hit graphs
I wonder why with tre different MySQL administrator istances I have 3 different QueryCache Hitrate on the same database, in the same time :( I'm trying with: - MySQL administrator v.1.2.12 (Ubuntu 8.10): the query hitcache is always at 100% (average 100) - MySQL administrator v.1.2.5rc (Debian etc): average 86% - MySQL administrator v.1.2.12 (Max OS X 10.4.11): average 40% NB: the graph formula is always the same (the default one), then: (^[Qcache_hits]/(^[Qcache_hits]+^[QCache_inserts]+^ [Qcache_not_cached]))*100 which one is correct? and why I have so different results?! thank you in advance bye MAS! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL Administrator Login Error
On Sat, Aug 9, 2008 at 1:08 AM, AndrewMcHorney <[EMAIL PROTECTED]>wrote: > Hello > > I entered it incorrectly in my email. > > Andrew > > > At 10:34 AM 8/8/2008, David Giragosian wrote: > >> On 8/8/08, AndrewMcHorney <[EMAIL PROTECTED]> wrote: >> > >> > Hello >> > >> > I tried to login using localhost and root as user id with no password >> since >> > I temporarily did not enter one when I installed the software. I am >> getting >> > the following error message: >> > >> > MySQL Error Number 1045 >> > Access denied for user '[EMAIL PROTECTED]' (using password:NO) >> > >> > The port select is 3036. >> > >> > What does this error mean? >> > >> > Andrew >> >> >> The default MySQL port is 3306, I believe. Do you have a typo above or >> have >> you set MySQL to use a different port? >> >> David. >> >> No virus found in this incoming message. >> Checked by AVG. >> Version: 7.5.524 / Virus Database: 270.6.0/1601 - Release Date: 8/8/2008 >> 9:02 AM >> > > - It seems you are using some GUI software for mysql administration: This might be a solution for you: http://forums.mysql.com/read.php?35,9919,164372#msg-164372
Re: MySQL Administrator Login Error
Hello I entered it incorrectly in my email. Andrew At 10:34 AM 8/8/2008, David Giragosian wrote: On 8/8/08, AndrewMcHorney <[EMAIL PROTECTED]> wrote: > > Hello > > I tried to login using localhost and root as user id with no password since > I temporarily did not enter one when I installed the software. I am getting > the following error message: > > MySQL Error Number 1045 > Access denied for user '[EMAIL PROTECTED]' (using password:NO) > > The port select is 3036. > > What does this error mean? > > Andrew The default MySQL port is 3306, I believe. Do you have a typo above or have you set MySQL to use a different port? David. No virus found in this incoming message. Checked by AVG. Version: 7.5.524 / Virus Database: 270.6.0/1601 - Release Date: 8/8/2008 9:02 AM -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Administrator Login Error
On Fri, Aug 8, 2008 at 10:55 PM, AndrewMcHorney <[EMAIL PROTECTED]>wrote: > Hello > > I tried to login using localhost and root as user id with no password since > I temporarily did not enter one when I installed the software. I am getting > the following error message: > > MySQL Error Number 1045 > Access denied for user '[EMAIL PROTECTED]' (using password:NO) > > The port select is 3036. > > What does this error mean? > > Andrew > > [EMAIL PROTECTED] ~]# lsof -i :3306 COMMAND PID USER FD TYPE DEVICE SIZE NODE NAME mysqld 31792 mysql3u IPv4 434089 TCP *:mysql (LISTEN) [EMAIL PROTECTED] ~]# kill -9 31792 [EMAIL PROTECTED] ~]# /etc/init.d/mysql start Mysql Started [EMAIL PROTECTED] ~]# mysql Access denied for user 'root'@'localhost' (using password: NO) [EMAIL PROTECTED] ~]# /etc/init.d/mysql stop [EMAIL PROTECTED] ~]# mysqld_safe --skip-grant-tables & [EMAIL PROTECTED] ~]# [EMAIL PROTECTED] ~]# mysql -u root mysql> mysql> use mysql; mysql> update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root'; mysql> flush privileges; mysql> quit NEW-ROOT-PASSWORD above is whatever password you want to set. [EMAIL PROTECTED] ~]# # /etc/init.d/mysql stop [EMAIL PROTECTED] ~]# lsof -i :3306 COMMAND PID USER FD TYPE DEVICE SIZE NODE NAME mysqld 31792 mysql3u IPv4 434089 TCP *:mysql (LISTEN) [EMAIL PROTECTED] ~]# kill -9 31792 [EMAIL PROTECTED] ~]# fuser -k /usr/bin/mysqld_safe( in case you see mysql process is still running ) [EMAIL PROTECTED] ~]# vi /root/.my.cnf [EMAIL PROTECTED] ~]# cat /root/.my.cnf [client] user="root" pass="NEW-ROOT-PASSWORD" [EMAIL PROTECTED] ~]# [EMAIL PROTECTED] ~]# service mysql restart [EMAIL PROTECTED] ~]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 4.1.21-standard-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> quit Bye [EMAIL PROTECTED] ~]# Ensure that you are using the default port 3306. In case not, then try connecting in the following way , assuming port is 3036. [EMAIL PROTECTED] ~]# mysql -p 3036
Re: MySQL Administrator Login Error
On 8/8/08, AndrewMcHorney <[EMAIL PROTECTED]> wrote: > > Hello > > I tried to login using localhost and root as user id with no password since > I temporarily did not enter one when I installed the software. I am getting > the following error message: > > MySQL Error Number 1045 > Access denied for user '[EMAIL PROTECTED]' (using password:NO) > > The port select is 3036. > > What does this error mean? > > Andrew The default MySQL port is 3306, I believe. Do you have a typo above or have you set MySQL to use a different port? David.
MySQL Administrator Login Error
Hello I tried to login using localhost and root as user id with no password since I temporarily did not enter one when I installed the software. I am getting the following error message: MySQL Error Number 1045 Access denied for user '[EMAIL PROTECTED]' (using password:NO) The port select is 3036. What does this error mean? Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySql Administrator Tool Login
On 8/7/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > Hello > > I successfully installed the mysql database on my pc. I also installed the > mysql administrator tool. I am trying to login and I need some assistance. > It is asking for stored connection, server host, username and password. I am > not sure what to put in here. When I installed the database I did not give a > password to the administrator question. I do not remember the administrator > id. Would someone be so kind as to assist me with getting logged in on this > tool? > > Thanks, > Andrew > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > Maybe try username="" and password="" and host=localhost -- --David.
MySql Administrator Tool Login
Hello I successfully installed the mysql database on my pc. I also installed the mysql administrator tool. I am trying to login and I need some assistance. It is asking for stored connection, server host, username and password. I am not sure what to put in here. When I installed the database I did not give a password to the administrator question. I do not remember the administrator id. Would someone be so kind as to assist me with getting logged in on this tool? Thanks, Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: why can I not edit my database using mySQL administrator ?
Are you using MySQL Administrator for Windows ? Are you using it against MySQL running in Linux ? If so, you may prefer MySQL Administrator for Linux. Just a couple more thoughts ... - Original Message - From: "cfaust-dougot" <[EMAIL PROTECTED]> To: "Weiqi Wang" <[EMAIL PROTECTED]>, mysql@lists.mysql.com Sent: Monday, July 9, 2007 4:57:31 PM (GMT-0500) America/New_York Subject: RE: why can I not edit my database using mySQL administrator ? Are you sure the MySQL user you have defined in your GUI tool has the proper table permissions? Just a thought -Chris From: Weiqi Wang [mailto:[EMAIL PROTECTED] Sent: Mon 7/9/2007 4:46 PM To: mysql@lists.mysql.com Subject: why can I not edit my database using mySQL administrator ? Dear everyone: I'm trying to simplify the operating of mySQL by using a GUI tool, mySQL administrator. But it seems that I was only allowed to view the databases which I have made up, but not allowed to edit them. Is it because I have to buy a lisence or something which I didn't buy? Thanks for any answer! Best Regards, yours sincerely, Weiqi == Weiqi Wang Hertford College Dep. of Engineering Science Oxford -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
回复: why can I not edit my databas e using mySQL administrator ?
MySQL administrator mainly focus on MySQL server status monitor/use management/security/backup/restore etc. If you want to edite database, you should use MySQL query browser, it's included in MySQL GUI tools package. Weiqi Wang <[EMAIL PROTECTED]> 写道: Dear everyone: I'm trying to simplify the operating of mySQL by using a GUI tool, mySQL administrator. But it seems that I was only allowed to view the databases which I have made up, but not allowed to edit them. Is it because I have to buy a lisence or something which I didn't buy? Thanks for any answer! Best Regards, yours sincerely, Weiqi == Weiqi Wang Hertford College Dep. of Engineering Science Oxford @@@^_^@@@ - 抢注雅虎免费邮箱3.5G容量,20M附件!
RE: why can I not edit my database using mySQL administrator ?
Are you sure the MySQL user you have defined in your GUI tool has the proper table permissions? Just a thought -Chris From: Weiqi Wang [mailto:[EMAIL PROTECTED] Sent: Mon 7/9/2007 4:46 PM To: mysql@lists.mysql.com Subject: why can I not edit my database using mySQL administrator ? Dear everyone: I'm trying to simplify the operating of mySQL by using a GUI tool, mySQL administrator. But it seems that I was only allowed to view the databases which I have made up, but not allowed to edit them. Is it because I have to buy a lisence or something which I didn't buy? Thanks for any answer! Best Regards, yours sincerely, Weiqi == Weiqi Wang Hertford College Dep. of Engineering Science Oxford
why can I not edit my database using mySQL administrator ?
Dear everyone: I'm trying to simplify the operating of mySQL by using a GUI tool, mySQL administrator. But it seems that I was only allowed to view the databases which I have made up, but not allowed to edit them. Is it because I have to buy a lisence or something which I didn't buy? Thanks for any answer! Best Regards, yours sincerely, Weiqi == Weiqi Wang Hertford College Dep. of Engineering Science Oxford
Re: MySQL Administrator problem
Actually on my Mac; 10.4.6 ppc the MySQL Administrator will only open to a connection through localhost. The localhost connection will accept any authorised user to connect, but, MySQL Administrator will only assume the privileges of the account I am working from (I have several). It has been this way for a couple of years and through a few upgrades; it very well could be that I have something configured or installed wrong. What do you think? Daniel Culver [EMAIL PROTECTED] On Jan 20, 2007, at 7:04 PM, Kevin Spencer wrote: On 1/19/07, Daniel Culver <[EMAIL PROTECTED]> wrote: Are you working on a Mac? If so, logging in as root is not good enough. You must have set up and log into the root user account of your Mac computer or server. The OP is talking about managing MySQL accounts with MySQL Administrator. MySQL Administrator does not in any way allow you to login to a host with a shell account, root or otherwise. -- Kevin. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql? [EMAIL PROTECTED]
Re: MySQL Administrator problem
On 1/19/07, Daniel Culver <[EMAIL PROTECTED]> wrote: Are you working on a Mac? If so, logging in as root is not good enough. You must have set up and log into the root user account of your Mac computer or server. The OP is talking about managing MySQL accounts with MySQL Administrator. MySQL Administrator does not in any way allow you to login to a host with a shell account, root or otherwise. -- Kevin. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Administrator problem
Thanks for the reply Daniel, This is not on a Mac. I'm running MySQL Administrator 1.2.8 on a XP/SP2 machine and I'm connecting to a MySQL 5.1.9 server running on Netware6.5. - Still looking for help. >>> Daniel Culver <[EMAIL PROTECTED]> 1/19/07 9:52 AM >>> Are you working on a Mac? If so, logging in as root is not good enough. You must have set up and log into the root user account of your Mac computer or server. This, if anything is a Apple problem and advantage. The Administrator is opening to the account you are in, the login in window will accept any correct password combination under ShadowHash or other authorising protocol, but you will still be working in the account you are in with those privileges. HTH Daniel Culver [EMAIL PROTECTED] On Jan 17, 2007, at 4:49 PM, Ed Reed wrote: > Unable to manage user accounts through MySQL Administrator 1.2.8. > I've found that I'm not the only one with this problem but no one > seems to have an answer for it. > > The problem is that when you select a user in the user list of the > prog the user's detail don't appear on the right side so that they > can be edited. If I right click on the user in the list then the > only enabled options are Add, Refresh and Show Hosts. If I add a > user, there's nothing else I can do it. The new user shows up in > the list but I can't modify it or delete it. I'm logged in a root. > I don't know what else to do. >
Re: MySQL Administrator problem
Are you working on a Mac? If so, logging in as root is not good enough. You must have set up and log into the root user account of your Mac computer or server. This, if anything is a Apple problem and advantage. The Administrator is opening to the account you are in, the login in window will accept any correct password combination under ShadowHash or other authorising protocol, but you will still be working in the account you are in with those privileges. HTH Daniel Culver [EMAIL PROTECTED] On Jan 17, 2007, at 4:49 PM, Ed Reed wrote: Unable to manage user accounts through MySQL Administrator 1.2.8. I've found that I'm not the only one with this problem but no one seems to have an answer for it. The problem is that when you select a user in the user list of the prog the user's detail don't appear on the right side so that they can be edited. If I right click on the user in the list then the only enabled options are Add, Refresh and Show Hosts. If I add a user, there's nothing else I can do it. The new user shows up in the list but I can't modify it or delete it. I'm logged in a root. I don't know what else to do.
Re: MySQL Administrator problem
I don't have any way of selecting a host. I only have one host on my system and I don't see anything in the program that explicitly shows me where to select the host. >>> Igor Alexandrov <[EMAIL PROTECTED]> 1/17/07 9:30 PM >>> -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ed Reed wrote: > Unable to manage user accounts through MySQL Administrator 1.2.8. I've found > that I'm not the only one with this problem but no one seems to have an > answer for it. > > The problem is that when you select a user in the user list of the prog the > user's detail don't appear on the right side so that they can be edited. If I > right click on the user in the list then the only enabled options are Add, > Refresh and Show Hosts. If I add a user, there's nothing else I can do it. > The new user shows up in the list but I can't modify it or delete it. I'm > logged in a root. I don't know what else to do. > > Any thoughts? > Hello! I think, that you haven't chosen a host for user. Choose it and user options will be enabled to edit. -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.5 (GNU/Linux) Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org ( http://enigmail.mozdev.org/ ) iD8DBQFFrwYIn6e/N0YuRmcRAmJuAJ4u50WeNgr+fuTudhwXNk0mvi7VsACgpk1b sNzrOlk/rpVfD8ssw6hukUo= =Z2sQ -END PGP SIGNATURE-
Re: MySQL Administrator problem
There was already a bug report submitted. That's where I found other users that have the same problem. >>> Colin Charles <[EMAIL PROTECTED]> 1/17/07 6:05 PM >>> Ed Reed wrote: > Unable to manage user accounts through MySQL Administrator 1.2.8. I've found > that I'm not the only one with this problem but no one seems to have an > answer for it. Have you reported a bug to bugs.mysql.com ? kind regards -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Mobile: +614 12 593 292 / Skype: colincharles Web: http://www.bytebot.net/blog/ MySQL Forge: http://forge.mysql.com/
Re: MySQL Administrator problem
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ed Reed wrote: > Unable to manage user accounts through MySQL Administrator 1.2.8. I've found > that I'm not the only one with this problem but no one seems to have an > answer for it. > > The problem is that when you select a user in the user list of the prog the > user's detail don't appear on the right side so that they can be edited. If I > right click on the user in the list then the only enabled options are Add, > Refresh and Show Hosts. If I add a user, there's nothing else I can do it. > The new user shows up in the list but I can't modify it or delete it. I'm > logged in a root. I don't know what else to do. > > Any thoughts? > Hello! I think, that you haven't chosen a host for user. Choose it and user options will be enabled to edit. -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.5 (GNU/Linux) Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org iD8DBQFFrwYIn6e/N0YuRmcRAmJuAJ4u50WeNgr+fuTudhwXNk0mvi7VsACgpk1b sNzrOlk/rpVfD8ssw6hukUo= =Z2sQ -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Administrator problem
Ed Reed wrote: Unable to manage user accounts through MySQL Administrator 1.2.8. I've found that I'm not the only one with this problem but no one seems to have an answer for it. Have you reported a bug to bugs.mysql.com ? kind regards -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Mobile: +614 12 593 292 / Skype: colincharles Web: http://www.bytebot.net/blog/ MySQL Forge: http://forge.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Administrator problem
Unable to manage user accounts through MySQL Administrator 1.2.8. I've found that I'm not the only one with this problem but no one seems to have an answer for it. The problem is that when you select a user in the user list of the prog the user's detail don't appear on the right side so that they can be edited. If I right click on the user in the list then the only enabled options are Add, Refresh and Show Hosts. If I add a user, there's nothing else I can do it. The new user shows up in the list but I can't modify it or delete it. I'm logged in a root. I don't know what else to do. Any thoughts?
Re: Setting Up MySQL Administrator
David Blomstrom wrote: OK, I'm halfway there. But I don't understand what you mean by "saved settings." Is there some sort of default value I can try? Also, if I can't recover my password, is there a file I can open and retrieve it from? I tried it with localhost, Port 3306, Username: root and the password of one of my databases (but nothing under "Stored Connection") and got MySQL error #1045 - "Access denied for user 'root'@'localhost' [using password: YES] no, this is a password for the root user on your mysql server. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Setting Up MySQL Administrator
OK, I'm halfway there. But I don't understand what you mean by "saved settings." Is there some sort of default value I can try? Also, if I can't recover my password, is there a file I can open and retrieve it from? I tried it with localhost, Port 3306, Username: root and the password of one of my databases (but nothing under "Stored Connection") and got MySQL error #1045 - "Access denied for user 'root'@'localhost' [using password: YES] Thanks. - Original Message From: John Meyer <[EMAIL PROTECTED]> Assuming that you installed mysql (and keep in mind, we're talking about your MYSQL, not apache), then stored connection refers to the saved settings. "Server Host" is either the ip or the domain name of your server. If you're talking to your local MySQL server, then it's "localhost". As far as the username and password, when you installed the mysql server itself, it should have asked you to create a password for the "root" user, just type that in. Username is the username that you set up, probably root.
Re: Setting Up MySQL Administrator
David Blomstrom wrote: I just downloaded MySQL Administrator and am now trying to set it up. Can anyone tell me what "stored connection" and "Server Host" mean? I'm using Apache on Windows XP, but I'm not sure what they mean by Server Host. 3306 is listed under "Port" by default. Also, what are the default username and password for MySQL? I have a username and password for my database, but I don't recall creating them for the overall MySQL program. As I recall, "root" serves as the username or password. Thanks. Assuming that you installed mysql (and keep in mind, we're talking about your MYSQL, not apache), then stored connection refers to the saved settings. "Server Host" is either the ip or the domain name of your server. If you're talking to your local MySQL server, then it's "localhost". As far as the username and password, when you installed the mysql server itself, it should have asked you to create a password for the "root" user, just type that in. Username is the username that you set up, probably root. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Setting Up MySQL Administrator
I just downloaded MySQL Administrator and am now trying to set it up. Can anyone tell me what "stored connection" and "Server Host" mean? I'm using Apache on Windows XP, but I'm not sure what they mean by Server Host. 3306 is listed under "Port" by default. Also, what are the default username and password for MySQL? I have a username and password for my database, but I don't recall creating them for the overall MySQL program. As I recall, "root" serves as the username or password. Thanks.
RE: Looking for free MySQL Administrator
there is also a nice tool for Mac OSX called CocoaMySQL. http://cocoamysql.sourceforge.net/ George Law > -Original Message- > From: Rajesh Mehrotra [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 23, 2006 3:58 PM > To: Rithish Saralaya; mysql@lists.mysql.com > Subject: RE: Looking for free MySQL Administrator > > > Check out http://www.mysql.com/products/tools/ for some good stuff... > > Raj Mehrotra > [EMAIL PROTECTED] > > > -Original Message- > From: Rithish Saralaya [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 23, 2006 1:21 PM > To: mysql@lists.mysql.com > Subject: RE: Looking for free MySQL Administrator > > > > I'm looking for a MySQL administrator for 4.x/5.x that will allow me > > to > > > > Any suggestions? TIA > > http://www.webyog.com/ > > Regards, > Rithish. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Looking for free MySQL Administrator
Check out http://www.mysql.com/products/tools/ for some good stuff... Raj Mehrotra [EMAIL PROTECTED] -Original Message- From: Rithish Saralaya [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 23, 2006 1:21 PM To: mysql@lists.mysql.com Subject: RE: Looking for free MySQL Administrator > I'm looking for a MySQL administrator for 4.x/5.x that will allow me > to > > Any suggestions? TIA http://www.webyog.com/ Regards, Rithish. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Looking for free MySQL Administrator
> I'm looking for a MySQL administrator for 4.x/5.x that will allow me to > > Any suggestions? TIA http://www.webyog.com/ Regards, Rithish. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Looking for free MySQL Administrator
In the last episode (May 22), Phil Robbins said: > Why am I suddenly getting huge volumes of mail about SQL? What forum > is this, and how do I get out of it? This is a MySQL mailing list. To unsubscribe, click on the link at the bottom of the email right after the words "To unsubscribe:" :) -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Looking for free MySQL Administrator
Why am I suddenly getting huge volumes of mail about SQL? What forum is this, and how do I get out of it? ++ Phil Robbins Auckland New Zealand ++ _ Find the coolest online games @ http://xtramsn.co.nz/gaming -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Looking for free MySQL Administrator
At 11:57 AM 5/20/2006, John Hicks wrote: mos wrote: At 10:10 AM 5/20/2006, Keith Roberts wrote: http://www.phpmyadmin.net/home_page/index.php I think phpmyadmin will allow you to make changes to multiple columns at once. Sorry, I should have mentioned I was looking for a MySQL Administrator running on Windows. Going through PHP seems like a round about way of accessing the database since I don't have PHP running and the database is not on the web. It's running on the local machine. I suppose I could install Apache and PHP and modify the database through a browser, but it seems a bit awkard. If it's running on your own box, why not use the 'mysql' client sql-command-line utility? A single 'alter table' query can contain multiple 'change column' and 'modify column' phrases. --J Sure, I've done that in the past for smaller tables. But it is too easy to make a mistake in defining the column definition(s) and then it's another 30 minute wait for the table to become available again. Someone mentioned SqlYog and it indeed works just fine. It's free too. :) Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Looking for free MySQL Administrator
mos wrote: At 10:10 AM 5/20/2006, Keith Roberts wrote: http://www.phpmyadmin.net/home_page/index.php I think phpmyadmin will allow you to make changes to multiple columns at once. Sorry, I should have mentioned I was looking for a MySQL Administrator running on Windows. Going through PHP seems like a round about way of accessing the database since I don't have PHP running and the database is not on the web. It's running on the local machine. I suppose I could install Apache and PHP and modify the database through a browser, but it seems a bit awkard. If it's running on your own box, why not use the 'mysql' client sql-command-line utility? A single 'alter table' query can contain multiple 'change column' and 'modify column' phrases. --J -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Looking for free MySQL Administrator
mos wrote: Sorry, I should have mentioned I was looking for a MySQL Administrator running on Windows. Have you tried the MySQL Query Browser free download from mysql.com? I use it and it lets me change records and does not reload the table unless I tell it to. I'm not sure if it has any limitations on how many rows it can fetch at once. I just did a select * from my largest table, and in 100 seconds it said it returned 890,000 rows, don't know how to verify it really has that many rows displayed in the query browser, but I don't know why it wouldn't. -- Chris W KE5GIX Gift Giving Made Easy Get the gifts you want & give the gifts they want One stop wish list for any gift, from anywhere, for any occasion! http://thewishzone.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Looking for free MySQL Administrator
At 10:10 AM 5/20/2006, Keith Roberts wrote: http://www.phpmyadmin.net/home_page/index.php I think phpmyadmin will allow you to make changes to multiple columns at once. Sorry, I should have mentioned I was looking for a MySQL Administrator running on Windows. Going through PHP seems like a round about way of accessing the database since I don't have PHP running and the database is not on the web. It's running on the local machine. I suppose I could install Apache and PHP and modify the database through a browser, but it seems a bit awkard. For any major changes to a database such as you describe, if you have the disk space, I would advise copying the database and performing your changes on the copy, just in case you do make an irreversible mistake. Its not a production database and I have backups. All of the data can be regenerated if needed. At least you will still have the original tables to work with again, and not loose your database. As a matter of interest, how large is the database in MB's or GB's? Pretty small, around 44gb. I had some tables that had 100 million rows in it now its down to 34 million rows. I had tried for 500 million rows in one table but had to split it into smaller tables because the index could not be built (kept running out of memory). Mike On Sat, 20 May 2006, mos wrote: > To: mysql@lists.mysql.com > From: mos <[EMAIL PROTECTED]> > Subject: Looking for free MySQL Administrator > > I'm looking for a MySQL administrator for 4.x/5.x that will allow me to > make multiple changes to a table structure without reloading the data > after each change. The problem is I may have to change 5 columns on a 10 > million row table. As it stands now with the administrator I'm using, it > will reload the table after each change (very slow because it means 5 > reloads-1 for each column). So I need to "batch" the 5 table changes then > have it alter the table. (Of course I could use Alter Table with multiple > columns but if I make a mistake, there goes data for 10 million > rows-Ouch!) > > Any suggestions? TIA > > Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Looking for free MySQL Administrator
http://www.phpmyadmin.net/home_page/index.php I think phpmyadmin will allow you to make changes to multiple columns at once. For any major changes to a database such as you describe, if you have the disk space, I would advise copying the database and performing your changes on the copy, just in case you do make an irreversible mistake. At least you will still have the original tables to work with again, and not loose your database. As a matter of interest, how large is the database in MB's or GB's? Once you are sure you know EXACTLY what you are doing to your database, then it should be safe to work on the live database, and perform the changes to that. Just my 2c Kind Regards Keith In theory, theory and practice are the same; in practice they are not. On Sat, 20 May 2006, mos wrote: > To: mysql@lists.mysql.com > From: mos <[EMAIL PROTECTED]> > Subject: Looking for free MySQL Administrator > > I'm looking for a MySQL administrator for 4.x/5.x that will allow me to > make multiple changes to a table structure without reloading the data > after each change. The problem is I may have to change 5 columns on a 10 > million row table. As it stands now with the administrator I'm using, it > will reload the table after each change (very slow because it means 5 > reloads-1 for each column). So I need to "batch" the 5 table changes then > have it alter the table. (Of course I could use Alter Table with multiple > columns but if I make a mistake, there goes data for 10 million > rows-Ouch!) > > Any suggestions? TIA > > Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Looking for free MySQL Administrator
I'm looking for a MySQL administrator for 4.x/5.x that will allow me to make multiple changes to a table structure without reloading the data after each change. The problem is I may have to change 5 columns on a 10 million row table. As it stands now with the administrator I'm using, it will reload the table after each change (very slow because it means 5 reloads-1 for each column). So I need to "batch" the 5 table changes then have it alter the table. (Of course I could use Alter Table with multiple columns but if I make a mistake, there goes data for 10 million rows-Ouch!) Any suggestions? TIA Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: viewing data using MySQL Administrator tool
When I do this, the query browser pops up with a select * from table query which is executed on my behalf revealing my data. All I have to do is press the edit button (assuming the result set is editable, of course.) Can you be more specific about 'nothing shows up'? Tim -Original Message- From: hicham [mailto:[EMAIL PROTECTED] Sent: Thursday, May 18, 2006 6:30 AM To: mysql@lists.mysql.com Subject: viewing data using MySQL Administrator tool Hello using MySQL administrator tool, I can view databases under the catalog folder, but I can't view the data filled in the tables, when doing right click table --> Edit table Data , nothing shows up Thanks for your help hicham -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
viewing data using MySQL Administrator tool
Hello using MySQL administrator tool, I can view databases under the catalog folder, but I can't view the data filled in the tables, when doing right click table --> Edit table Data , nothing shows up Thanks for your help hicham -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Can I use mySQL Administrator on server version 3.23.58
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 ? Thanks Neil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mySQL Administrator 1.1.9 warning message
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 ? Thanks Neil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Administrator logon question
Aftab Khan wrote: I have installed mySQL with admin ID and password. However when I login using the mysql Administrator, it allows logons without a password. How do I force it to get the password and authentic rather allowing only user id? Thaks Please refer to this page: http://dev.mysql.com/doc/refman/5.0/en/default-privileges.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Administrator logon question
I have installed mySQL with admin ID and password. However when I login using the mysql Administrator, it allows logons without a password. How do I force it to get the password and authentic rather allowing only user id? Thaks
Re: Problem with mysql-administrator-1.1.5, s.o.
Hello. It doesn't run on Windows NT 4 and below. See: http://dev.mysql.com/doc/administrator/en/mysql-administrator-installation-windows.html Wolfgang Bogenrieder wrote: > Hallo, > > ich have a problem with > > mysql-administrator-1.1.5 and > mysql-query-browser-1.1.17 > > running under Windows NT Sp6. Starting the tools I get the error > message, like > > "procedure GetFileSizeEx not found in Kernel32.dll". Suppose you have to > define #ifdef NT while compiling, or similar, because procedure > GetFileSizeEx isn't present in Windows NT Sp6 installation, > > Thanks > Wolfgang Bogenrieder > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem with mysql-administrator-1.1.5, s.o.
Hallo, ich have a problem with mysql-administrator-1.1.5 and mysql-query-browser-1.1.17 running under Windows NT Sp6. Starting the tools I get the error message, like "procedure GetFileSizeEx not found in Kernel32.dll". Suppose you have to define #ifdef NT while compiling, or similar, because procedure GetFileSizeEx isn't present in Windows NT Sp6 installation, Thanks Wolfgang Bogenrieder -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Administrator crash on Mac OS X
Hello. At least there is one verified crash of MySQL Administrator on Mac OS, however, not during the connection process: http://bugs.mysql.com/bug.php?id=14269 You have a good description of your problem, and may want to report it at: http://bugs.mysql.com Yves Goergen wrote: > Hi, > I just downloaded MySQL Administrator 1.1.0 for Mac OS X. When I run it, > I can see the connection dialogue, when I click to connect, it crashes. > MySQL Query Browser, also latest version, just installed, too, works > perfectly with the same (and only) connection. Crash report from OS X is > attached. > > > > > > Date/Time: 2005-11-16 21:38:10.722 +0100 > OS Version: 10.4.3 (Build 8F46) > Report Version: 3 > > Command: MySQL Administrator > Path:/Applications/MySQL Administrator.app/Contents/MacOS/MySQL > Administrator > Parent: WindowServer [67] > > Version: ??? (1.1.0) > > PID:1028 > Thread: 0 > > Exception: EXC_BAD_ACCESS (0x0001) > Codes: KERN_PROTECTION_FAILURE (0x0002) at 0x > > Thread 0 Crashed: > 0 libSystem.B.dylib 0x90003008 strlen + 8 > 1 libSystem.B.dylib 0x9001fac0 sscanf + 88 > 2 com.mysql.MySQLToolsCommon0x100354e0 myx_get_mysql_version + 96 > 3 com.mysql.MySQLToolsCommon0x100355b4 myx_get_mysql_major_version > + 24 > 4 com.mysql.MySQLToolsCommon0x10001e50 -[MConnectionPanel(Private) > connectionFinished:] + 216 > 5 com.apple.Foundation 0x928e8f00 __NSFireMainThreadPerform + > 276 > 6 com.apple.CoreFoundation 0x9078df20 __CFRunLoopPerformPerform + > 104 > 7 com.apple.CoreFoundation 0x9075da5c __CFRunLoopDoSources0 + 384 > 8 com.apple.CoreFoundation 0x9075cf8c __CFRunLoopRun + 452 > 9 com.apple.CoreFoundation 0x9075ca0c CFRunLoopRunSpecific + 268 > 10 com.apple.HIToolbox 0x931831e0 RunCurrentEventLoopInMode + > 264 > 11 com.apple.HIToolbox 0x931827ec ReceiveNextEventCommon + 244 > 12 com.apple.HIToolbox 0x931826e0 > BlockUntilNextEventMatchingListInMode + 96 > 13 com.apple.AppKit 0x93680904 _DPSNextEvent + 384 > 14 com.apple.AppKit 0x936805c8 -[NSApplication > nextEventMatchingMask:untilDate:inMode:dequeue:] + 116 > 15 com.apple.AppKit 0x937213d8 -[NSButtonCell > performClick:] + 668 > 16 com.apple.AppKit 0x93720b38 -[NSButton > performKeyEquivalent:] + 424 > 17 com.apple.AppKit 0x9372093c -[NSView > performKeyEquivalent:] + 140 > 18 com.apple.AppKit 0x9372089c -[NSWindow > performKeyEquivalent:] + 32 > 19 com.apple.AppKit 0x9375f4b0 -[NSTextField > textDidEndEditing:] + 684 > 20 com.apple.Foundation 0x928db018 _nsnote_callback + 180 > 21 com.apple.CoreFoundation 0x907844b8 __CFXNotificationPost + 368 > 22 com.apple.CoreFoundation 0x9077c594 > _CFXNotificationPostNotification + 684 > 23 com.apple.Foundation 0x928c5420 -[NSNotificationCenter > postNotificationName:object:userInfo:] + 92 > 24 com.apple.AppKit 0x937b0cb4 -[NSTextView(NSPrivate) > _giveUpFirstResponder:] + 512 > 25 com.apple.AppKit 0x937b0aa0 > -[NSTextView(NSKeyBindingCommands) insertNewline:] + 512 > 26 com.apple.AppKit 0x937b0500 -[NSTextView > doCommandBySelector:] + 212 > 27 com.apple.AppKit 0x93763b60 > -[NSKeyBindingManager(NSKeyBindingManager_MultiClients) > interpretEventAsCommand:forClient:] + 1700 > 28 com.apple.AppKit 0x93763440 > -[NSKeyBindingManager(NSKeyBindingManager_MultiClients) > interpretKeyEvents:forClient:] + 200 > 29 com.apple.AppKit 0x9376163c -[NSView > interpretKeyEvents:] + 64 > 30 com.apple.AppKit 0x93761490 -[NSTextView keyDown:] + 756 > 31 com.apple.AppKit 0x936dcd70 -[NSWindow sendEvent:] + 6424 > 32 com.apple.AppKit 0x936856f4 -[NSApplication sendEvent:] > + 4172 > 33 com.apple.AppKit 0x9367cb30 -[NSApplication run] + 508 > 34 com.apple.AppKit 0x9376d618 NSApplicationMain + 452 > 35 com.mysql.Administrator 0x5a24 _start + 392 (crt.c:267) > 36 com.mysql.Administrator 0x5898 start + 48 > > Thread 1: > 0 libSystem.B.dylib 0x90049748 syscall_thread_switch + 8 > 1 com.apple.Foundation 0x928f3ad0 +[NSThread sleepUntilDate:]
MySQL Administrator crash on Mac OS X
Hi, I just downloaded MySQL Administrator 1.1.0 for Mac OS X. When I run it, I can see the connection dialogue, when I click to connect, it crashes. MySQL Query Browser, also latest version, just installed, too, works perfectly with the same (and only) connection. Crash report from OS X is attached. -- Yves Goergen "LonelyPixel" <[EMAIL PROTECTED]> "Does the movement of the trees make the wind blow?" http://newsboard.unclassified.de - Unclassified NewsBoard Forum Date/Time: 2005-11-16 21:38:10.722 +0100 OS Version: 10.4.3 (Build 8F46) Report Version: 3 Command: MySQL Administrator Path:/Applications/MySQL Administrator.app/Contents/MacOS/MySQL Administrator Parent: WindowServer [67] Version: ??? (1.1.0) PID:1028 Thread: 0 Exception: EXC_BAD_ACCESS (0x0001) Codes: KERN_PROTECTION_FAILURE (0x0002) at 0x Thread 0 Crashed: 0 libSystem.B.dylib 0x90003008 strlen + 8 1 libSystem.B.dylib 0x9001fac0 sscanf + 88 2 com.mysql.MySQLToolsCommon 0x100354e0 myx_get_mysql_version + 96 3 com.mysql.MySQLToolsCommon 0x100355b4 myx_get_mysql_major_version + 24 4 com.mysql.MySQLToolsCommon 0x10001e50 -[MConnectionPanel(Private) connectionFinished:] + 216 5 com.apple.Foundation0x928e8f00 __NSFireMainThreadPerform + 276 6 com.apple.CoreFoundation0x9078df20 __CFRunLoopPerformPerform + 104 7 com.apple.CoreFoundation0x9075da5c __CFRunLoopDoSources0 + 384 8 com.apple.CoreFoundation0x9075cf8c __CFRunLoopRun + 452 9 com.apple.CoreFoundation0x9075ca0c CFRunLoopRunSpecific + 268 10 com.apple.HIToolbox 0x931831e0 RunCurrentEventLoopInMode + 264 11 com.apple.HIToolbox 0x931827ec ReceiveNextEventCommon + 244 12 com.apple.HIToolbox 0x931826e0 BlockUntilNextEventMatchingListInMode + 96 13 com.apple.AppKit0x93680904 _DPSNextEvent + 384 14 com.apple.AppKit0x936805c8 -[NSApplication nextEventMatchingMask:untilDate:inMode:dequeue:] + 116 15 com.apple.AppKit0x937213d8 -[NSButtonCell performClick:] + 668 16 com.apple.AppKit0x93720b38 -[NSButton performKeyEquivalent:] + 424 17 com.apple.AppKit0x9372093c -[NSView performKeyEquivalent:] + 140 18 com.apple.AppKit0x9372089c -[NSWindow performKeyEquivalent:] + 32 19 com.apple.AppKit0x9375f4b0 -[NSTextField textDidEndEditing:] + 684 20 com.apple.Foundation0x928db018 _nsnote_callback + 180 21 com.apple.CoreFoundation0x907844b8 __CFXNotificationPost + 368 22 com.apple.CoreFoundation0x9077c594 _CFXNotificationPostNotification + 684 23 com.apple.Foundation0x928c5420 -[NSNotificationCenter postNotificationName:object:userInfo:] + 92 24 com.apple.AppKit0x937b0cb4 -[NSTextView(NSPrivate) _giveUpFirstResponder:] + 512 25 com.apple.AppKit0x937b0aa0 -[NSTextView(NSKeyBindingCommands) insertNewline:] + 512 26 com.apple.AppKit0x937b0500 -[NSTextView doCommandBySelector:] + 212 27 com.apple.AppKit0x93763b60 -[NSKeyBindingManager(NSKeyBindingManager_MultiClients) interpretEventAsCommand:forClient:] + 1700 28 com.apple.AppKit0x93763440 -[NSKeyBindingManager(NSKeyBindingManager_MultiClients) interpretKeyEvents:forClient:] + 200 29 com.apple.AppKit0x9376163c -[NSView interpretKeyEvents:] + 64 30 com.apple.AppKit0x93761490 -[NSTextView keyDown:] + 756 31 com.apple.AppKit0x936dcd70 -[NSWindow sendEvent:] + 6424 32 com.apple.AppKit0x936856f4 -[NSApplication sendEvent:] + 4172 33 com.apple.AppKit0x9367cb30 -[NSApplication run] + 508 34 com.apple.AppKit0x9376d618 NSApplicationMain + 452 35 com.mysql.Administrator 0x5a24 _start + 392 (crt.c:267) 36 com.mysql.Administrator 0x5898 start + 48 Thread 1: 0 libSystem.B.dylib 0x90049748 syscall_thread_switch + 8 1 com.apple.Foundation0x928f3ad0 +[NSThread sleepUntilDate:] + 152 2 com.apple.AppKit0x9371d7e4 -[NSUIHeartBeat _heartBeatThread:] + 1100 3 com.apple.Foundation0x928db6d4 forkThreadForFunction + 108 4 libSystem.B.dylib 0x9002b200 _pthread_body + 96 Thread 2: 0 libSystem.B.dylib 0x9002b8a8 semaphore_wait_signal_trap + 8 1 libSystem.B.dylib 0x9003001c pthread_cond_wait + 488 2 com.apple.Foundation0x928debe8 -[NSConditionLock lock] + 52 3 com.apple.Foundation0x928e8d44 -[NSObject(NSMainThreadPerformAdditions) performSelectorOnMainThread:withObject:waitUntilDone:modes:] + 716 4 com.apple.Foundation0x928e8a58 -[NSObject(NSMainThreadPerformAdditions) performSelectorOnMainThread:withObject:waitUntilDone:] + 120 5 com.mysql.MySQLToolsCommon 0x10002040 -[MConnectionPanel(Private) connectThread:] + 144 6 com.apple.Foundation0x928db6d4 forkThreadForFunction + 108 7 libSystem.B.dylib 0x9002b200 _p
Re: Terrible MySQL Administrator
Hi Scott. Thanks for the reply. Saying that I deleted the crontab was incorrect. I should have said that I deleted the line where that crontab schedule was entered. Anyway, it hasn't shown up as I did a crontab -e, which would have reloaded it, so perhaps it worked. Cheers Scott Haneda: > Just cause you deleted the crontab, does not mean it stops: > crontab -l > That lists the current cron jobs > crontab the_cron_file_name > Will reload the one you have changed. > > Of course, you could just send the alerts to nowwhere with something like > > /dev/null -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Terrible MySQL Administrator
on 10/20/05 4:01 AM, Rich at [EMAIL PROTECTED] wrote: > Hi folks. > > Since I installed MySQL Administrator on OS X and tried to put a schedule in > for a backup, the thing simply won't go away. It sends an email into my > mail app in the terminal on a daily basis and it's driving me > mad...slowly...bit by bit. > > Can someone suggest how I get rid of these emails, as the cron was deleted > weeks ago, and I took out the entry in a crontab I found, but it still > ...persists...over...and...over. > > I appreciate any advice. Just cause you deleted the crontab, does not mean it stops: crontab -l That lists the current cron jobs crontab the_cron_file_name Will reload the one you have changed. Of course, you could just send the alerts to nowwhere with something like > /dev/null -- - Scott HanedaTel: 415.898.2602 <http://www.newgeo.com> Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Terrible MySQL Administrator
On 10/20/05, Rich <[EMAIL PROTECTED]> wrote: > Hi folks. > > Since I installed MySQL Administrator on OS X and tried to put a schedule in > for a backup, the thing simply won't go away. It sends an email into my > mail app in the terminal on a daily basis and it's driving me > mad...slowly...bit by bit. > > Can someone suggest how I get rid of these emails, as the cron was deleted > weeks ago, and I took out the entry in a crontab I found, but it still > ...persists...over...and...over. have you check the crontab of every individual users? i suggest you post the email header here, so anyone can help you further. hth -- Ryan Escarez CEBB F1E4 1E39 EC48 F05D 6B72 9C11 DD88 5E39 E471 $ gpg --keyserver pgp.mit.edu --recv-keys 0x5E39E471 main(k){float i,j,r,x,y=-16;while(puts(""),y++<15) for(x=0;x++<84;putchar(" .:-;!/>)|&IH%*#"[k&15])) for(i=k=r=0;j=r*r-i*i-2+x/25,i=2*r*i+y/10,j*j+i*i<11&&k++<111;r=j);} -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Terrible MySQL Administrator
Hi folks. Since I installed MySQL Administrator on OS X and tried to put a schedule in for a backup, the thing simply won't go away. It sends an email into my mail app in the terminal on a daily basis and it's driving me mad...slowly...bit by bit. Can someone suggest how I get rid of these emails, as the cron was deleted weeks ago, and I took out the entry in a crontab I found, but it still ...persists...over...and...over. I appreciate any advice. Cheers -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Administrator Cron Errors
Hello. There are numerous bugs in MySQL Administrator (but mostly closed) where the key word is 'profile'. If necessary, you can access the source repository and build the latest available version, including the bugfix, yourself. More information about accessing the source trees is available at http://www.mysql.com/doc/en/Installing_source_tree.html Rich wrote: > Hi folks. > > Downloaded the new Admin for OS X. I set a weekly cron and for some reason, > it's emailing my terminal Mail app saying it couldn't load a profile. > > It's not the address I told it to send it to, and I don't quite get why it > can't load a profile. > > Having just tried to back up my tables twice directly from the application, > it crashed twice. > > Is this thing buggy? > > Cheers > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Administrator Cron Errors
Hi folks. Downloaded the new Admin for OS X. I set a weekly cron and for some reason, it's emailing my terminal Mail app saying it couldn't load a profile. It's not the address I told it to send it to, and I don't quite get why it can't load a profile. Having just tried to back up my tables twice directly from the application, it crashed twice. Is this thing buggy? Cheers -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Administrator on 10.3 Server -HELP
Did you drag it from a network drive, or copy in some other way? If so, that may be the problem. I haven't used the MySQL Administrator, but am pretty well versed in application troubleshooting. Send me an email privately if you need some direct help. Adam. -- Adam Randall <[EMAIL PROTECTED]> Senior Web Architect Stork Avenue, Inc. http://www.storkavenue.com/ (800) 861-5437 AIM/iChat: adamstorkave On Oct 5, 2005, at 6:04 PM, Andrew stolarz wrote: Hello List, I have installed the mysql database on the osx 10.3 server machine. along with the myodbc connector. I also installed the administrator module, by simply draging it over to the application folder like it says. When I go to launce the application, it does nothing. I tried restarting the machine, and am logging with the administrator account. Any Ideas? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Administrator on 10.3 Server -HELP
Hello List, I have installed the mysql database on the osx 10.3 server machine. along with the myodbc connector. I also installed the administrator module, by simply draging it over to the application folder like it says. When I go to launce the application, it does nothing. I tried restarting the machine, and am logging with the administrator account. Any Ideas?
Re: MySQL Administrator crashes upon launch...
Wolfram Stebel wrote: Am 30.09.2005 16:29 Uhr schrieb "Nuno Pereira" unter <[EMAIL PROTECTED]>: in Users/user/Library/Logs/CrashReporter/java.crash.log one mile of traces Regards Wolfram ** Host Name: Erde Date/Time: 2005-09-30 15:13:52.351 +0200 OS Version: 10.4.2 (Build 8C46) Report Version: 3 Command: MySQL Administrator Path:/Applications/MySQL Administrator.app/Contents/MacOS/MySQL Administrator Parent: WindowServer [70] Version: ??? (1.1.0) PID:2192 Thread: 0 Exception: EXC_BAD_ACCESS (0x0001) Codes: KERN_PROTECTION_FAILURE (0x0002) at 0x Thread 0 Crashed: 0 libSystem.B.dylib 0x900031e8 strlen + 8 1 libSystem.B.dylib 0x9001f880 sscanf + 88 2 com.mysql.MySQLToolsCommon 0x100354e0 myx_get_mysql_version + 96 3 com.mysql.MySQLToolsCommon 0x100355b4 myx_get_mysql_major_version + 24 4 com.mysql.MySQLToolsCommon 0x10001e50 -[MConnectionPanel(Private) connectionFinished:] + 216 5 com.apple.Foundation 0x92890760 __NSFireMainThreadPerform + 276 6 com.apple.CoreFoundation 0x9077c108 __CFRunLoopPerformPerform + 104 7 com.apple.CoreFoundation 0x9074bc8c __CFRunLoopDoSources0 + 384 8 com.apple.CoreFoundation 0x9074b1bc __CFRunLoopRun + 452 9 com.apple.CoreFoundation 0x9074ac3c CFRunLoopRunSpecific + 268 10 com.apple.HIToolbox0x93129ac0 RunCurrentEventLoopInMode + 264 11 com.apple.HIToolbox0x931290cc ReceiveNextEventCommon + 244 12 com.apple.HIToolbox0x93128fc0 BlockUntilNextEventMatchingListInMode + 96 13 com.apple.AppKit 0x93623e44 _DPSNextEvent + 384 14 com.apple.AppKit 0x93623b08 -[NSApplication nextEventMatchingMask:untilDate:inMode:dequeue:] + 116 15 com.apple.AppKit 0x9362006c -[NSApplication run] + 472 16 com.apple.AppKit 0x937108bc NSApplicationMain + 452 17 com.mysql.Administrator0x5a24 _start + 392 (crt.c:267) 18 com.mysql.Administrator0x5898 start + 48 Thread 1: 0 libSystem.B.dylib 0x9002ca78 semaphore_wait_signal_trap + 8 1 libSystem.B.dylib 0x9003125c pthread_cond_wait + 508 2 com.apple.Foundation 0x9288a0a0 -[NSConditionLock lockWhenCondition:] + 68 3 com.apple.AppKit 0x936c07f8 -[NSUIHeartBeat _heartBeatThread:] + 324 4 com.apple.Foundation 0x92882f34 forkThreadForFunction + 108 5 libSystem.B.dylib 0x9002c3b4 _pthread_body + 96 Thread 2: 0 libSystem.B.dylib 0x9002ca78 semaphore_wait_signal_trap + 8 1 libSystem.B.dylib 0x9003125c pthread_cond_wait + 508 2 com.apple.Foundation 0x92886448 -[NSConditionLock lock] + 52 3 com.apple.Foundation 0x928905a4 -[NSObject(NSMainThreadPerformAdditions) performSelectorOnMainThread:withObject:waitUntilDone:modes:] + 716 4 com.apple.Foundation 0x928902b8 -[NSObject(NSMainThreadPerformAdditions) performSelectorOnMainThread:withObject:waitUntilDone:] + 120 5 com.mysql.MySQLToolsCommon 0x10002040 -[MConnectionPanel(Private) connectThread:] + 144 6 com.apple.Foundation 0x92882f34 forkThreadForFunction + 108 7 libSystem.B.dylib 0x9002c3b4 _pthread_body + 96 Thread 0 crashed with PPC Thread State 64: srr0: 0x900031e8 srr1: 0x1200f030 vrsave: 0x cr: 0x82002202 xer: 0x lr: 0x9001f880 ctr: 0x900031e0 r0: 0x9001f880 r1: 0xbfffe310 r2: 0x0044 r3: 0x r4: 0x100ae024 r5: 0xbfffe4e8 r6: 0xbfffe4ec r7: 0x r8: 0x6e48476d r9: 0x r10: 0x10034a04 r11: 0xa00063fc r12: 0x900031e0 r13: 0x r14: 0x0001 r15: 0x r16: 0x0001 r17: 0xb2d0 r18: 0x r19: 0x0035ce40 r20: 0x r21: 0x r22: 0x0001 r23: 0x0030cb80 r24: 0x r25: 0x0030cb88 r26: 0x0030cc98 r27: 0x046a r28: 0xbfffe34c r29: 0x r30: 0x100ae024 r31: 0x9001f830 Binary Images Description: 0x1000 -0x54fff com.mysql.Administrator ??? (1.1.0) /Applications/MySQL Administrator.app/Contents/MacOS/MySQL Administrator 0x1000 - 0x100d6fff com.mysql.MySQLToolsCommon ??? (1.0) /Applications/MySQL Administrator.app/Contents/Frameworks/MySQLToolsCommon.framework/Versions/1. 0.0/MySQLToolsCommon 0x8fe0 - 0x8fe51fff dyld 43.1/usr/lib/dyld 0x9000 - 0x901a6fff libSystem.B.dylib /usr/lib/libSystem.B.dylib 0x901fe000 - 0x90202fff libmathCommon.A.dylib /usr/lib/system/libmathCommon.A.dylib 0x90204000 - 0x90257fff com.apple.CoreText 1.0.0 (???) /System/Library/Frameworks/ApplicationSe
Problem connecting to MySQL 4.0.23 with MySQL Administrator 1.0.21 (Mac OS X)
Dear all, I have a MySQL 4.0.23 server running on an OpenBSD machine. When I try to connect to it with MySQL Administrator 1.0.21 from my Mac OS X machine, I get this error: Connection error Could not connect to MySQL instance at . Error: unknown system variable 'sql_mode' (code 1193) I can connect with MySQL administrator 1.0.9 beta. I'm guessing the administrator 1.0.21 is explicitly asking for a 4.1 specific server variable and the 4.0 server doesn't understand it. Is there any way around this, or is there a fix planned? Thanks in advance Jan Pieter Kunst -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Administrator Broke MySQL
Hello. First read: http://dev.mysql.com/doc/mysql/en/privilege-system.html After that change the password and grants for [EMAIL PROTECTED] "Jeff Gojkovich" <[EMAIL PROTECTED]> wrote: > First I would like to start off by saying I am a complete noobie to MySQL. > I have MySQL 4.0 running on a freebsd machine. All was fine and dandy till > I tried to connect to it using the W32 MySQL Administrator tool. Now if I > try and execute a script against it I get "DBI connect failed : Access > denied for user: '[EMAIL PROTECTED]'". I can get my scripts to work if I > start > mysql with ./safe_mysqld --skip-grant-tables &. That will let the scripts > run until I try and change any users privs or passwords. I have noticed > that when I run mysql with the --skip-grant-tables flag I get all of my dbs > showing in mysqlshow, and as soon as I try and change a user it changes to > just showing just a test db when I execute mysql show. > ./mysqlshow > +---+ > | Databases | > +---+ > | bayesspam | > | bulletin | > | count | > | mysql | > | policyd | > | radius| > | test | > | users | > +---+ > ./mysqlshow > +---+ > | Databases | > +---+ > | test | > +---+ > > Please give me some pointers on where to go to fix this. I have googled and > searched the archives and I haven't come up with anything that works. > > > --Jeff > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Administrator Broke MySQL
Nevermind. I figured it out. It somehow corrupted the db table in the mysql db. I blew that away and recreated it with just root access to all of the dbs and it works now. First I would like to start off by saying I am a complete noobie to MySQL. I have MySQL 4.0 running on a freebsd machine. All was fine and dandy till I tried to connect to it using the W32 MySQL Administrator tool. Now if I try and execute a script against it I get "DBI connect failed : Access denied for user: '[EMAIL PROTECTED]'". I can get my scripts to work if I start mysql with ./safe_mysqld --skip-grant-tables &. That will let the scripts run until I try and change any users privs or passwords. I have noticed that when I run mysql with the --skip-grant-tables flag I get all of my dbs showing in mysqlshow, and as soon as I try and change a user it changes to just showing just a test db when I execute mysql show. ./mysqlshow +---+ | Databases | +---+ | bayesspam | | bulletin | | count | | mysql | | policyd | | radius| | test | | users | +---+ ./mysqlshow +---+ | Databases | +---+ | test | +---+ Please give me some pointers on where to go to fix this. I have googled and searched the archives and I haven't come up with anything that works. --Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Administrator Broke MySQL
First I would like to start off by saying I am a complete noobie to MySQL. I have MySQL 4.0 running on a freebsd machine. All was fine and dandy till I tried to connect to it using the W32 MySQL Administrator tool. Now if I try and execute a script against it I get "DBI connect failed : Access denied for user: '[EMAIL PROTECTED]'". I can get my scripts to work if I start mysql with ./safe_mysqld --skip-grant-tables &. That will let the scripts run until I try and change any users privs or passwords. I have noticed that when I run mysql with the --skip-grant-tables flag I get all of my dbs showing in mysqlshow, and as soon as I try and change a user it changes to just showing just a test db when I execute mysql show. ./mysqlshow +---+ | Databases | +---+ | bayesspam | | bulletin | | count | | mysql | | policyd | | radius| | test | | users | +---+ ./mysqlshow +---+ | Databases | +---+ | test | +---+ Please give me some pointers on where to go to fix this. I have googled and searched the archives and I haven't come up with anything that works. --Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Slightly Off Topic - MySQL Administrator
As a newbie on Linux (FC3), I have (evidently) done something stupid and lost part of the Administrator application. When first installed, it was fine. I then treid to change the path on the restore page, assuming that it was to point to where backups would be stored. Whatever was entered there (I don't honestly remember what it was) has resulted in the following: whenever the application is up and running, if I click on 'Restore' to go to that page, the whole app just disappears. I've used what I believe to be the normal method of uninstalling ('rpm -e') and the 'rpm -V' thereafter reports the pacjkage as not installed. If I then reinstall, I still get the same problem of a disappearing MySQLAdministrator when I click for Restore. Eveidently there's a config file somewhere with that (obviously incorrect) path in it, but it's not being destroyed by the 'rpm -e'. Does anyone out there happen to know what that is? I've looked at the archives for the MySQL-GUI and find no reference to this... Cheers Terry Riley -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Administrator not working correctly 2nd Request
OK I have a Fedora Core 3 Box running MySQL-server-4.1.8-0, when I try to manage the users on that box using the windows version of MySQL administrator version 1.0.19 I get errors. When I add a new user it tells me: error while storing user information If I look at the mysql log file is shows this: 050121 17:19:02 25917 Query set @new_user='bob' 25917 Query INSERT INTO mysql.user(User, Host, Password) VALUES(@new_user, '%', Password('testtest')) 25917 Query INSERT INTO mysql.user_info(User, Full_name, Description, Email, Contact_information, Icon) VALUES(@new_user, 'Bob the tester', '', '', '', '') 25917 Query DELETE FROM mysql.db WHERE [EMAIL PROTECTED] 25917 Query DELETE FROM mysql.tables_priv WHERE [EMAIL PROTECTED] I create a new schema / db called testing with NO ERRORS 050121 17:22:41 25917 Query CREATE DATABASE `testing` 25917 Query show databases 25917 Query show databases 25917 Query show databases 25917 Query show databases 25917 Query show databases Then I assign security to bob for the db testing: And I get error while storing user information Which shows this in the log: 050121 17:23:34 25917 Query set @new_user='bob' 25917 Query set @goal_user='bob' 25917 Query SELECT Full_name, Description, Email, Contact_information, Icon FROM mysql.user_info WHERE cast(cast(User AS BINARY) AS CHAR CHARACTER SET utf8)=cast(cast(@goal_user AS BINARY) AS CHAR CHARACTER SET utf8) 25917 Query select cast(cast(host AS BINARY) AS CHAR CHARACTER SET utf8) as h, cast(cast(NULL AS BINARY) AS CHAR CHARACTER SET utf8) as o, _utf8'Select_priv' as pn, cast(cast(Select_priv AS BINARY) AS CHAR CHARACTER SET utf8) as pv from mysql.user WHERE cast(cast(User AS BINARY) AS CHAR CHARACTER SET utf8)=cast(cast(@goal_user AS BINARY) AS CHAR CHARACTER SET utf8) 25917 Query select cast(cast(host AS BINARY) AS CHAR CHARACTER SET utf8) as h, cast(cast(NULL AS BINARY) AS CHAR CHARACTER SET utf8) as o, _utf8'Insert_priv' as pn, cast(cast(Insert_priv AS BINARY) AS CHAR CHARACTER SET utf8) as pv from mysql.user WHERE cast(cast(User AS BINARY) AS CHAR CHARACTER SET utf8)=cast(cast(@goal_user AS BINARY) AS CHAR CHARACTER SET utf8) 25917 Query select cast(cast(host AS BINARY) AS CHAR CHARACTER SET utf8) as h, cast(cast(NULL AS BINARY) AS CHAR CHARACTER SET utf8) as o, _utf8'Update_priv' as pn, cast(cast(Update_priv AS BINARY) AS CHAR CHARACTER SET utf8) as pv from mysql.user WHERE cast(cast(User AS BINARY) AS CHAR CHARACTER SET utf8)=cast(cast(@goal_user AS BINARY) AS CHAR CHARACTER SET utf8) 25917 Query select cast(cast(host AS BINARY) AS CHAR CHARACTER SET utf8) as h, cast(cast(NULL AS BINARY) AS CHAR CHARACTER SET utf8) as o, _utf8'Delete_priv' as pn, cast(cast(Delete_priv AS BINARY) AS CHAR CHARACTER SET utf8) as pv from mysql.user WHERE cast(cast(User AS BINARY) AS CHAR CHARACTER SET utf8)=cast(cast(@goal_user AS BINARY) AS CHAR CHARACTER SET utf8) 25917 Query select cast(cast(host AS BINARY) AS CHAR CHARACTER SET utf8) as h, cast(cast(NULL AS BINARY) AS CHAR CHARACTER SET utf8) as o, _utf8'Create_priv' as pn, cast(cast(Create_priv AS BINARY) AS CHAR CHARACTER SET utf8) as pv from mysql.user WHERE cast(cast(User AS BINARY) AS CHAR CHARACTER SET utf8)=cast(cast(@goal_user AS BINARY) AS CHAR CHARACTER SET utf8) 25917 Query select cast(cast(host AS BINARY) AS CHAR CHARACTER SET utf8) as h, cast(cast(NULL AS BINARY) AS CHAR CHARACTER SET utf8) as o, _utf8'Drop_priv' as pn, cast(cast(Drop_priv AS BINARY) AS CHAR CHARACTER SET utf8) as pv from mysql.user WHERE cast(cast(User AS BINARY) AS CHAR CHARACTER SET utf8)=cast(cast(@goal_user AS BINARY) AS CHAR CHARACTER SET utf8) 25917 Query select cast(cast(host AS BINARY) AS CHAR CHARACTER SET utf8) as h, cast(cast(NULL AS BINARY) AS CHAR CHARACTER SET utf8) as o, _utf8'Reload_priv' as pn, cast(cast(Reload_priv AS BINARY) AS CHAR CHARACTER SET utf8) as pv from mysql.user WHERE cast(cast(User AS BINARY) AS CHAR CHARACTER SET utf8)=cast(cast(@goal_user AS BINARY) AS CHAR CHARACTER SET utf8) 25917 Query select cast(cast(host AS BINARY) AS CHAR CHARACTER SET utf8) as h, cast(cast(NULL AS BINARY) AS CHAR CHARACTER SET utf8) as o, _utf8'Shutdown_priv' as pn, cast(cast(Shutdown_priv AS BINARY) AS CHAR CHARACTER SET utf8) as pv from mysql.user WHERE cast(cast(User AS BINARY) AS CHAR CHARACTER SET utf8)=cast(cast(@goal_user AS BINARY) AS CHAR C
MySQL Query Browser 1.1.2 and MySQL Administrator 1.0.15 Released
Hi, MySQL Query Browser 1.1.2 and MySQL Administrator 1.0.15 have been released. MySQL Query Browser is a GUI query shell, intended to allow execution of SQL queries from a Web browser alike easy to use interface. It has such handy features as query history and bookmarking, tabular visualization of results, side-by-side result set comparison and more. This is the first MySQL Query Browser production release. MySQL Administrator is a GUI management console for MySQL, with support for tasks such as managing users, configuring MySQL, performing backups, editing table definitions etc. You can download sources and binaries for Windows and Linux from: http://dev.mysql.com/downloads/administrator/ and http://dev.mysql.com/downloads/query-browser/ Mike -- Michael Zinner, GUI Developer MySQL AB, www.mysql.com Office: +43 676 753 26 30 Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Error 1043 Bad handshake [In MySQL Administrator]
I have just installed MySQL Administrator on FreeBSD 5.2.1. I am trying to use the "Connect to MySQL Server Instance" dialog to establish a connection to a version: 4.0.22 MySQL server. I can establish a remote connection using: mysql -h hostname -p -u username databasename However, using MySQL Administrator, I get the following error: Could not connect to host 'hostname'. MySQL Error Nr. 1043 Bad handshake I have UPDATED the database password as suggested using the OLD_PASSWORD() function. Still not able to establish a connection. Any suggestions? Thanks for your time, cb An answer to my own question. I have solved this problem which seems to be due to the way mysql 4.1.7 stores it's passwords. I used the mysql function OLD_PASSWORD to make mysql store it's passwords in the pre 4.1.x method. Basically the syntax is: mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd') WHERE Host = 'some_host' AND User = 'some_user'; mysql> FLUSH PRIVILEGES; Now I seem to be able to connect. --ja On Wed, 17 Nov 2004, Gleb Paharenko wrote: Hello. Did you use mysql client program from 4.1.7 installation? When you use it from 4.1.0 or older (on another machine) there some differences in authentication handshake. jabbott@/stripped/ wrote: > > I have done some looking in the archive for this but can't seem to find anything recent that seems to apply. > > I have a brand new install of 4.1.7 on a Redhat 9 box. I compiled it with: > CFLAGS="-O3 -mcpu=pentiumpro" CXX=gcc CXXFLAGS="-O3 -mpentiumpro -felide-constructors -fno-exceptions -fno-rtti" ./configure --prefix /usr/local/mysql --enable-assembler --with-mysqld-ldflags=-all-static --datadir /web/data > > It starts just fine. This is a new install and I haven't put any data in it so I don't think that I need to do any sort of permission fixing (Isn't that just for migrated data?) I can connect to it via local host just fine but if I try to connect from another machine running 4.1.? I get: > bash-2.05$ mysql landfill -u root -p -h 192.168.1.100 > Enter password: > ERROR 1043: Bad handshake > bash-2.05$ > > Any idea what I am doing wrong? > > --ja -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySql Administrator
I just did a clean install of Fedora Core 3 and installed mysql administrator but when I go to execute the app nothing happens. No error message etc. Is there a problem with this combination? The version of mysql admin is the latest from the website and is not the stripped down version. Thanks. Kevin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Windows 2000 and don't get connect with MySQL Administrator.
Hi. See: http://dev.mysql.com/doc/mysql/en/Problems_with_character_sets.html http://dev.mysql.com/doc/mysql/en/Cannot_initialize_character_set.html Svein Kristiansen <[EMAIL PROTECTED]> wrote: > ! use MySQL 4.1 in Windows 2000 and don't get connect with MySQL > Administrator. > > The message what get is: > Could not connect to the specified host. > MySQL Error Nr.1115 > Unknown character set: 'utf8' > > Details of the my connection: > Username: root > Password: > Hostname: localhost > Port: 3306 > > Someone can help me? > > Thanks in advance, > > > Med vennlig hilsen > Svein Kristiansen > > ErgoSolutions AS > Postboks 4364 Nydalen, 0402 Oslo > Telefon 99 24 69 75 Telefaks 23 14 50 01 > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Windows 2000 and don't get connect with MySQL Administrator.
! use MySQL 4.1 in Windows 2000 and don't get connect with MySQL Administrator. The message what get is: Could not connect to the specified host. MySQL Error Nr.1115 Unknown character set: 'utf8' Details of the my connection: Username: root Password: <not informed> Hostname: localhost Port: 3306 Someone can help me? Thanks in advance, Med vennlig hilsen Svein Kristiansen ErgoSolutions AS Postboks 4364 Nydalen, 0402 Oslo Telefon 99 24 69 75 Telefaks 23 14 50 01 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql-administrator
spiv007 <[EMAIL PROTECTED]> wrote: > Has anyone seen this before with mysql-administrator? > > /usr/local/bin/mysql-administrator: line 9: 19856 Segmentation fault > $MYPATH/mysql-administrator-bin > > I get this everytime i go to schema privileges to assian a user rights. Can you create a simple testcase for this and send it to me? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql-administrator
Has anyone seen this before with mysql-administrator? /usr/local/bin/mysql-administrator: line 9: 19856 Segmentation fault $MYPATH/mysql-administrator-bin I get this everytime i go to schema privileges to assian a user rights. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Assertion failure (MySQL Administrator)
Hopefully, this is ONLY about the administrator, not MySQL in general. Our log file (the one with all the connects and queries) has reached about 1.3Gb in size (33272 pages). Whilst trying to view the last-but-one - or indeed any except the last page of the log in Administrator - a sudden 'Assertion failure' notice appeared. Failure in ~ols\MySQL Administrator\MySQLAdministrator.exe File: .\source\myx_log_files.c Line 161 Expression: block_num !=0 This is Administrator v 1.0.8 running on WinNT, with Apache 2 and MySQL 4.1.3b-beta-nt-log. Yes, I know I should update both the Server and the Administrator, but am unable to until we have some downtime. Can I assume that, as the server is still running (apparently without problems) that the reported fault is only to do with Admin trying to read the log files, and nothing more serious? TIA Terry Riley -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Administrator 1.0.12 and MySQL Query Browser 1.0.7-beta Released
MySQL Administrator 1.0.12 and MySQL Query Browser 1.0.7-beta have been released. MySQL Administrator is a GUI management console for MySQL, with support for tasks such as managing users, configuring MySQL, performing backups, editing table definitions etc. More information at: http://www.mysql.com/products/administrator/ This release contains a few bug fixed relating to backup. MySQL Query Browser is a GUI query shell, intended to allow execution of SQL queries from a Web browser alike easy to use interface. It has such handy features as query history and bookmarking, tabular visualization of results, side-by-side resultset comparison and more. You can download sources and binaries for Windows and Linux from: http://dev.mysql.com/downloads/administrator/ and http://dev.mysql.com/downloads/query-browser/ This is the first beta release of MySQL Query Browser containing the complete functionality that will be found in the final release of the tool. This includes improved query composing, a GUI command line with multiline editing and full UTF8 support, support for loading / saving / viewing BLOB fields and many more. -- Michael Zinner, GUI Developer MySQL AB, www.mysql.com Office: +43 676 753 26 30 Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ANNC: MySQL Administrator 1.0.11
Alfredo Kengi Kojima said: > > MySQL Administrator 1.0.11 has been released. > > MySQL Administrator is a GUI management console for MySQL, with support > for tasks such as managing users, configuring MySQL, performing backups, > editing table definitions etc. > > More information at: > http://www.mysql.com/products/administrator/ > > You can download sources and binaries for Windows and Linux from: > > http://dev.mysql.com/downloads/administrator/ > > This release contains a few bug fixed relating to user administration > and the table editor. > > > -- > Alfredo Kojima, GUI Developer > MySQL AB, www.mysql.com > Buenos Aires, Argentina > You should warn people that it doen't support 3.x series I believe. Since that is all that is in the Debian std. release this is an issue. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ANNC: MySQL Administrator 1.0.11
MySQL Administrator 1.0.11 has been released. MySQL Administrator is a GUI management console for MySQL, with support for tasks such as managing users, configuring MySQL, performing backups, editing table definitions etc. More information at: http://www.mysql.com/products/administrator/ You can download sources and binaries for Windows and Linux from: http://dev.mysql.com/downloads/administrator/ This release contains a few bug fixed relating to user administration and the table editor. -- Alfredo Kojima, GUI Developer MySQL AB, www.mysql.com Buenos Aires, Argentina Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ANNC: MySQL Administrator 1.0.10 released
MySQL Administrator 1.0.10 has been released and is available for download. This is the second generally available and stable release and contains bugs fixed since the previous public release. MySQL Administrator is a GUI management console for MySQL, with support for tasks such as managing users, configuring MySQL, performing backups, editing table definitions etc. More information at: http://www.mysql.com/products/administrator/ You can download sources and binaries for Windows and Linux from: http://dev.mysql.com/downloads/administrator/ -- Alfredo Kojima, GUI Developer MySQL AB, www.mysql.com Buenos Aires, Argentina Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Administrator
I have installed MYSQL Administrator that will enables me to easily administer my MySQL environment and better visibility into how my databases is operational, but I wasn't able to find any helpful documents of how to configure this GUI interface to connect to the server. Any help? Thanks, Francois A -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Running mysql-administrator and mysqlcc graphical clients
On Tuesday 13 July 2004 08:12, A. Lanza might have typed: > Hi list, > > i've installed mysql-administrator and mysqlcc graphical clients > downloaded from mysql.com. As i read in doc from the site, i unzipped > the downloaded files in /usr/local. > > It seems to be ok, but i cannot execute the apps. > > [EMAIL PROTECTED] bin]$ ls > mysql-administrator mysql-administrator-bin > [EMAIL PROTECTED] bin]$ mysql-administrator > bash: mysql-administrator: command not found You don't have . in your path most likely. ./mysql-administrator -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Running mysql-administrator and mysqlcc graphical clients
Hi list, i've installed mysql-administrator and mysqlcc graphical clients downloaded from mysql.com. As i read in doc from the site, i unzipped the downloaded files in /usr/local. It seems to be ok, but i cannot execute the apps. [EMAIL PROTECTED] bin]$ ls mysql-administrator mysql-administrator-bin [EMAIL PROTECTED] bin]$ mysql-administrator bash: mysql-administrator: command not found [EMAIL PROTECTED] bin]$ The system shows mysql-administrator file in green and it looks like the bash shell cannot execute it. I have the same problems when trying to run mysqlcc. Any help? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Administrator question
Howdy all. If this isn't the right listserv for this question, my appologies. What I'd like to do is set up a graph under the "Health" section of the mysql administrator so that I can easliy keep tabs on the INNODB Buffer pool. The problem is that I don't know which variables to use to calculate the buffer usage or the hit rate, which would also be nice to have. The mysql site doesn't seem to have a place where the innodb status variables are explained and the administrator doesn't explain them either (most of the other variables are explained, but no the innodb ones). We're running mysql 4.0.16 and mysql administrator 1.0.5 Beta. Cheers, Tripp __ Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mysql-administrator-1.0.4 beta on SuSE 9.1, can not compile
Hello, Who can help? About 2 weeks ago I downloaded the source of mysql-administrator-1.0.4_beta and since then I am fighting with it. I can not compile it on SuSE linux 9.1 (32 bit). The reported problem from ./configure is that it can not find the package "gdk-2.0.pc". This complaint is not shown in config.log, it appeared on the console. Also the output is complaining about libxml2 being <2.6.2. This is not true, libxml2 is version 2.6.7, checked with rpm -qi libxml2. Here is config.log: === start == This file contains any messages produced by compilers while running configure, to aid debugging if configure makes a mistake. It was created by configure, which was generated by GNU Autoconf 2.59. Invocation command line was $ ./configure --enable-maintainer-mode ## - ## ## Platform. ## ## - ## hostname = lxp2 uname -m = i686 uname -r = 2.6.4-52-default uname -s = Linux uname -v = #1 Wed Apr 7 02:08:30 UTC 2004 /usr/bin/uname -p = unknown /bin/uname -X = unknown /bin/arch = i686 /usr/bin/arch -k = unknown /usr/convex/getsysinfo = unknown hostinfo = unknown /bin/machine = unknown /usr/bin/oslevel = unknown /bin/universe = unknown PATH: /home/lxuser/bin PATH: /usr/local/bin PATH: /usr/bin PATH: /usr/X11R6/bin PATH: /bin PATH: /usr/games PATH: /opt/gnome/bin PATH: /opt/kde3/bin PATH: /usr/lib/java/jre/bin ## --- ## ## Core tests. ## ## --- ## configure:1356: checking for a BSD-compatible install configure:1411: result: /usr/bin/install -c configure:1422: checking whether build environment is sane configure:1465: result: yes configure:1522: checking for gawk configure:1538: found /usr/bin/gawk configure:1548: result: gawk configure:1558: checking whether make sets $(MAKE) configure:1582: result: no configure:1749: checking build system type configure:1767: result: i686-pc-linux-gnu configure:1775: checking host system type configure:1789: result: i686-pc-linux-gnu configure:1843: checking for gcc configure:1859: found /usr/bin/gcc configure:1869: result: gcc configure:2113: checking for C compiler version configure:2116: gcc --version &5 gcc (GCC) 3.3.3 (SuSE Linux) Copyright (C) 2003 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. configure:2119: $? = 0 configure:2121: gcc -v &5 Reading specs from /usr/lib/gcc-lib/i586-suse-linux/3.3.3/specs Configured with: ../configure --enable-threads=posix --prefix=/usr --with-local-prefix=/usr/local --infodir=/usr/share/info --mandir=/usr/share/man --enable-languages=c,c++,f77,objc,java,ada --disable-checking --libdir=/usr/lib --enable-libgcj --with-gxx-include-dir=/usr/include/g++ --with-slibdir=/lib --with-system-zlib --enable-shared --enable-__cxa_atexit i586-suse-linux Thread model: posix gcc version 3.3.3 (SuSE Linux) configure:2124: $? = 0 configure:2126: gcc -V &5 gcc: `-V' option must have argument configure:2129: $? = 1 configure:2152: checking for C compiler default output file name configure:2155: gccconftest.c >&5 configure:2158: $? = 0 configure:2204: result: a.out configure:2209: checking whether the C compiler works configure:2215: ./a.out configure:2218: $? = 0 configure:2235: result: yes configure:2242: checking whether we are cross compiling configure:2244: result: no configure:2247: checking for suffix of executables configure:2249: gcc -o conftestconftest.c >&5 configure:2252: $? = 0 configure:2277: result: configure:2283: checking for suffix of object files configure:2304: gcc -c conftest.c >&5 configure:2307: $? = 0 configure:2329: result: o configure:2333: checking whether we are using the GNU C compiler configure:2357: gcc -c conftest.c >&5 configure:2363: $? = 0 configure:2367: test -z || test ! -s conftest.err configure:2370: $? = 0 configure:2373: test -s conftest.o configure:2376: $? = 0 configure:2389: result: yes configure:2395: checking whether gcc accepts -g configure:2416: gcc -c -g conftest.c >&5 configure:2422: $? = 0 configure:2426: test -z || test ! -s conftest.err configure:2429: $? = 0 configure:2432: test -s conftest.o configure:2435: $? = 0 configure:2446: result: yes configure:2463: checking for gcc option to accept ANSI C configure:2533: gcc -c -g -O2 conftest.c >&5 configure:2539: $? = 0 configure:2543: test -z || test ! -s conftest.err configure:2546: $? = 0 configure:2549: test -s conftest.o configure:2552: $? = 0 configure:2570: result: none needed configure:2588: gcc -c -g -O2 conftest.c >&5 conftest.c:2: error: parse error before "me" configure:2594: $? = 1 configure: failed program was: | #ifndef __cplusplus | choke me | #endif configure:2738: checking for style of include used by make configure:2766: r
mysql-administrator startup error
I just installed the administrator alpha binaries on my Sun Java Desktop system (SuSe 8 Linux), and I get the following error at startu: ./mysql-administrator-bin: error while loading shared libraries: libsigc-1.2.so.5: cannot open shared object file: No such file or directory I did a find from root and did not locate any file closely resembling the name 'libsigc*'. Does this mean I should download and build the source? TIA. = Thanks. Kevin -- Enjoy Life, Drink and Code Java! __ Do you Yahoo!? Win a $20,000 Career Makeover at Yahoo! HotJobs http://hotjobs.sweepstakes.yahoo.com/careermakeover -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Administrator Installation problem on Solaris
Hi, I am trying to install MySQL Administrator 1.0.2.b-alpha on Solaris 7 operating system, (since it seems I can manage almost nothing from a remote PC thru MySQL Administrator) When I try to do what suggested (linux section) in the MySQL Administrator FAQ on MySQL website that is === *Q:* How can I build MySQL Administrator myself? *A:* The following BitKeeper modules can be downloaded from http://mysql.bkbits.net/, using the BitKeeper <http://www.bitmover.com/> version management system: * mysql-gui-common * mysql-adminstrator Alternatively, download the source code package from our download page <http://www.mysql.com/downloads/administrator.html>. For each directory, execute the following commands: sh autogen.sh ./configure make make install If everything went well, you should have the |mysql-administrator| binary built and installed in |/usr/local/bin|. == When I try to issue the command: sh autogen.sh I get: --- centauri# sh autogen.sh **Warning**: I am going to run `configure' with no arguments. If you wish to pass any to it, please specify them on the `autogen.sh' command line. find: bad option -path find: path-list predicate-list Running ./configure --enable-maintainer-mode ... autogen.sh: ./configure: not found --- Whats the problem? (Solaris?) thanks in advance, Claudio Nanni -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Administrator don't connect
Hello, I use MySQL 4.1 in Windows 2000 and don't get connect with MySQL Administrator. The message what get is: Could not connect to the specified host. MySQL Error Nr.1115 Unknown character set: 'utf8' Details of the my connection: Username: root Password: Hostname: localhost Port: 3306 Someone can help me? Thanks in advance, Renato Cramer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Administrator
Hello list I have download the MySQL Administrator twice and when trying to gzip It collapse. Does anybody know how and why? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re[2]: MySQL Administrator - Startup Variables
Matt, Thomas, > Oh we are using Red Hat Enterprise Linux WS ver 3.0 Please enter a bug report at http://bugs.mysql.com. Thank you. > Thomas Taylor wrote: >> what platform are you on? >> On Feb 23, 2004, at 4:27 PM, Matt Silva wrote: >> >>> I am using the ~new~ MySQL Administrator and i'm trying to load the >>> Startup Variables and i'm receiving a "Could >>> not find my.cnf" error. my.cnf is located in the /etc directory and >>> I have temporarily relaxed the permissions to >>> 777. Is there something that i'm missing here? Or is there a bug in >>> the Administrator program? >>> >>> Thanks >>> Matt >>> >>> -- >>> Matt Silva >>> Empower Software Technologies, LLC >>> 27851 Bradley Rd. Suite 120 >>> Sun City, CA 92586 >>> >>> PH: (909) 672-6257 >>> WB: www.storagecommander.com >>> EM: [EMAIL PROTECTED] >>> >>> >>> -- >>> MySQL General Mailing List >>> For list archives: http://lists.mysql.com/mysql >>> To unsubscribe: >>> http://lists.mysql.com/[EMAIL PROTECTED] >>> >>> >> Thanks, >> Thomas Taylor >> 17106 76th Ave >> Maple Grove, MN 55311 >> [EMAIL PROTECTED] > -- > Matt Silva > Empower Software Technologies, LLC > 27851 Bradley Rd. Suite 120 > Sun City, CA 92586 > PH: (909) 672-6257 > WB: www.storagecommander.com > EM: [EMAIL PROTECTED] Regards, -- Stefan Hinz <[EMAIL PROTECTED]> iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 [filter fodder: sql, mysql, query] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Administrator - Startup Variables
Oh we are using Red Hat Enterprise Linux WS ver 3.0 Thanks Matt Thomas Taylor wrote: what platform are you on? On Feb 23, 2004, at 4:27 PM, Matt Silva wrote: I am using the ~new~ MySQL Administrator and i'm trying to load the Startup Variables and i'm receiving a "Could not find my.cnf" error. my.cnf is located in the /etc directory and I have temporarily relaxed the permissions to 777. Is there something that i'm missing here? Or is there a bug in the Administrator program? Thanks Matt -- Matt Silva Empower Software Technologies, LLC 27851 Bradley Rd. Suite 120 Sun City, CA 92586 PH: (909) 672-6257 WB: www.storagecommander.com EM: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] Thanks, Thomas Taylor 17106 76th Ave Maple Grove, MN 55311 [EMAIL PROTECTED] -- Matt Silva Empower Software Technologies, LLC 27851 Bradley Rd. Suite 120 Sun City, CA 92586 PH: (909) 672-6257 WB: www.storagecommander.com EM: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Administrator - Startup Variables
I am using the ~new~ MySQL Administrator and i'm trying to load the Startup Variables and i'm receiving a "Could not find my.cnf" error. my.cnf is located in the /etc directory and I have temporarily relaxed the permissions to 777. Is there something that i'm missing here? Or is there a bug in the Administrator program? Thanks Matt -- Matt Silva Empower Software Technologies, LLC 27851 Bradley Rd. Suite 120 Sun City, CA 92586 PH: (909) 672-6257 WB: www.storagecommander.com EM: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL Administrator certain options only valid at localhost
Hi As Greg mentioned, the options that are disabled for remote servers need access to the underlying system where the server run (file system, process control etc). There are plans for supporting those in remote servers, but that is still under development. Cheers, -- Alfredo Kojima, GUI Developer MySQL AB, www.mysql.com Buenos Aires, Argentina Want to swim with the dolphins? (April 14-16, 2004) http://www.mysql.com/uc2004/ On Fri, 13 Feb 2004 [EMAIL PROTECTED] wrote: > A probable reason is that these are in startup files and hence the interface > needs file system access. > > AFAIAA There are plans to have dynamic settings that can be changed at > runtime, but these are still plans. > > No idea on the rest of it thou. > > Neat tool, and looks great! Like the backup tools. The scheduled bit of > this is blank on mine so I assume that this is a bug as it should display > the "Local host only" message. > > Greg > > > -Original Message- > > From: Iago Sineiro [mailto:[EMAIL PROTECTED] > > Sent: 13 February 2004 12:10 > > To: MySql Mail List > > Subject: MySQL Administrator certain options only valid at localhost > > > > > > > > Hi. > > > > I've downloaded MySql Administrator 1.0.1a alpha for Windows > > and tried it. > > > > It has options only enabled if MySQL Admnistrator is > > connected to localhost. > > I'm connected as root to other host (which is Linux). For example the > > Startup Variables. Some of these options are the most > > interesting options > > and I want to use MySQL Administrator for connect to remote > > hosts. These > > remote hosts are Linux that could be in the same LAN but that > > doesn't have X > > server installed. > > > > What is the reason for this? In the future these options will > > be enabled? > > > > Iago. > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL Administrator certain options only valid at localhost
Thanks for the information. I also think it's a great tool. Iago. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Enviado el: viernes, 13 de febrero de 2004 14:30 Para: [EMAIL PROTECTED] Asunto: RE: MySQL Administrator certain options only valid at localhost A probable reason is that these are in startup files and hence the interface needs file system access. AFAIAA There are plans to have dynamic settings that can be changed at runtime, but these are still plans. No idea on the rest of it thou. Neat tool, and looks great! Like the backup tools. The scheduled bit of this is blank on mine so I assume that this is a bug as it should display the "Local host only" message. Greg > -Original Message- > From: Iago Sineiro [mailto:[EMAIL PROTECTED] > Sent: 13 February 2004 12:10 > To: MySql Mail List > Subject: MySQL Administrator certain options only valid at localhost > > > > Hi. > > I've downloaded MySql Administrator 1.0.1a alpha for Windows > and tried it. > > It has options only enabled if MySQL Admnistrator is > connected to localhost. > I'm connected as root to other host (which is Linux). For example the > Startup Variables. Some of these options are the most > interesting options > and I want to use MySQL Administrator for connect to remote > hosts. These > remote hosts are Linux that could be in the same LAN but that > doesn't have X > server installed. > > What is the reason for this? In the future these options will > be enabled? > > Iago. > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL Administrator certain options only valid at localhost
A probable reason is that these are in startup files and hence the interface needs file system access. AFAIAA There are plans to have dynamic settings that can be changed at runtime, but these are still plans. No idea on the rest of it thou. Neat tool, and looks great! Like the backup tools. The scheduled bit of this is blank on mine so I assume that this is a bug as it should display the "Local host only" message. Greg > -Original Message- > From: Iago Sineiro [mailto:[EMAIL PROTECTED] > Sent: 13 February 2004 12:10 > To: MySql Mail List > Subject: MySQL Administrator certain options only valid at localhost > > > > Hi. > > I've downloaded MySql Administrator 1.0.1a alpha for Windows > and tried it. > > It has options only enabled if MySQL Admnistrator is > connected to localhost. > I'm connected as root to other host (which is Linux). For example the > Startup Variables. Some of these options are the most > interesting options > and I want to use MySQL Administrator for connect to remote > hosts. These > remote hosts are Linux that could be in the same LAN but that > doesn't have X > server installed. > > What is the reason for this? In the future these options will > be enabled? > > Iago. > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Administrator certain options only valid at localhost
Hi. I've downloaded MySql Administrator 1.0.1a alpha for Windows and tried it. It has options only enabled if MySQL Admnistrator is connected to localhost. I'm connected as root to other host (which is Linux). For example the Startup Variables. Some of these options are the most interesting options and I want to use MySQL Administrator for connect to remote hosts. These remote hosts are Linux that could be in the same LAN but that doesn't have X server installed. What is the reason for this? In the future these options will be enabled? Iago. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Administrator
Hello guys! Just wanted to tell you, how pleased i am to see that you just released a alpha version of the mysql administrator! =) I am currently downloading the linux version! Just wanted to say thanxs, personally, for such nice products! Best Regards! -- |...| | _ _|Victor Medina M | |\ \ \| | _ \ / \ |Linux - Java - MySQL | | \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA | | / / / |___| __/ ___ \ |[EMAIL PROTECTED] | |/_/_/|_|_| /_/ \_\|ext. 325 - Tél: +58-241-8507325 | ||geek by nature - linux by choice | |...|
MySQL Administrator
Is there a rough estimate as to when it will be available? The screenshots look awesome. Thx, R