MYSQL :: User Admin In Mysql-administrator Slow On Linux

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.

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?

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:

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.

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?

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)

Create An Admin User
I need to create an admin user for my mySql database. I am using phpMyAdmin for a manager.

Starting Mysql As Root User On Linux
I have created a user called mysql to administer the mysql installation.

I can run mysqld_safe as the mysql user without any problems, however, when I try to run it as the root user with --user=mysql the process does not start and the following error message appears in the error log.

040706 17:03:06  mysqld started
Fatal error: Can't change to run as user 'mysql' ;  Please check that the user exists!
040706 17:03:06  Aborting

The user does exist, does anyone have any ideas what I am doing wrong?

Need To Create A Limited Admin User
I need to create an admin user with limited rights who can create databases and then grant full rights to these db to another user. If I give the admin user full root privileges (grant all on *.* to 'user'@'localhost' identified by 'pw' with grant option) it works, but I don't want to do this for obvious reasons. What privileges does this admin user need to do just these tasks?

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.

Remote Administrator For Root User
I have got linux server and I want to use Mysql Administrator with root user but it can't accept root user for remote connections how can I fix that or is there any way to do that?

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.

What Do You Use For Mysql Admin?
what you all use for mysql administration? i know learning for the command line is essential but sometimes that takes too long and a gui is needed. I've been using phpmyadmin forever. is there anything else out there faster better more useful?

MySQL Admin
have just installed it and am having no luck getting past the Server Instance. I put in the Server host as "localhost, the Username as"root" and the password I created at the beginning. I hitOK and I get this message...

"Administrator for MySQL Servers has encountered a problem and needs to close. We are soort for any inconvenience." I made sure that Port 3306 was available.

Best MYSQL Admin
Besides PHPMyAdim, What is the best, easy to use, administration tool to use on a windows machine. Gui type? Also free?

MySQL Admin
I am having problems with my DB, basically i am not able to load mySQL Admin script in Ensim. First where is the location of the mySQL Admin script because in the spot i expect to see it there is no folder.

MySql Admin
When I boot my computer the MySql Admin window appears on the desktop. The only way I can close it is my clicking theHide 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.

MySQL Admin
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

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

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/

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..

Transfering Another Db Into MySQL Admin
Is there anyway to upload a database into MySQL that is not a MySQL database.

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.

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

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?

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.

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?

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?

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.

MySQL Admin InnoDB Backup
I'm having trouble backing up my InnoDB tables. The structure is backed up but the data isn't. I've tried every option that MySQL Admin offers. Does someone know of a solid way to backup InnoDB tables whithout bringing the database offline?

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.

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.

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.

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?

Mysql-administrator
Having just upgraded to from Suse 10.0 to 10.1 mysql-administrator will
not work. When I try to acccess it I get the following message.

linux:/home/grabro # mysql-administrator
/usr/bin/mysql-administrator-bin: Symbol `_ZTIN4Glib9InterfaceE' has
different size in shared object, consider re-linking
/usr/bin/mysql-administrator-bin: Symbol `_ZTIN4Glib10ObjectBaseE' has
different size in shared object, consider re-linking
/usr/bin/mysql-administrator-bin: Symbol `_ZTIN3Gtk9ListStoreE' has
different size in shared object, consider re-linking
/usr/bin/mysql-administrator-bin: Symbol `_ZTIN3Gtk5EntryE' has different
size in shared object, consider re-linking
/usr/bin/mysql-administrator-bin: Symbol `_ZTIN4Glib6ObjectE' has different
size in shared object, consider re-linking
/usr/bin/mysql-administrator-bin: Symbol `_ZTIN3Gtk6WidgetE' has different
size in shared object, consider re-linking
*** glibc detected *** /usr/bin/mysql-administrator-bin: free(): invalid
pointer: 0x083ca0e0 ***
======= Backtrace: =========
/lib/libc.so.6[0xb716d911]
/lib/libc.so.6(__libc_free+0x84)[0xb716ef84]
/usr/lib/libstdc++.so.6(_ZdlPv+0x21)[0xb72e6e51]
/usr/lib/libstdc++.so.6(_ZNSs4_Rep10_M_destroyERKSaIcE+0x1d )[0xb72c2fed]
/usr/lib/libstdc++.so.6....................................

