User Admin In Mysql-administrator Slow On Linux
We have a MySQL 5.0.16 server installed on a RedHat 8.0 machine.
mysql-administrator v1.0.22 is installed on RH Linux FC3 from the
mysql-administrator-1.0.22a-1.rh9.i386.rpm.
Everything seems to run fine except User Administration is *extremely*
slow. If I click on "User Administration" in the sidebar, it takes
about 2 minutes (seems like forever) before the window comes back with
the infomation. All the other functions seem to function fine.
Is it because I'm using mysql-administrator on a remote host? Do I need
to move and rebuild the server to a newer Linux version? mysqlcc
doesn't have this problem at all. (It's using the libraries from MySQL
4.1 that the databases were migrated to.)
View Complete Forum Thread with Replies
Related Forum Messages:
How Do You Install MySQL 5.0 Server And Administrator On Red Hat Enterprise Linux 3 WS
Could someone point me to instructions for installing MySQL 5.0 server and administrator on a Red Hat Enterprise Linux 3 WS system? I just freshly installed the system and deliberately did not select MySQL serveras part of the installation I downloaded the 5.0 rpm Community Server edition, and that installed fine. My problems came while trying to build the administrator. Basically, I got caught up in a loop of incompatable modules: # rpm -i mysql-3.23.58-16.RHEL3.1.i386.rpm warning: mysql-3.23.58-16.RHEL3.1.i386.rpm: V3 DSA signature: NOKEY, key ID 025e513b error: Failed dependencies: perl-DBD-MySQL is needed by mysql-3.23.58-16.RHEL3.1 MySQL conflicts with mysql-3.23.58-16.RHEL3.1 Suggested resolutions: /var/spool/up2date/perl-DBD-MySQL-2.1021-3.i386.rpm If up2date the suggested resolution, it says I need a library from mysql-3.23.58-16.RHEL3.1.i386.rpm. I will gladly read the "manual" or docs, and would love a pointer to them.
View Replies !
Admin User In MySQL 5.0
I've just installed MySQL 5.0 on my sun box (runing Solaris 10, install from blastwave). This is my first time with MySQL so I don't have any exp with it. I have some troubles as: - I set password for root account via this command: # mysql -h atlantis -u root mysql mysql> update user set password=PASSWORD('123456') where user = 'root'; mysql> exit However, I can login again with root account without pass check ???? - Next, I create new user name admin # mysql -h atlantis -u root mysql> create user admin identified by 'admin' ; mysql> create database newdb ; mysql> GRAND ALL ON newdb.* TO 'admin' IDENTIFIED BY 'admin' ; Once again, i can't use admin account to login to newdb database?
View Replies !
MySQL Admin :: Default User Name?
I created an instance using "MySql Server Instance Config Wizard" then opened MySql Administrator, where I was asked to supply a user name and password for the connection. I did not supply a user name creating the Instance. Is there a default user name? How do I login? Windows XP OS
View Replies !
Mysql Running Slow On Mandrake Linux 10.0 For AMD 64
I'm having a problem with a new machine running Mysql version 4.0.18 on the AMD64 version of Mandrake 10.0. The new machine has got 64bit AMD processor and 2GB of RAM. Nearly all queries(updates are especially slow) are running 20/30 or more times slower than on an inferior(32 bit processor, 1.5GB RAM) machine runnning Mysql 3.23.56 on mandrake 9.0. As far as I can tell mysql is configured correctly for the power of the machine. The my.cnf file looks like this: Code:
View Replies !
Slow Connect Linux To Windows MySql
I have a Linux box with the latest MySql and another box (Windows 2003 Server) with the latest Mysql. From the unix prompt I do this: mysql -uroot -pmypass -h windowsserver mydbname this take about 4 seconds to connect I do the exact same thing on a windows workstation and its connected instantly.
View Replies !
New User [MySQL Administrator]
I'm getting an error when adding a new user: After I've entered MySQL User: XXX-WEB, Password and Confirm Password, I click Apply Changes a message box shows MySQL Administrator Exception: Error while storing the user informaiton. The user might have been deleted. Please refresh the user. I've refreshed, sooo many times... I think I may have messed up the MySQL schema and may have damaged some locks.
View Replies !
Error In MySQL Administrator When I Try To Change The User Information
I recently install the MySQL 4.1.8-nt-max, and the MySQL Administrator, but when i try to change the information (name, description, email, etc.) in the Administrator I get the following error: " Invalid UTF-8 Error executing query (illegal mix of collations (latin1_swedish_ci,implicit) and (utf8_general_ci,coercible) for operation '=' " Before it happens the Administrator crash down ... Im from Mexico, so my Windows XP regional configurations are spanish / latinamerican. Any ideas about it?
View Replies !
User Mysql On Linux
I´m using Red hat Enterprice WS 3, when I install mysql (version 4.1.7) on linux, everything ok, but when I type # mysql error ocur: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
View Replies !
First Time Install On Windows - Admin User&password Problem
I have a problem with logging in to MySQL. Access denied. I think the issue is with the host, user and password settings. I assumed you had to add this information to the my.ini before you started the service for the first time. Is this only for WinMySQLAdmin? Is there a default? I have tried all the solutions I could find but they seem to all require user privileges in the first place. I simply need to have one main admin user and password and to refresh their values to be certain of the new settings in case there was one before.
View Replies !
User Privileges In Version 4.1.7(linux)
sql: GRANT USAGE ON *.* TO 'shinestb'@'localhost' IDENTIFIED BY 'shinestb'; FLUSH PRIVIELGES; an error return at login time: ./mysql -ushinestb -p ERROR 1045 (28000): Access denied for user 'shinestb'@'localhost' (using password: NO why? version < 4.1 is ok.
View Replies !
Dont Start If The User Dont Have Administrator Privileges On The PC
I instaled MySQL in a computer (with widows XP) that not always is loged with a user withthe computer administrator privileges. when a person whitout administrator privileges is the first person that logs, the DataBase dont startup until an administrator logs on. What can i do to allways startup the DB without care the computer's administrator privileges?
View Replies !
Best MYSQL Admin
Besides PHPMyAdim, What is the best, easy to use, administration tool to use on a windows machine. Gui type? Also free?
View Replies !
Trick MySQL Admin
There are a few features in mysql administrator that are only available if you are connected to a localhost...this is useless if you are using a remote web server, linux based and need to monitor some of this information. Anyone have any idea if there is a way to allow the following functions to work without local host? Service Control: Start/Stop Service, Configure service Startup Variables Server Logs: Error Log, Slow Query Log, General Query Log
View Replies !
How To Set Up An Admin Password On OS X For MySQL?
I use to use Complete MySQL, I decided to use MySQL from here, just do to the fact of the major bug that C.MySQL contains now... But the problem I am finding with the documentation is that it doesn't explain in OS X, how to create the admin account, and how to give it a password as well..
View Replies !
Special MySQL Admin
I’m looking for a solution to create a limited numbers of MySQL-Databases. In other words a front-end for users. The software AutoControPro (www.directphp.com) has this feature, but is very expensive to buy the soft only for the My-SQL feature. I should have the possibility to limit the Databases for every user and the user should have the possibility to create the appropriate numbers of Databases. Example: User1 can create 3 MySQL-Database User2 can create 5 MySQL-Database If the User installs phpMyadmin he should get only the assigned Databases.
View Replies !
Admin Tools For MySQL
What admin tools do you recommend for managing my MySQL databases. In the past, I have used DB Tools, but now its not free, http://www.dbtools.com.br/EN/dbmanagerpro/
View Replies !
MySQL 4.0.xx Admin And Usage
I've recently taken over my non-profit's Web site design, administration and maintenance with relatively little MySQL experience (although I have learned a great deal very quickly). My question is, does anyone know where I can get a manual or something like the current manual "Building your Own Website Using PHP and MySQL .."(ordered from sitepoint.com site). This manual is basing the MySQL on the most current version of 5. I'm looking for something similar that addresses the 4.0.xx(27 specifically) of MySQL
View Replies !
Error 1064 In MYSQL ADMIN
I am trying to run an SQL script using File -> Open Script. Everything is working fine until one of the INSERT commands has a backsalash insert into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('9', 'Switch To Default Language Currency', 'USE_DEFAULT_LANGUAGE_CURRENCY', 'false', 'Automatically switch to the language's currency when it is changed', '1', '10', NULL, '2004-11-03 12:36:43', NULL, 'tep_cfg_select_option(array('true', 'false'),'); In the code above the word "language's" seems to be creating an error. How do get round this problem?
View Replies !
MySQL Admin Scheduled Backups
Two problems: 1.-- MySQL Administrator will do backups manually and for sometime it did scheduled backups, as well. Now a scheduled job will fail and generate an event id 1000 error: Faulting application MySQLAdministrator.exe, version 1.2.3.0, faulting module MySQLAdministrator.exe, version 1.2.3.0, fault address 0x001e5342. 2.-- The SQL error logs have disappeared since starting the use of Administrator for backups. Is there a way to get them back or at least start the recording again? The only thing that ever showed up in the logs was the shut down and start up of the MySQL service at the beginning and end of a flat file backup of the entire database. Still... it would nice to have the logs back.
View Replies !
MySql Admin Schedule Backup
Mysql Admin 1.1.9 (server2k3) I would like to schedule a backup of my db with MySql Admin. The concept is fairly easy but I probably miss something since the schedule backup is not running... I've created a new backup project - named the project - Selected the db I've selected InnoDb Online Backup left everything default Last I've set a scedule backup every day at 23:00 with a target folder and file name Do I need to do something more ? The scedule task is not running at all, the only way I can backup my db is by running it manually.
View Replies !
Restore From Backup With MySQL Admin
I am trying to restore a mysqldump txt file to another cpu using MySQL Admin. I receive an error: The selected file was generated by mysqldump and cannot be restored by this application. I understand there are other ways of transfering a database to MySQL on a different cpu. ie. mysql -u Username -p DBname < Filename.sql When I try this it doesn't work I'm doing something wrong. Does the "filename" need to be an exact path to the file or just the file name ie. C:folderfolderdatabase.sql Also does it matter if the file is .txt or .sql? Does it matter where I have the database.sql file on my computer? Do I need to have a new empty database created?
View Replies !
MySQL Admin Backups Won't Work
I’m using MySQL Administrator and MySQL Query Browser and want to make a backup of a database. First you click on the “New Project” button and name the project. Next the documentation for MySQL Administrator says… “To choose the databases and tables that will be backed up, select the database from the schemata list and click the > button. Once the database is in the Backup Content list, you can un-check specific tables that you do not wish to back up. “ That sounds straight forward enough – it works like every other gui out there. The problem is you click on the database you want to backup and it doesn’t become highlighted and when you click on the”>” button, nothing happens. Why?
View Replies !
MySql Admin :: Window Always Appear On The Desktop
When I boot my computer the MySql Admin window appears on the desktop. The only way I can close it is my clicking the Hide Me button. I get fed up of this routine everytime I boot the computer. Does anyone know there is a way of keeping this window hidden so that when the computer is booted up it doesn't appear.I don't use MySql admin anyway as I connect through PHPMyAdmin.
View Replies !
MySQL Admin Program/Script
I'm looking for an application, or php script that makes entering and retrieving information out of a database automated. The process would like so: I enter in the mysql un/pass etc. and create tables and rows. Also defining what type of input each row should have. Whether it be a checkbox, a dropdown menu, plain text input. Also defining what options for things like the checkboxes and dropdowns. After that, you would be able to go to a simple front end that had the inputs you defined. You could create your entries and retrive them. Sorting them how you see fit. Given the obvious use for such a thing, there must be plenty. I must not be wording my searches correctly though. I would prefer something free/open source.
View Replies !
Backup Options Non Functional - MySQL Admin
I have inherited a small MySQL database, version 5.x. I have installed MySQL Administrator. I would like to try the backup utilities offered in this application, but they are all greyed-out and non-functional. It doesn't matter whether the application is run on the local host or on a client workstation -- the backup features are non-functional.
View Replies !
MySQL Admin - Lost Thread On Specific Like Query?
mySQL win32 (4.0.22) I am using mySQL Control Admin and seeing a lockup on a thread specific to a like query. select * from table1 where field1 like 'http://h%' limit 100 This request will sit (thread) forever and never return any records. (status : sending...) However : select * from table1 where field1 like 'http://h%' limit 100 returns records immediately, no problems... I have already run : /mysql/bin/myisamchk --sort-recover dbtable1, no errors, no problems... How can I tell what this thread is really doing or if any additional problems exist with this table using myisamchk?
View Replies !
MySQL GUI Tools Query Browser/Admin Login
I've just installed the GUI tools so I can get a little help with queries and table design, and I am not able to log into the administrator or the query browser. The login screens show up, I enter all the correct data, then the form grays out except for the cancel button and does nothing. Doesn't even eat up any system resources, so it doesn't even look like its trying. I've turned off all firewall settings in case that might have cause the issue and it still doesn't work.
View Replies !
Mysql-administrator
Having just upgraded to from Suse 10.0 to 10.1 mysql-administrator will not work. When I try to acccess it I get the following message. linux:/home/grabro # mysql-administrator /usr/bin/mysql-administrator-bin: Symbol `_ZTIN4Glib9InterfaceE' has different size in shared object, consider re-linking /usr/bin/mysql-administrator-bin: Symbol `_ZTIN4Glib10ObjectBaseE' has different size in shared object, consider re-linking /usr/bin/mysql-administrator-bin: Symbol `_ZTIN3Gtk9ListStoreE' has different size in shared object, consider re-linking /usr/bin/mysql-administrator-bin: Symbol `_ZTIN3Gtk5EntryE' has different size in shared object, consider re-linking /usr/bin/mysql-administrator-bin: Symbol `_ZTIN4Glib6ObjectE' has different size in shared object, consider re-linking /usr/bin/mysql-administrator-bin: Symbol `_ZTIN3Gtk6WidgetE' has different size in shared object, consider re-linking *** glibc detected *** /usr/bin/mysql-administrator-bin: free(): invalid pointer: 0x083ca0e0 *** ======= Backtrace: ========= /lib/libc.so.6[0xb716d911] /lib/libc.so.6(__libc_free+0x84)[0xb716ef84] /usr/lib/libstdc++.so.6(_ZdlPv+0x21)[0xb72e6e51] /usr/lib/libstdc++.so.6(_ZNSs4_Rep10_M_destroyERKSaIcE+0x1d )[0xb72c2fed] /usr/lib/libstdc++.so.6....................................
View Replies !
MySQL 5.0 Administrator
I have installed a new MySQL 5.0 administrator and since I am so used to deleting a database directly through data folder in my old mysql 3.23 that I do it now also in MySQL 5.0 rather than deleting it through administrator . Now the problem , if the db is deleted not through administrator , it somehow creates a same name cache of the database and it creates a problem if I try to run a sql script because it gives a error of duplicate name. My question is , Is there a way to delete old cache names of the db's so that new db's can be created or a script can run the db which has been created and deleted before .
View Replies !
Mysql Administrator 1.0.19
when i click catalogs -> my schemata ; right-click on any InnoDB table i am not able to "edit table data" it is grayed out. What do I have to do to be able to edit table data with mysql admin.
View Replies !
MySQL Administrator 1.0.13
I've just downloaded MySQL Administrator 1.0.13 and wish to connect to a mySQL server v3. When connecting I get a message saying that this server version is not support, which I can ignore. Can someone please advise what problems i might encounter if connecting to an unsupported server version ? My main requirement for the mySQL Administrator program is scheduled backups of the data and table structures.
View Replies !
MySQL Administrator 1.1.9
I am running mySQL database version 3.23.58, but I'm using mySQL Administrator 1.1.9 for scheduled backups. When connecting to the database I get a message saying that this version of database is not supported and I might get unexpected behaviour. Am I OK to use this version of mySQL Administrator to backup my database and what unexpected behaviour can I expect ?
View Replies !
MySQL Administrator Logs
I have been using mysql database on two servers for about three years now. I recently downloaded the new MySQL Administrator and I love it. My only problem is I cannot see logs. I am connected on the local machine and cannot find the option to turn on the logs or anything. I have looked through my.ini and everywhere.
View Replies !
Setting Up MySQL Administrator
I just downloaded MySQL Administrator and am trying to install it. I'm trying "localhost" and "root" for Server Host and Username, along with the default setting for Port, 3306. However, I don't have a clue what a "Stored Connection" is. What am I supposed to enter there?
View Replies !
Installing Mysql-administrator
(This is also posted in the install forum) For some reason I can't get the rpm to install so I tried using the tarball and when I do this, the /opt/mysql-administrator-1.0.19/bin directory does not get created. Command I used to install mysql-administrator: shell> tar --directory=/opt -xzvf mysql-administrator-1.0.19.tar.gz Does anyone have any suggestions or another way to install this application on Linux? ...or am I missing a step? The rpm is preferred, but anything that works would be great.
View Replies !
Starting With MySQL Administrator
I have just installed XAMPP on Ubuntu, and then i have installed MySQL Admin. After open MySQL Admin, i can see a window with "Server hostname", "Username" and "Password". I have written this: Server hostname: localhost Username: (blank) Password: (blank) I don't write any Username or Password because i can enter to MySQL server just with "mysql".
View Replies !
MySQL Administrator Disabled
I've just installed MySQL 4.1.5 gamma following the instructions in the documention, and MySQL Administrator 1.0.13 on my home machine. I'm the only user :( ! MySQL seems to be working OK but when I use the Administrator program, which appears to connect to the MySQL service OK, all of the Startup Variable options are disabled on all the panels. I thought I'd be able to tweak these options from here.
View Replies !
MySQL Administrator & QueryBuilder
I have installed MySQL 4.0, MySQL Administrator and Querybuilder. In general all functions well. But two things do not function, which I would like to, because I need them: (1) In the menu of Querybuilder --> Tools the link to Administrator is greyed out. How can I make it function? (Administrator to querybuilder is ok) (2) More Important: in Administrator, loggedin as root with all grants, the (context-)menue eintry "edit tables values" is greyed out on any table. - How to make it function? How to edit values in the tables then? (System: WXP-SP2, logged in with admin-rights)
View Replies !
MySQL Administrator Password
I have just installed mySQL 5 Community Edition and also all its tools viz. Administrator, Migration etc.. Presently I have installed it on a machines with no other machines connected to it. I also selected "Developer Machine" option while installing it. When I open mySQL Administrator, it asks for Username and Password. I remember the password, but what is the default Username and Schema Name. If I am running on a standalone machine, what to type in "Server Host" in the administrator window.
View Replies !
|
TRACKER
