Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MYSQL


SuperbHosting.net have generously sponsored dedicated servers to ensure a reliable and scalable dedicated hosting solution for BigResource.com.





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 Complete Forum Thread with Replies

Related Forum Messages:
Starting MYSQL...
--=_5D034890.F392DE43
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

This may be a very simple question and possibly could have a very simple
solution to it. Since I have been using mysql for less than 2 months, I
still consider myself a newbie.... I still cannot execute certain
commands from my dos prompt, but I can run queries easily using
phpmyadmin. I have purchased MYSQL Second Edition (Paul Dubois) so I
hope to put it to good use soon....

The question that is of concern to me this morning is the prefered way
to start mysql. I seem to think that I always have a problem because
when I start my PC, mysql is already running as a service. But I am
thinking that because I login to my PC as any user other than the dbase
username, I have a problem afterwards.

Must I always log on to my PC (Win2K) as the same user as the created
user in my DBase in order for mysql to run properly?

View Replies !
Mysql Not Starting
I had to reload mysql 4.0.17 on to a Fedora Core machine that was previously
working in the same configuration. Now though I can't get the server to run
with the either of the following commands:

../mysql.server start - the command line reappears with no error but no
running process in the system monitor
/usr/local/mysql/bin/mysqld_safe -user=mysql - this command does not return
to the command prompt so when I hit the enter key I get "Starting mysqld
daemon with databases from /var/lib/mysql 0404124 00:13:21 mysqld ended.

It looks to me as if it attempts to start but fails with no error. What am I
missing on the reinstall?

View Replies !
Starting MYSQL On A Mac
I feel quite stupid I cannot seem to get MYSQL to even run on my Mac (OS X 10.4)

I have installed MYSQL and then went to terminal and entered

cd /usr/local/mysql

then

sudo ./bin/mysqld_safe

then my password as prompted

which is followed by

Starting mysqld daemon with databases from /usr/local/mysql/data

- at this point as it just seems to stop

What next? I have tried entering mysql -u grifkerry -p but nothing happens! I have left it for a while but still nothing.

View Replies !
Starting Mysql 5.0.18
I type in the password and mysql closes. When I reinstall it as an anonymous user mysql asks me to type in my password. I've reinstalled the program a few times. I tried to reset the root password. None of these things work. I also saw that I have a file called prod.err. I open up the file and I see a bunch of stuff that I don't understand. I greatly appreciate anyone who could help me solve this problem. I've run out of ideas.

prod6.err:
InnoDB: The first specified data file .ibdata1 did not exist:
InnoDB: a new database to be created!
060215 16:31:56 InnoDB: Setting file .ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
060215 16:31:56 InnoDB: Log file .ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .ib_logfile0 size to 10 MB
InnoDB: Database physically writes the file full: wait...
060215 16:31:57 InnoDB: Log file .ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .ib_logfile1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
060215 16:31:57 InnoDB: Started; log sequence number 0 0
060215 16:31:58 [Note] C:Program FilesMySQLMySQL Server 5.0inmysqld-nt: ready for connections.
Version: '5.0.18-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
060215 16:52:38 [Note] C:Program FilesMySQLMySQL Server 5.0inmysqld-nt: Normal shutdown

060215 16:52:39 InnoDB: Starting shutdown...
060215 16:52:40 InnoDB: Shutdown completed; log sequence number 0 43655
060215 16:52:40 [Note] C:Program FilesMySQLMySQL Server 5.0inmysqld-nt: Shutdown complete

View Replies !
MySQL Slow Starting Up
I am using a Windows 2003 Web Edition Server running IIS and MySQL 4.1. I had to restart the server the other day and it took MySQL almost 2 hours to come back up. I was watching it on my task manager and it went up to approximately 60,000k in 10k increments before I was able to access MySQL.

My CPU usage was hovering around 3% all this time. Everything else came up on the server just fine. This happens every time I have to restart my server. The reason I have to restart my server most of the time, is because MySQL locks up on me.

Is there any settings I can change that would help me here? Any help would be greatly appreciated.

One more thing to add. I am using the default my.ini file. We have almost 100 different databases on the server and have around 20000 tables within all of these databases combined. All of these tables are InnoDB tables.

View Replies !
Starting Mysql With Mysqld
i'm trying to change the mysql data path. to do this, i have to shoot down mysql and restart it. i tryed to restart mysql with the program mysqld (i'm using windows xp, mysql server 5.0), but it doesn't work. why? is there any different way to start mysql? there was no error message or something like this. if i start it with mysqld --standalone, it works, but the command window doesn't replay anymore.