MySQL Administrator 1.1.9
I am running mySQL database version 3.23.58, but I'm using mySQL Administrator 1.1.9 for scheduled backups. When connecting to the database I get a message saying that this version of database is not supported and I might get unexpected behaviour.

Am I OK to use this version of mySQL Administrator to backup my database and what unexpected behaviour can I expect ?

MySQL 5.0 Administrator
I have installed a new MySQL 5.0 administrator and since I am so used to deleting a database directly through data folder in my old mysql 3.23 that I do it now also in MySQL 5.0 rather than deleting it through administrator .

Now the problem , if the db is deleted not through administrator , it somehow creates a same name cache of the database and it creates a problem if I try to run a sql script because it gives a error of duplicate name.

My question is , Is there a way to delete old cache names of the db's so that new db's can be created or a script can run the db which has been created and deleted before .

MySQL Administrator
I am using the MySQL Administrator version 1.1.3. Why is the "Edit Table Data" grayed out when i right click on a table? Is there a way to ungrayed this?
Or is this not part of version 1.1.3 anymore?.

Mysql Administrator 1.0.19
when i click catalogs -> my schemata ; right-click on any InnoDB table i am not able to "edit table data" it is grayed out.

What do I have to do to be able to edit table data with mysql admin.

MySQL Administrator
My mysql server's version is 4.1.11_win32 and my MySQL Administrator's version is 1.0.19. When I use MySQL Administrator to modify the user administration, it always shows me "Error while storing the user information!".

MySQL Administrator
I want to view the config file in MySQL Administrator but it says I must be connected to localhost to see it.
Can I grant myself permissions to be localhost as well?

MySQL Administrator
I am trying to make one of my fields UNIQUE, however the MySQL table editor has the 'index settings' greyed out so I can not select "UNIQUE".
How do I make field unique

MySQL Administrator
I have setup MySQL Admin to run scheduled backups on my databases... do I have to keep the program open in order to run them?

MySQL Administrator 1.0.13
I've just downloaded MySQL Administrator 1.0.13 and wish to connect to a mySQL server v3. When connecting I get a message saying that this server version is not support, which I can ignore.
Can someone please advise what problems i might encounter if connecting to an unsupported server version ?
My main requirement for the mySQL Administrator program is scheduled backups of the data and table structures.

MySQL Administrator
I have a site hosted with a company. I created a testing sub-domain called testlab.swattle.com In this sub I have created a database called swattle_test and I also added a user called swattle_testuser
Now when I go into the MySQL Administrator program on my local machine and try to logon to the server I keep getting an error 1045 I put up the screen shots of at http://testlab.swattle.com I also fired off an email to my hosting company

Mysql Administrator
i installed it for windows i can't seem to get it to connect to the database though, the mysql server is on the same machine as this one. for the hostname i typed in localhost port:3308 (is that the right port?) and my root username and password

it gave me an error that it couldnt ping to "localhost" i dont get it

Mysql Administrator
How do I edit table data using Mysql administrator.
If I click on edit table data the table opens, but then there is no way to edit the table.
At the bottom there is a button to apply changes but this is grayed out.

MySql Administrator
I'm using Innodb on windows server 2003.I noticed today that some of my tables are reported by MySql Administrator to have a far greater number of rows than what is return in a query for all rows.
For example, one table shows 51,600 rows in Administrator but when I do a SELECT * on the same table from Query Browser I get a mere 5,293 (this is the correct or "real" number of rows)
So, what's up? Why is administrator showing so many more rows?
I've also noticed that each time I press the refresh button in Administrator the number of rows changes. one time it might be 50k+ then 30k then 43k, etc, etc.
being a newb I'm a bit freaked out by all of this. I've heard that innodb can do some funny things, but this seems REALLY strange. I'm sure it's nothing, I just need to hear it from an experienced user

MySQL 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)