MySQL Forums - Workbench - Database Administration Forum for Database Administration. http://forums.mysql.com/list.php?160 Wed, 19 Jun 2013 23:55:04 +0000 Phorum 5.2.19 http://forums.mysql.com/read.php?160,588431,588431#msg-588431 Backup / Dump by console (1 reply) http://forums.mysql.com/read.php?160,588431,588431#msg-588431
Im working with MySql Workbench 5.2CE.

Always that I have to make a backup I use the the graphical interface (GUI) to select the databases and tables that I need to backup.

Into the MySql Workbench I always select the option

Server Administration > Data Export and Restore

and in the righ window, i select databases and table and later I select the options


"Export to Self-Contained file"
"Dump views"
"Dump Stored Routines (Procedure and functions)"

With this the backup is done successful, but now I need make the same backup but with the mysql console.

Can somebody tell me how can I make this backup, including the options specified above?

Thank you very much]]> Lucas Sm Workbench - Database Administration Wed, 12 Jun 2013 12:52:28 +0000 http://forums.mysql.com/read.php?160,588198,588198#msg-588198 Access denied for user root@[ip] (2 replies) http://forums.mysql.com/read.php?160,588198,588198#msg-588198
I have done a "GRANT ALL PRIVILEGES ON *.* TO 'root'@'[ip]', and when I do a "show grants for 'root'@'[ip]' (when logged directly into the server and logged in as localhost) I can see it's there. So, what's going on?]]> Jesse Castleberry Workbench - Database Administration Thu, 13 Jun 2013 08:11:10 +0000 http://forums.mysql.com/read.php?160,585133,585133#msg-585133 Active Directory user permissions (no replies) http://forums.mysql.com/read.php?160,585133,585133#msg-585133 We are running the latest version of mysql server CE on a RedHat machine.
In another windows 7 machine, we have the latest mysql workbench.
All of our authentication methods are mysql based.
When I test one of the users connection settings under a windows 7 workbench client, it all go smooth with a "connection parameters are correct" message, but when I try to open the connection to start querying I get this error message:

"Your connection attempt failed for user 'xxx' from your host to server at xxx:3306:
Could not open database"

If I change the user permissions in active directory, granting him domain administrator priviledges, the connection then opens with no problem at all.

What does AD permissions have to do with user authentication in workbench?
Maybe it's a system folder or file write permissions?

Thank you very much]]> Augusto Toledo Workbench - Database Administration Mon, 29 Apr 2013 17:54:03 +0000 http://forums.mysql.com/read.php?160,585089,585089#msg-585089 Workbench - Could not connect to MySQL server during Test DB Connection (4 replies) http://forums.mysql.com/read.php?160,585089,585089#msg-585089
Unfortunately, I wasn't able to get the connections to Xammp set up correctly (probably due to my company's security policies and SW component removal). Therefore, I purchased a new laptop, and downloaded the same MySQL Workbench 5.2.47.CE rev10398. The new laptop runs Win8. Xammp is now running on the new platform :-) However, I cannot connect to the MySQL server during the "Test DB connection" task.

In both cases, Win7/Win8, I followed the Workbench documentation for new server instances, giving the default inputs, but the responses were different for the same input.

Win7 / Win8
Click "New Server Instance" in Server Administration
"localhost" is highlighted in radio button.
Click "Next"
Hostname: localhost
Port: 3306
Username: root
Password: <Store in Vault> or <Clear> {no difference to problem)
Default Schema: <left blank>
Click "Next"
{everything is the same to here}

Win7
Screen Log:
"The database connection information is being tested...."
{checked} Open Database Connection
{checked} Get Server Version: 5.6.10
{checked} Get Server OS:Windows
"Database connection tested successfully."

Win8
Screen Log:
"The database connection information is being tested...."
{red "X"} Open Database Connection
{red "X"} Get Server Version: 5.6.10
{red "X"} Get Server OS:Windows
{in red} "Could not connect to MySQL server:"
{in red} "Can't connect to MySQL server on '127.0.0.1' (10061)"
{in red} "You may continue if the server is simply not running."
Message Log:
Connection to MySQL server localhost...
Can't connect to MySQL server on '127.0.0.1' (10061)

Win7 platform = Lenovo T420, Intel Core i5-2520M processor
Win8 platform = Acer Aspire V5, Intel Core i5-3337U processor

Can you please provide guidance on to resolve this server connection issue.

Thanks.
Jeremy]]> Jeremy Burr Workbench - Database Administration Thu, 30 May 2013 17:02:57 +0000 http://forums.mysql.com/read.php?160,584364,584364#msg-584364 Jose Maria Pando (no replies) http://forums.mysql.com/read.php?160,584364,584364#msg-584364 Local instance MySQL5.5 -root@servername:3306 <Standard (TCP/IP)]]> Jose Maria Pando Moreno Workbench - Database Administration Fri, 19 Apr 2013 20:56:30 +0000 http://forums.mysql.com/read.php?160,583559,583559#msg-583559 mysqlfailover failing to failback (3 replies) http://forums.mysql.com/read.php?160,583559,583559#msg-583559
I have been playing with mysqlfailover but a problem seems to stump me every time. It has to with the slave promoted to master and if shutdown, the datafiles can become corrupt, causing a crash dump and won't start again until that server is rebuilt. Let me explain:

The set-up:
2 x MySQL 5.6.10 on Redhat 6.3 x86_64.
IP addresses: 192.168.25.161, .162 respectively
Initially 1 x slave and 1 x master, set up with the following commands:
# mysql_install_db --datadir=/data
# /etc/init.d/mysql start
mysql> create user 'repl'@'%' identified by 'password';
mysql> grant all on *.* to 'repl'@'%';
mysql> RESET MASTER; RESET SLAVE;
Then on 1st server:
mysql> CHANGE MASTER TO MASTER_HOST = '192.168.25.162',MASTER_USER = 'repl', MASTER_PASSWORD = 'password', MASTER_AUTO_POSITION = 1;
And 2nd server:
mysql>CHANGE MASTER TO MASTER_HOST = '192.168.25.161',MASTER_USER = 'repl', MASTER_PASSWORD = 'password', MASTER_AUTO_POSITION = 1;

/etc/my.cnf (similar to the sample in PDF, with IP address adjusted):
[mysqld]
binlog-format=ROW
log-slave-updates=true
gtid-mode=on # GTID only
enforce-gtid-consistency=true # GTID only
master-info-repository=TABLE
relay-log-info-repository=TABLE
sync-master-info=1
slave-parallel-workers=2
binlog-checksum=CRC32
master-verify-checksum=1
slave-sql-verify-checksum=1
binlog-rows-query-log_events=1
server-id=1
report-port=3306
port=3306
log-bin=black-bin.log
datadir=/data
socket=/data/mysql.sock
report-host=192.168.25.161
relay-log = /data/relay-bin
general-log = 1
skip-slave-start = 1


What I did:
I started mysqlfailover like this:
#mysqlfailover --master=repl:password@192.168.25.161 --discover-slaves-login=repl:password --exec-before=/root/pre-failover.sh --exec-after=/root/post-failover.sh --rediscover

And mysqlfailover starts with 192.168.25.161 = master. 192.168.25.162 = slave.

For the first failover, things were sweet. .162 becomes master. I restarted Mysql on .161 successfully, resumed replication on .161. mysqlfailover recognises it as slave (Good!).

So I tried to failback such that .161 becomes the master again. When I stop the Mysql process (/etc/init.d/mysql stop and kill. I tried both), .162 produces this in the log. (Full log attached)

-------------

2013-04-11 01:56:20 25747 [Note] InnoDB: Starting shutdown...
2013-04-11 01:56:21 7fbe34e69700 InnoDB: Assertion failure in thread 140454908040960 in file trx0rseg.cc line 125
InnoDB: Failing assertion: UT_LIST_GET_LEN(rseg->update_undo_list) == 0
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
17:56:21 UTC - mysqld got signal 6 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.

key_buffer_size=8388608
read_buffer_size=131072
max_used_connections=4
max_threads=151
max_threads=151
thread_count=0
connection_count=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 68216 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0 thread_stack 0x40000
/usr/sbin/mysqld(my_print_stacktrace+0x35)[0x8bfd45]
/usr/sbin/mysqld(handle_fatal_signal+0x4a4)[0x65b074]
/lib64/libpthread.so.0(+0xf500)[0x7fbe4d5b7500]
/lib64/libc.so.6(gsignal+0x35)[0x7fbe4c2648a5]
/lib64/libc.so.6(abort+0x175)[0x7fbe4c266085]
/usr/sbin/mysqld[0x9a5cf8]
/usr/sbin/mysqld[0x9a8139]
/usr/sbin/mysqld[0x98f2bf]
/usr/sbin/mysqld[0x8dad94]
/usr/sbin/mysqld(_Z22ha_finalize_handlertonP13st_plugin_int+0x2e)[0x5a000e]
/usr/sbin/mysqld[0x6e05ee]
/usr/sbin/mysqld(_Z15plugin_shutdownv+0x233)[0x6e0ff3]
/usr/sbin/mysqld[0x594638]
/usr/sbin/mysqld(_Z10unireg_endv+0xe)[0x5949de]
/usr/sbin/mysqld[0x5978c8]
/usr/sbin/mysqld(kill_server_thread+0xe)[0x597a7e]
/usr/sbin/mysqld(pfs_spawn_thread+0x139)[0xadc7d9]
/lib64/libpthread.so.0(+0x7851)[0x7fbe4d5af851]
/lib64/libc.so.6(clone+0x6d)[0x7fbe4c31967d]
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
130411 01:56:21 mysqld_safe Number of processes running now: 0

------------

mysqlfailover looks really promising if we can use it for production. Any help is appreciated.

Regards,

Rayson Chan]]> Rayson Chan Workbench - Database Administration Thu, 11 Apr 2013 03:36:33 +0000 http://forums.mysql.com/read.php?160,583439,583439#msg-583439 Error occured: Cannot start SSH tunnel manager (1 reply) http://forums.mysql.com/read.php?160,583439,583439#msg-583439 Les Fenison Workbench - Database Administration Fri, 03 May 2013 16:26:58 +0000 http://forums.mysql.com/read.php?160,582288,582288#msg-582288 Import help please! (2 replies) http://forums.mysql.com/read.php?160,582288,582288#msg-582288
00:29:55 Restoring C:\Users\osyrys\Documents\aussie work\cdr\cdr\CDR\mel\2012-08\billing_file_2012-08-01_00-00-00.txt

Running: mysql.exe --defaults-extra-file="c:\users\osyrys\appdata\local\temp\tmp3qclwa.cnf" --host=103.9.53.42 --user=root --port=3306 --default-character-set=utf8 --comments < "C:\\Users\\osyrys\\Documents\\aussie work\\cdr\\cdr\\CDR\\mel\\2012-08\\billing_file_2012-08-01_00-00-00.txt"

ERROR 1064 (42000) at line 1: 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 'H|2012-08-01 00:00:00||billing_file_2012-08-01_00-00-00.txt|4

D|1|U|1|2012-08-01' at line 1


Operation failed with exitcode 1

00:29:58 Import of C:\Users\osyrys\Documents\aussie work\cdr\cdr\CDR\mel\2012-08\billing_file_2012-08-01_00-00-00.txt has finished with 1 errors]]> Osyrys Edmister Workbench - Database Administration Mon, 25 Mar 2013 08:36:14 +0000 http://forums.mysql.com/read.php?160,581263,581263#msg-581263 Workbench not creating Server Instances (3 replies) http://forums.mysql.com/read.php?160,581263,581263#msg-581263
The MySQL Server service is running, because it starts up automatically.

I am using Workbench v5.2.47 CE.

Both were installed using the MySQL Installer.

I am running as a user with administrative privileges.

NOTE: This all is running on Windows 8.

I am attempting to create a new server instance.

1. I go to the main page and click on the "New Server Instance" link.

2. My service is local, so I select localhost and click Next.

3. I do not change anything in the subsequent screen (because I know, after a lot of attempts, that this will not work). Because I am doing administration, I leave the login at root. I click on Next.

4. Workbench tests the connection to my service. All tests succeed. I click on Next.

5. The subsequent window that comes up says "No MySQL Service Found". The comboox has nothing in it. And because it cannot find my running service I cannot proceed at all.

6. I have tried restarting the system several times (this seemed to solve a similar problem with Server 5.5), but the problem persits.

Have I found a bug in this Workbench? Or is there some way that I can make it find my MySQL service?

Someone please advise.]]> John Sheridan Workbench - Database Administration Fri, 15 Mar 2013 08:33:51 +0000 http://forums.mysql.com/read.php?160,581262,581262#msg-581262 remote server administration in mysql workbench not working on oensuse 12.3 (3 replies) http://forums.mysql.com/read.php?160,581262,581262#msg-581262
I'm using mysql workbench on opensuse 12.1 without any problems.
The new version 5.2.44 on opensuse 12.3 works for sql editor (remote) at least I can connect and view tables etc. but remote server administration does not work.
I have migrated and created also new connections nothing work.
There is always the error:

Administrator plugin not found

Is this not anymore included in newer versions? Is this only an opensuse problem?
No body having this problem?

Greetings

Beat

Here is output of Scripting/Scripting Shell

Registered 175 GRT classes.
Traceback (most recent call last):
File "/usr/lib64/mysql-workbench/modules/wb_admin_grt.py", line 27, in <module>
import wb_admin_main
File "/usr/lib64/mysql-workbench/modules/wb_admin_main.py", line 29, in <module>
import wb_admin_monitor
File "/usr/lib64/mysql-workbench/modules/wb_admin_monitor.py", line 21, in <module>
import wba_monitor_be
File "/usr/lib64/mysql-workbench/modules/wba_monitor_be.py", line 27, in <module>
import wb_admin_ssh
File "/usr/lib64/mysql-workbench/modules/wb_admin_ssh.py", line 51, in <module>
if paramiko and paramiko.__version_info__ >= (1, 7, 4):
AttributeError: 'module' object has no attribute '__version_info__'
Registered 34 modules (from 32 files).
Looking for user plugins in /home/bmeier/.mysql/workbench/modules
MySQL Generic Runtime Environment 4.1.0

Type '?' for help.
Python Shell initialized. (Use Preferences -> General to set language)
Ready.]]> Beat Meier Workbench - Database Administration Thu, 14 Mar 2013 19:33:42 +0000 http://forums.mysql.com/read.php?160,581131,581131#msg-581131 Permissions (2 replies) http://forums.mysql.com/read.php?160,581131,581131#msg-581131
If I have a few users in the db how do I set up different permissions to different tables.
Say person X has full rights to table 1 but only read rights to table 2
Say person Y has read rights to both Table 1 and table 2

In the workbench I can see how to add a user and give that user read, update, add, delete etc rights...but not on a table specific basis

Thanks.]]> Jay Kappy Workbench - Database Administration Thu, 14 Mar 2013 09:06:34 +0000 http://forums.mysql.com/read.php?160,580129,580129#msg-580129 Error Starting workbench Administrator (1 reply) http://forums.mysql.com/read.php?160,580129,580129#msg-580129 I am using workbench with following specs
- workbench version : 5.2.45 CE
- OS : windows 7 Home Premium edition. (64 bit)
I have two connections to remote servers with both of them having following specs
- MySQL : Server version: 5.5.28 MySQL Community Server (GPL).
- OS: Fedora 17 (64 bit).

I am facing following problems;
1. Clicking on Server Administrator showing following error alert

"Error starting workbench administrator
QueryError: Error executing 'SHOW PLUGINS'
Can't create/write to /tmp/#sql_4dd_0.MYI' (Errcode: 2).
SQL Error : 1"

2. Clicking on SQL Editor ("Open Connection to Start Querying"), does connect to database , but Object Browser does endlessly show "Tables fetching", "View fetching" and "Routines fetching". But in case I query the tables, it does fetch results. (It was working properly previously)

3. It is not specific to workbench, but if I modify anything in the database through my application (bamboo), it gives me following error
java.sql.SQLException: Can't create/write to file '/tmp/ib75mSTm' (Errcode: 2)
at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.migrate(EntityManagedActiveObjects.java:47)

I am new to db administration , so any help will be appreciated.]]> Dev One Workbench - Database Administration Fri, 01 Mar 2013 07:45:44 +0000 http://forums.mysql.com/read.php?160,579339,579339#msg-579339 Crashes, crashes exporting objects (2 replies) http://forums.mysql.com/read.php?160,579339,579339#msg-579339
I'm on Mac OS Mountain Lion:
* MYSQL Workbench 5.2.44 in server administrator exporting selected objects to single transaction dump file
Crash every time

* MYSQL Workbench 5.2.47 trying to start the Server administration for a particular server
KeyError: '%ProgramFiles%'
Can't even get in anymore.

In both cases, the connection is localhost through ssl

Does anybody know a version that works? I recently moved to Mac OS and on Windows things work or fail from version to version unfortunately.

Kind regards,
Marc]]> Marc Schipperheyn Workbench - Database Administration Sun, 17 Feb 2013 18:33:11 +0000 http://forums.mysql.com/read.php?160,578147,578147#msg-578147 Server Admin giving error on v5.2.45 (6 replies) http://forums.mysql.com/read.php?160,578147,578147#msg-578147
Quote

Error Starting Workbench Administrator

UnboundLocalError: local variable 'datadir' referenced before assignment

This only happens on one (of three) instances I'm trying to connect to.

About the instance:
MySQL Server Version: 5.0.24a-community-nt
Server OS: Windows Server 2003 R2
Server Memory: 4GB

The other instances I try DO work, and include these versions:
5.1.29-rc-community (Windows Server 2008)
5.0.84 (Linux)

In case it was not clear: I did not have this issue with 5.2.37, and it goes away if I roll BACK to that version. I'm thinking it may be a bug, but wanted to get more input before I file a report.

What more can I tell you? Help me to help you to help me. :-D

TIA!]]> Greg Brown Workbench - Database Administration Fri, 08 Feb 2013 14:23:12 +0000 http://forums.mysql.com/read.php?160,577532,577532#msg-577532 How to take 1 year backup in mysql? (1 reply) http://forums.mysql.com/read.php?160,577532,577532#msg-577532
I have MySql database 5.0, my client require the last year database backup i.e., from 01-Jan-2012 to 31-Dec-2012, how can I take the one year database backup?

Regards
Chakravarthy]]> chakravarthy l Workbench - Database Administration Tue, 05 Feb 2013 14:41:52 +0000 http://forums.mysql.com/read.php?160,576879,576879#msg-576879 Putting MySQL on hold for backup (3 replies) http://forums.mysql.com/read.php?160,576879,576879#msg-576879 The database is used to store incoming measurement data, which is pushed by measurement stations, so that we do not really have control over when and how much data is coming in.

The database runs under SLES and VMware. The backup is executed as a virtual machine backup, not with database tools. This runs fine for most of the times, but randomly, the backup and large incoming data loads overlap which in turn drives the backup into a desaster: running for days, eating up all disk space, etc. On the other hand, a stop of MySQL at a given time would interrupt a currently running data load, which is for many reasons not very beneficial.

Of course, we could start to write loading software, which is more fault tolerant and digests reloads after being interrupted. We could implement semaphores, which coordinate loading procedures and backup procedures.

An easy way would be just to put the database deamon processes on hold on the OS level, so that they don't write during the backup and release them afterwards.

Any experience with such a procedure ? Any hint for a semaphore framework as an alternative ? Thank you for any comment on these thoughts in advance.
Sam.]]> Sam D Workbench - Database Administration Mon, 04 Mar 2013 12:53:48 +0000 http://forums.mysql.com/read.php?160,576812,576812#msg-576812 Windows Azure: using MySQL Workbench (no replies) http://forums.mysql.com/read.php?160,576812,576812#msg-576812 http://blogs.msdn.com/b/onemicrosoftvoice/archive/2013/01/02/using-mysql-workbench-with-windows-azure-web-sites.aspx
http://www.windowsazure.com/en-us/develop/php/tutorials/website-w-mysql-and-git/
http://www.windowsazure.com/en-us/manage/linux/common-tasks/mysql-on-a-linux-vm/
http://www.windowsazure.com/en-us/manage/windows/common-tasks/install-mysql/]]> Edwin Desouza Workbench - Database Administration Thu, 03 Jan 2013 23:14:13 +0000 http://forums.mysql.com/read.php?160,576740,576740#msg-576740 How much data can mysql free version handle? (1 reply) http://forums.mysql.com/read.php?160,576740,576740#msg-576740
How can you see the data usage that is present in the current database?

What do you do if the database cannot handle that amount of data?

using the latest ver of mysql workbench]]> jy tan Workbench - Database Administration Thu, 03 Jan 2013 08:46:08 +0000 http://forums.mysql.com/read.php?160,575949,575949#msg-575949 How is it possible that Workbench is getting worse with time? (1 reply) http://forums.mysql.com/read.php?160,575949,575949#msg-575949 Kevin Rowe Workbench - Database Administration Thu, 13 Dec 2012 14:16:36 +0000 http://forums.mysql.com/read.php?160,575287,575287#msg-575287 Problem with New Connection (3 replies) http://forums.mysql.com/read.php?160,575287,575287#msg-575287 "Figure 4.4. Getting Started Tutorial - Connection Test".
Error: Connecting to MySQL server localhost...
Can't connect to MySQL server on '127.0.0.1' (10061)
What me doing?]]> Maxim Ponomarev Workbench - Database Administration Sat, 23 Feb 2013 08:50:05 +0000 http://forums.mysql.com/read.php?160,571430,571430#msg-571430 MySQL Query Execution (1 reply) http://forums.mysql.com/read.php?160,571430,571430#msg-571430 Am new to MySQL Workbench. I dont know how to execute queries and where should i write my queries to execute, Please guide me as such.
Your replies are valuable

Thanks and Regards]]> Star fish Workbench - Database Administration Thu, 18 Oct 2012 12:22:23 +0000 http://forums.mysql.com/read.php?160,571091,571091#msg-571091 Keep connection (no replies) http://forums.mysql.com/read.php?160,571091,571091#msg-571091
I have a Mysql database and I make the connection through C#.net.

I make the connection to the db since my application, but if i dont use the application for at least 3 to 5 minutes I lost the connection with the db.

I had modified some timer in the mysql administrator, but the result is the same.

Can somebody tell me what parameters/timer I have to modify in the db administrator to keep opened the connection for at least 1 hour.

Thanks in advanced]]> Lucas Sm Workbench - Database Administration Mon, 15 Oct 2012 16:33:56 +0000 http://forums.mysql.com/read.php?160,568397,568397#msg-568397 Remote management & logs (1 reply) http://forums.mysql.com/read.php?160,568397,568397#msg-568397 I'm trying to see the MySql logs via the Server Administration panel.
I have an SSH user on the MySql server with permission to read the log files. The MySql server runs on Ubuntu.

When I set up a New server instance in the Server Administration panel, I chose SSH login based management, then I enter the hostname of the MySql server and the SSH user and password.

The wizard connects fine to the host machine, but it failed on the second step "Check location of start/stop commands" with this message:

What check_admin_commands

Operation failed: /etc/init.d/mysqld start is invalid


Any idea of what's wrong?

Thanks!]]> Mathieu Savaria Workbench - Database Administration Thu, 13 Sep 2012 23:29:02 +0000 http://forums.mysql.com/read.php?160,568387,568387#msg-568387 Invalid Authentication Plugin Warning (9 replies) http://forums.mysql.com/read.php?160,568387,568387#msg-568387 MySQL Server 5.6
MySQL Workbench 5.2
Windows Server 2008 R2

When I create a new user account with MySQL Workbench I get the following warning:

Invalid Authentication Plugin

User marc@% has plugin type mysql_native_password, which
is not listed as a known authentication plugin by the server.

But, with the command show plugins in the query browser, I can see that the status of mysql_native_password is ACTIVE.

Do I miss something somewhere ?
Can somebody help me ?

THANKS]]> marc hetu Workbench - Database Administration Mon, 29 Oct 2012 08:44:41 +0000 http://forums.mysql.com/read.php?160,565682,565682#msg-565682 workbench - how to view table size (kb) and table info/status? (no replies) http://forums.mysql.com/read.php?160,565682,565682#msg-565682 I'm not sure why topics without answers are closed:
http://forums.mysql.com/read.php?152,368964,368964

So I'm repeating the question.

In MySQL Administrator & Query Browser Tools you could check the size of the tables, where you can check the size of tables in Workbench?]]> Rafal W Workbench - Database Administration Mon, 20 Aug 2012 14:42:37 +0000 http://forums.mysql.com/read.php?160,565403,565403#msg-565403 Can't create a new server instance in workbench (no replies) http://forums.mysql.com/read.php?160,565403,565403#msg-565403
The test environment is composed of two windows xp:
* Windows boxes don't belong to a domain
* MySQL 5.6
* MySQL Workbench 5.2.42 CE

Following some notes about:
* The connection to the database is created fine. The problem appears setting up remote management.
* Remote WMI tested and working: wmic works well with any query (using /node, /user and /password switches)
* Used the administrator account for all this tests.
* Firewall is shutted down

If I use <user name> in the username field, I get the message: "Could not set up connection: Could not connect to target machine"
Also, I can see the authentication failure in the security log in the server machine

If I use <server machine name>\<user name> in the username field, I get the message: "Could not set up connection: WMI query execution failed with this error: access denied". In this case there is no security log

I've analyzed the problem with wireshark. Using <server machine name>\<user name> for the authentication, I can see the DCERPC transaction.
- The session is opened correctly: I can see the correct authentication
- The request message (RemoteCreateInstance) is accepted and the second socket (used in RPC) is opened. In this first authentication, <server machine name> is used for the domain name and the <user name> previously entered is sent.
- In the second socket (the one opened by the endpoint mapper), I can see the IWbemServices Request (with the WQL query in the payload). The authentication is performed in a previous AUTH3 packet with <client machine name> as the domain name and the local username in the username field. So the server sends a "Fault" response, telling access is denied (the status is nca_s_fault_access_denied).
It is clear that the second authentication information is wrong.


I've looked at the workbench source code (for 5.2.42). I've found the error message in the WmiServices::query method in wmi.cpp (from backend/wbprivate/workbench). The exception becomes an error message in WindowsManagementPage::enter in new_server_instance_wizard.cpp (from frontend/common).
I suppose it is an exception rised from line:
wmi_result = module->call_function("wmiQuery", arguments);

The query is done here:
HRESULT hr = _services->ExecQuery(L"WQL", converted_query, WBEM_FLAG_FORWARD_ONLY, NULL, &enumerator);

I don't know much about DCOM programming, but I think that the problem is in CoSetProxyBlanket. It should be call with a SEC_WINNT_AUTH_IDENTITY_EX or SEC_WINNT_AUTH_IDENTITY in the pAuthInfo parameter, on the first call (line 322 in wmi.cpp). This is explained in the API reference (http://msdn.microsoft.com/en-us/library/windows/desktop/ms692692%28v=vs.85%29.aspx).

I really don't know if this is a bug or is just a consequence of the logic used for domain login. I'm trying to set up an environment to compile workbench, to test the change.

Any help? Is there another way to create this server instance? Or just a workaround?

Thanks
Best regards,
Andres]]> Andres Kasulin Workbench - Database Administration Fri, 17 Aug 2012 22:34:11 +0000 http://forums.mysql.com/read.php?160,564939,564939#msg-564939 how can i disable a mysql function? (no replies) http://forums.mysql.com/read.php?160,564939,564939#msg-564939
how can i disable a mysql function?
for example version() and so on.]]> ahmad gholam Workbench - Database Administration Tue, 14 Aug 2012 05:50:36 +0000 http://forums.mysql.com/read.php?160,564706,564706#msg-564706 Error 1025 ALTER TABLE , Error 1050 (no replies) http://forums.mysql.com/read.php?160,564706,564706#msg-564706
SQL Statement:

ALTER TABLE `rentauto`.`auto` CHANGE COLUMN `marca` `marca` VARCHAR(45) NOT NULL



ERROR: Error when running failback script. Details follow.



ERROR 1050: Table 'auto' already exists

SQL Statement:

CREATE TABLE `auto` (]]> Daytom Ross Workbench - Database Administration Sat, 11 Aug 2012 02:44:30 +0000 http://forums.mysql.com/read.php?160,564233,564233#msg-564233 Creating Multiple server instances using Mysql workbench on Windows (1 reply) http://forums.mysql.com/read.php?160,564233,564233#msg-564233
How to create 2 server instances on 2 different ports using mySql workbench.
Currently single server instance is running on port 3306.
How to create one more instance and make it run on port 3307.
I tried using "New Server Instance" option and created a new instance.
But after the restart of mySql server is done, server instance running on port 3307 becomes active and the instance running on port 3306 doesn't work.
How to run both the server instances simultaneously.]]> Dikshit Gokhale Workbench - Database Administration Tue, 07 Aug 2012 15:59:03 +0000 http://forums.mysql.com/read.php?160,564045,564045#msg-564045 USER STEALING DATABASE USING DUMP WTF!? (1 reply) http://forums.mysql.com/read.php?160,564045,564045#msg-564045
I have set someone previlages on my mysql database ( BUT I CANT SEEM TO FIND THE OPTION TO GIVE HIM "DUMP" command or not!)

I see only EXECUTE. wtf! that maens anyone that can acces the DB can steall it for themselfs!?


I didnt even have him set server previlages only 1 DB previlages and that is " SELECT , UPDATE, CREATE , DELETE INSERT" in 1 SPECIFIC DATABASE!


Please help me to take his other previlages away such as prevent him from exporting my stuff!

Else anyone can steal from anyone around the world this way! wtf !]]> qaz zaq Workbench - Database Administration Sun, 05 Aug 2012 12:57:15 +0000