View Replies !
Mysql Server Is Not Starting
I have finished installing a copy of mysql from source on mandrake 10 (from source, not an rpm source) and everything went smoothly except starting mysql.
I run "root@myBox> mysqld_safe --user=mysql &" and I get this message:

Starting mysqld daemon with databases from /usr/local/mysql/var
STOPPING server from pid file /usr/local/mysql/var/*my-ip-address*.pid
041219 12:06:03 mysqld ended

so the server isn't starting, which is a problem. What have I done wrong?. These are the instructions I followed (with a slightly different ./configure line), which are from the mysql reference manual: 2.3.1 Source Installation Overview
The basic commands you must execute to install a MySQL source distribution are:

View Replies !
Problem On Starting MySQL
Ubuntu-6.06-LAMP-server-amd64

I followed section "10 MySQL" on;
http://www.howtoforge.com/perfect_setup_ubuntu_6.06_p4

and found "libmysqlclient12-dev" not installed. After installing it MySQL unabled to start. I reinstalled all packages recommended there.

$ sudo apt-get install --reinstall mysql-server mysql-client libmysqlclient12-dev
Password:


Reading package lists... Done
Building dependency tree... Done
0 upgraded, 0 newly installed, 3 reinstalled, 0 to remove and 8 not upgraded.
Need to get 0B/3305kB of archives.
After unpacking 0B of additional disk space will be used.
Do you want to continue [Y/n]?
(Reading database ... 82866 files and directories currently installed.)
Preparing to replace libmysqlclient12-dev 4.0.24-10ubuntu2 (using .../libmysqlclient12-dev_4.0.24-10ubuntu2_amd64.deb) ...
Unpacking replacement libmysqlclient12-dev ...
Preparing to replace mysql-client 5.0.22-0ubuntu6.06.2 (using .../mysql-client_5.0.22-0ubuntu6.06.2_all.deb) ...
Unpacking replacement mysql-client ...
Preparing to replace mysql-server 5.0.22-0ubuntu6.06.2 (using .../mysql-server_5.0.22-0ubuntu6.06.2_all.deb) ...
Unpacking replacement mysql-server ...
Setting up libmysqlclient12-dev (4.0.24-10ubuntu2) ...
Setting up mysql-client (5.0.22-0ubuntu6.06.2) ...
Setting up mysql-server (5.0.22-0ubuntu6.06.2) ...
$ sudo /etc/init.d/mysql restart


Stopping MySQL database server: mysqld...failed.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'
Killing MySQL database server by signal: mysqld.
Starting MySQL database server: mysqld.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'
satimis@ubuntu:~$ /usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'
Please advise which file I have to edit getting the problem fixed. TIA



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 !
Newb Starting MySql-Permissions
I have debian running and this is how I have it setup

# ls -ld /var/lib/mysql
drwxr-xr-x 4 mysql mysql 4096 Aug 19 11:29 /var/lib/mysql

I was shown how to setup a password for user mysql here
http://dle.ascendant.ca/restoring-mysql-root-HOWTO.txt,

because at one time all I would have to do it hit enter after
# mysql -h localhost -p -u mysql
Enter password: (no password is added I just hit enter)
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 16 to server version: 4.0.14-log

Type 'help;' or 'h' for help. Type 'c' to clear the buffer.

mysql> ( can do whatever I want now???)

If I type in the correct password it lets me in, if I type in no passowrd it
lets me in, if I type in the INCORRECT password it does NOT let me in. How
can I make it so that if no password is typed it still treats it as
incorrect?

View Replies !
Mysql Not Starting After VPS Server Reboot
I have a mysql db (Version: '4.0.22' FreeBSD port: mysql-server-4.0.22) running on an Verio VPS, and I am having an issue: After a power failure on Verio that meant restarted servers, etc, I saw that Mysql was not coming up.

I checked the logs / etc and I got this message on /var/db/mysql/<hostname>.err:

060925 00:15:53 mysqld started
060925 0:15:53 bdb: Recovery function for LSN 1 29049 failed
060925 0:15:53 bdb: warning: ./testperl/testab.db: No such file or directory
mysqld in free(): warning: chunk is already free
060925 0:15:53 Can't init databases
060925 0:15:53 Aborting

There is no ./testperl/testab.db anywhere I can see, but OTOH, there should only be a few dbs and none of them is called testperl... Honestly, I have no idea of what might be hapening, but having the db is quite a PITA.

View Replies !
Starting MySQL 5.0.1 Server Up Problem...
I shutdown my MySQL server using MySQL Administrator 1.0. My problem is that i dont know how to start up the MySQL Server again. I tried to run mysqld-nt.exe by double clicking it but my server will not be up. If i restart my computer then thats the time my MySQL server will be up. Unlike MySQL 4.0.22 if i double click on winmysqladmin.exe my server will be up.

Is there a way to put the server up without restarting my computer?

View Replies !
Problem Starting MySql From Root
I am in the process of creating a database which will serve as a backend for the registration of users' details and to handle account activation via the use of php scripts. I really need help with starting MySql. I have scoured various forums and followed instructions from the mysql.com, and other such tutorials.

I am creating the website using dreamweaver on a windows 2000 pc but I am planning to place it on the linux box where the apache web server will handle it (if you know what I mean). The linux server is where the php and Mysql are installed. Incidentally the php installation is located in the /etc directory - and it works.

I downloaded the Mysql binary file version 4.0.25 recently. Followed the installation instructions to the letter up to the change of ownership stuff. Code:

View Replies !
Prevent MySQL From Starting At Startup
I'm starting to play around with MySQL. How can I prevent it from starting up whenever my computer starts? It slows down the startup some, and I'm not always wanting to use it. besides, I can start it myself if I need it.I've had a look on Google for theis, and found quite a few results, but they were fo Linux or Unix. I'm ruinning Windows XP.

View Replies !
Starting Fresh With Mysql >> Dadabik
I have an Excel spreadsheet which has been my source document for the past several years for a collection I own. It has about 2000 entries (records) and each record has ~20 fields. Photographs of each item in the database are an integral part of this.
What I'd like to do is move all of this knowledge onto the web in database fashion and provide a means to allow users to search the database.
I found DaDaBIK which seems to be perfect for the show and tell phase of my project, but I need to create the database properly first.
I can make a mysql database with my hosting account, but I don't know where to start. I know databases can be tricky; at least what I know of Access is tricky, so I want to do this right.

I'm looking for help, maybe a simple tutorial, that will guide me through the process of transforming my Excel data and photos into a mysql database online.

I have googled for this, but there are so many articles, and it is all over my head anyway.

View Replies !
MySQL Administrator Tool
I'd like to use MySQL Administrator application remotely from home. Possible? Will I have to open up port 3306? If so, is that safe?

View 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 !
MySQL Administrator For Web Administration
Can MySQL Administrator (from this website) be used to administer MySQL database over the web (a far off machine accessible via IP). If not, what is(are) other free software(s) that can easily do it for Windows platform.

View Replies !
Installing Mysql-administrator
(This is also posted in the install forum)
For some reason I can't get the rpm to install so I tried using the tarball and when I do this, the /opt/mysql-administrator-1.0.19/bin directory does not get created.

Command I used to install mysql-administrator:
shell> tar --directory=/opt -xzvf mysql-administrator-1.0.19.tar.gz
Does anyone have any suggestions or another way to install this application on Linux? ...or am I missing a step? The rpm is preferred, but anything that works would be great.

View Replies !
New User [MySQL Administrator]
I'm getting an error when adding a new user: After I've entered MySQL User: XXX-WEB, Password and Confirm Password, I click Apply Changes a message box shows MySQL Administrator Exception: Error while storing the user informaiton. The user might have been deleted. Please refresh the user.

I've refreshed, sooo many times... I think I may have messed up the MySQL schema and may have damaged some locks.

View Replies !
MySQL Remote Administrator
i will like to remote into mysql data base
what program ca i download

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 &amp; QueryBuilder
I have installed MySQL 4.0, MySQL Administrator and Querybuilder. In general all functions well. But two things do not function, which I would like to, because I need them:

(1) In the menu of Querybuilder --> Tools the link to Administrator is greyed out. How can I make it function? (Administrator to querybuilder is ok)

(2) More Important: in Administrator, loggedin as root with all grants, the (context-)menue eintry "edit tables values" is greyed out on any table. - How to make it function? How to edit values in the tables then?

(System: WXP-SP2, logged in with admin-rights)

View Replies !
MySQL Administrator Password
I have just installed mySQL 5 Community Edition and also all its tools viz. Administrator, Migration etc.. Presently I have installed it on a machines with no other machines connected to it. I also selected "Developer Machine" option while installing it.

When I open mySQL Administrator, it asks for Username and Password. I remember the password, but what is the default Username and Schema Name.

If I am running on a standalone machine, what to type in "Server Host" in the administrator window.

View Replies !
Having Problems Getting Mysql-administrator To Run
When I run mysql-administrator I get the following error. I installed the generic rpm on a Fedora Core 3 system. I have the latest version of pango.

/usr/bin/mysql-administrator-bin: symbol lookup error: /usr/bin/mysql-administrator-bin: undefined symbol: pango_renderer_get_type

View Replies !
MySql Administrator Rules
I find that MySql Administrator is a much more powerful and intuitive way to access databases than phpMyAdmin. I think I will be using this for all my projects now.

View Replies !
Setting Up MySQL Administrator (have WHM)
I would like to set up MySQL Administrator. (MySQL is taking up 50+ % of my CPU, and I'm not sure why...)

I'm having difficulty connecting to my MySQL db. I'm fairly sure I have the correct username and password. For the host, I just used my server's IP and for the Port, I have 3306. When I try to connect, I receive the following error...

MySQL Error Number 1130
Host '<IP address>' is not allowed to connect to this MySQL server.

I tried adding <IP address> to the MySQL Access Hosts using WHM, but don't think it's working. In fact, I think when I initially tried it... my phpmyadmin stopped working and I had to go in manually to the config file and fix it up.

View Replies !
Mysql Nt Service Stopped Starting After 2 Years
i have been running mysql on windows server 2003 for the last almost 2 years (its a really early version of mysql 4 anyway) but now all of a sudden mysql service stopped starting, i can go to services, press start and then refresh and its off again! i have a feeling that someone deleted the core mysql table (mysql) as it is now totally empty.

im not too good with my sql as i generally use mssql or whatever, infact mysql never really installed properly, the only user i could ever use was root but i didnt mind this so i just left it and it was fine for 2 years but now its just stopped all of a sudden and i cant get it back on.

i have enabled the mssql php exension as a backup system but i cant transfer any databases across without enabling mysql.. but it wont turn on! i tried several exes in e:mysqlin but none got it on (well one of them made the little winmysqladmin light go on for half a second)

View Replies !
MySQL Admin :: Administrator For MySQL Servers Has Encountered A Problem And Needs To Close
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 hit OK 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.

View Replies !
Starting MySQL Database Server Mysqld [FAIL]
Right now, I am using Ubuntu 8.04 and using mysql 5.0.51a.

I am receiving the following error:

* Starting MySQL database server mysqld [fail]

invoke-rc.d: initscript mysql, action "start" failed.

dpkg: error processing mysql-server-5.0 (--configure):

subprocess post-installation script returned error exit status 1 dpkg: dependency problems prevent configuration of mysql-server:

mysql-server depends on mysql-server-5.0; however: Package mysql-server-5.0 is not configured yet. dpkg: error processing mysql-server (--configure):

dependency problems - leaving unconfigured Errors were encountered while processing:

mysql-server-5.0
mysql-server

E: Sub-process /usr/bin/dpkg returned an error code (1)

View Replies !
Mysql 5.1 Windows Realease Server Starting Problem
I am a new user to MySQL, and I have run into difficulties starting it. I have successfully done this once a while back, and than had to go away for a while. I am now trying to start the server again via the windows command line.

I type: "C:Program FilesMySQLMySQL Server 5.1inmysqld" as directed from section 2.3.10 of the user guide and nothing happens. It just returns C prompt.

I then use "C:Program FilesMySQLMySQL Server 5.1inmysqld" --console; this gives screen output as I do not get a data directory with an error file without '--console'

The output is:

090419 17:30:38 InnoDB: Operating system error number 5 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory. It may also be you have reated a subdiretory
InnoDB: of the same name as a data file.
InnoDB: File name .ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.

And then goes back to C prompt on the command line.

Can anyone help me? If memory serves, I followed the user guide to the letter when I started (save for the post-startup material).

As well (and possibly related), I have the mysql command line client in windows on the desktop (c:program filesmysqlmysql server 5.1inmysql.exe). I click this and it prompts me for 'enter password'. I don't ever remember entering a password the last time which may be related to the first problem staring mysql server from the command line.

View Replies !
Starting MySQL Server With Federated Engine Support
I have MySQL service installed on my machine. I want to start the MySQL server with FEDERATED engine support. According to MySQL Federated Engine, I should start the server with --federated option. Where do I need to change this?

I tried adding federated to the my.cnf file. Then Federated engine started working and InnoDB stopped working.

After adding this line, I executed
MySQL Code:
SHOW ENGINES;
There, I couldn't find InnoDB in list.

View Replies !
Installing Mysql-administrator On Redhat
I am unable to install mysql-administrator on Redhat AS 4.

#rpm -i mysql-administrator-1.1.6-1.i386.rpm
erreur: Dépendances requises:
libstdc++.so.6(GLIBCXX_3.4.4) est nécessaire pour
mysql-administrator-1.1.6-1.i386

But I already have the library:
#ls -l /usr/lib/libstdc++.so.6
lrwxrwxrwx 1 root root 18 nov 16 17:27 /usr/lib/libstdc++.so.6 ->
libstdc++.so.6.0.3

Anybody have had such installation problem?

View Replies !
Can You Import/export Using MySQL Administrator?
We're looking at a GUI interface for our MySQL DB and I am interested
in MySQL Administrator, however, one of our requirements is to be able
to import/export databases. Is this possible or do I need to know else
(e.g. Navicat)?

View Replies !
Edit Permissions MySQL Administrator
How can I see/change permissions to alter table data using MySql Administrator? Of course I googled it first but I can't find the answer.

View Replies !
Error Running MySQL Administrator On RH8
I have downloaded the latest version of mysql administrator 1.0.18. I followed the installation instructions, but when i am unable to run the program. I get an error saying:

./mysql-administrator-bin: relocation error: ./mysql-administrator-bin: undefined symbol: gdk_display_get_type

Do you have any clue about what is happening?

View Replies !
MySQL Administrator GUI Running Slowly... WHY?
We have created an instance or schema that contains over 14000 tables. It is a lot of tables. When we attempt to browse the tables in the GUI it literally takes 5 minutes or more for it to come back. Granted when using the Microsoft SQL Server Management Studio it is slow but doesn't take that long. After about a minute or so it gives the list and is kind of slow to scroll.

Can this be fixed by optimizing the database? Is this just too many tables for mySQL to handle?

View Replies !
MySQL Administrator Client Installation
Can MySQL administrator installed on a client machine which has no MySQL database installed?

We have two MySQL installation on Linux. I want to check things from my desktop which is Windows via some graphical administration software.

Any possibility? When I try to connect one of the server I got error. Admin tool added my computer's domain suffix after the user name which I typed in...

View Replies !
Settings Up Mysql Administrator With 1and1
I just created a 1and1 account and configured WordPress to work with it. Now I am trying to access the backup with a GUI tool and setup MySQL Administrator on my local box. I set this up using the same settings that I entered while configuring the blog but I keep getting the error message: Could not connect to the specific instance.

MySQL error number 2005 and if I press ping it says: Could not resolve hostname. Has anyone setup this tool to work with 1and1 before? Does anyone know what this issue could be?

View Replies !
Trouble Logging Into MySQL Administrator
I've installed MySQL and it appears to running properly because I can enter data in the command line format but I'd like to use the graphical user interface of MySQL Administrator. When I try to log in, I can not get through.

Is there someplace on the MySQL website that I can go to send me a reminder of the information I used to set-up the server and how to properly fill-out this form? When I hit contol and skip, it shows that my server is running. I did save the original information I gave on the website during the server configuration and download procedures but when I try different combinations of this information, I'm still not able to access the Administrator functions.

View Replies !
Adding Users With MySQL Administrator
how do you add a new user to MySQL?

I am using the Administrator (1.1), MySQL 5.0 and clone the 'root' user, complete the name
and a password, and get a message

'Error while storing the user infromation. The user might have been deleted.
Please refresh the user list'

When I refresh the user list the new user entry disappears!

Same thing happens when using the 'New User' button

This is a fresh install - any ideas anyone??

View Replies !
MySQL Administrator - Password Storage
I am scheduling backups using MySQL Administrator and have to set the Password Storage options for it to work.

What I am wondering is how does the 'OS Specific' password storage method work?

Are any of these password storage methods secure? If not, how else can I automatically backup the server?

View Replies !

Copyright © 2005-08 www.BigResource.com, All rights reserved