LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices


Reply
  Search this Thread
Old 03-09-2010, 09:32 AM   #1
sinchan_
LQ Newbie
 
Registered: Apr 2009
Posts: 12

Rep: Reputation: 0
mysql databases disapeared from GUI tools


hi all

I have a system with opensuse 11.0 and mysql

After changing the administrator password only information_schema and test databases are shown in GUI tools (webmin or mysql administrator GUI tool). After the error I restored the password to the old used

if I use mysql in terminal, and use show databases; I can see the 7 databases that I have.

I aslo cannot access to any field using GUI tools (cannot acces to database permissions, or MySQL Server Configuration, host permissions or MySQL system variables). The error is:

DBI connect failed : Access denied for user ''@'localhost' to database 'mysql'

Do you know how to restore the view/access to databases?

regards
 
Old 03-09-2010, 07:00 PM   #2
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 26,553

Rep: Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946
Quote:
Originally Posted by sinchan_ View Post
hi all

I have a system with opensuse 11.0 and mysql

After changing the administrator password only information_schema and test databases are shown in GUI tools (webmin or mysql administrator GUI tool). After the error I restored the password to the old used

if I use mysql in terminal, and use show databases; I can see the 7 databases that I have.

I aslo cannot access to any field using GUI tools (cannot acces to database permissions, or MySQL Server Configuration, host permissions or MySQL system variables). The error is:

DBI connect failed : Access denied for user ''@'localhost' to database 'mysql'

Do you know how to restore the view/access to databases?

regards
It looks like you changed the password/user, but the tool didn't save the new one.

Your databases are fine, since you can see them through the terminal. Best thing would be to go into a terminal, and set up a user. The message indicates the user name is not being passed (the ''@'localhost'). So set up a new user and use it, or check the MySQL docs on the "grant all" command.
 
  


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
Repository for mysql-gui-tools satimis Ubuntu 2 10-26-2007 02:29 AM
Mysql-gui-tools-5.0r9 compile bgeddy Slackware 7 02-05-2007 12:46 PM
Slackware 11 with mysql-gui-tools-5.or8 bgeddy Slackware 3 01-27-2007 07:16 AM
MySQL GUI tools fail, segmentation fault tisource Linux - Software 1 10-02-2006 11:28 AM
mysql and gui tools pre-installed? jdh23 Linux - Software 3 09-10-2006 11:43 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 09:38 PM.

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
Open Source Consulting | Domain Registration