LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 12-14-2015, 10:09 PM   #1
sraidr69
Member
 
Registered: Mar 2015
Posts: 59

Rep: Reputation: Disabled
Mysql Workbench freezes when stopping server


I have a fresh install of Mint 17.2 and imported 4 schemas. All of the databases show "Tables could not be fetched." When I try to delete them I get "Can't drop database 'mydb'; database doesn't exist, 1008" I found a post that said to stop the server, go to the 'datadir' and delete from there. When I tried to stop the server, Workbench always freezes up. When I tried to access /var/lib/mysql I do not have rights.

How do I delete the imported schemas? Even though I set my user as group 'root' why do I not have rights? Why does Workbench always freeze? I have even uninstalled and reinstalled.
 
Old 12-16-2015, 07:29 AM   #2
swampthing001
Member
 
Registered: May 2005
Distribution: LFS, CentOS, Slack, Ubuntu
Posts: 112

Rep: Reputation: 8
Have you tried closing MySqlWorkbench before stopping the server? It sounds like it could be a group/permissions issue. Either the folder the schemas are in doesn't have the right permissions or the user account doesn't have the right permissions. Or it could be a group issue as in the user isn't part of the right group.
 
Old 12-16-2015, 07:33 AM   #3
swampthing001
Member
 
Registered: May 2005
Distribution: LFS, CentOS, Slack, Ubuntu
Posts: 112

Rep: Reputation: 8
Take a look at this, I know its a password reset but the post mentions some maintenance commands that might help solve your issue or point you in the right direction.
http://forums.linuxmint.com/viewtopic.php?f=47&t=207347
 
Old 12-16-2015, 11:05 AM   #4
Habitual
LQ Veteran
 
Registered: Jan 2011
Location: Yawnstown, Ohio
Distribution: Mojave
Posts: 9,349
Blog Entries: 36

Rep: Reputation: Disabled
Quote:
Originally Posted by sraidr69 View Post
I found a post that said to stop the server, go to the 'datadir' and delete from there.
That post would be wrong.
There is only one 'datadir' directive for an installed version of mysql.
Deleting 'from there' is a poor choice.

Disconnect and Shut down mysql workbench.
On the mysql host:
Code:
service mysql stop
and then
Code:
rm -fr /var/lib/mysql/<name_of_db>/
would be what I'd do in this instance.

NOTE: mysql workbench session will have to be edited if it opens or tries to open the rm'd database.
NOTE: "Mysql Workbench freezes when stopping server." sounds normal to me. it is what I'd expect.

Last edited by Habitual; 12-16-2015 at 11:15 AM.
 
Old 12-17-2015, 09:59 PM   #5
sraidr69
Member
 
Registered: Mar 2015
Posts: 59

Original Poster
Rep: Reputation: Disabled
I was able to stop the server, delete the db and then restart. I am trying to import my backup from an external drive and got this...

Quote:
Operation failed with exitcode 1
08:56:17 PM Import of /media/keith/My Book/dumps/test.sql has finished with 1 errors
Also, workbench froze up again when trying to start the server again. So I did it from the terminal. I have not seen this as a bug anywhere, does anyone know why this would happen? Again, fresh install of Mint 17.2
 
Old 12-18-2015, 07:45 AM   #6
Habitual
LQ Veteran
 
Registered: Jan 2011
Location: Yawnstown, Ohio
Distribution: Mojave
Posts: 9,349
Blog Entries: 36

Rep: Reputation: Disabled
Quote:
Originally Posted by sraidr69 View Post
I have not seen this as a bug anywhere, does anyone know why this would happen? Again, fresh install of Mint 17.2
You haven't "seen it", because it is Not a bug.
It is expected behavior for a client-server session.
Mail clients are another example of expected similar behavior.
ftp clients too.

They all have 2 things in common:
The are clients in a client-server relationship and are connected.
A remote service-daemon gets restarted.
The client software can get hung up.

This happens more than you realize.
Stop fresh installing, unless you're bored.

If you truly do have technical issues, they should be logged in ~/.mysql/workbench/log/

Last edited by Habitual; 12-18-2015 at 07:48 AM.
 
Old 12-30-2015, 10:52 PM   #7
sraidr69
Member
 
Registered: Mar 2015
Posts: 59

Original Poster
Rep: Reputation: Disabled
I ended up not being able to delete a db from the terminal, figured I had too many issue with this so I decided to completely remove, purge and reinstall. This went well until logging in. During reinstall I was prompted for a new root password, and to re-enter it. Now when I login it does not accept my password, I get this...

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Habitual...not bored, I was running Mint 14 and needed to get to php5.5 which meant upgrading.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Mysql Workbench cannot connect LoneWolf69 Linux - Newbie 1 11-30-2011 11:28 PM
Cannot compile mysql-workbench zeroberto Slackware 12 06-03-2011 07:13 AM
MySQL Workbench for RedHat zeroquaranta Linux - Server 6 03-01-2010 03:49 AM
LXer: Visual MySQL Database Design in MySQL Workbench LXer Syndicated Linux News 0 06-12-2008 08:00 PM
MySQL Workbench grahamtysall Linux - General 1 07-27-2007 04:30 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 12:02 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration