LinuxQuestions.org
Visit the LQ Articles and Editorials section
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 02-26-2012, 11:21 PM   #1
roboticist
LQ Newbie
 
Registered: Jan 2011
Posts: 4

Rep: Reputation: 0
MySQL-phpmyadmin help: "access denied for user root"


Fresh Debian install with Apache, MySQL, PhP, Perl and Python.

I can get into MySql manually, but anytime I try to import a database I get and error 1044 saying "Access denied for user root @ localhost" for information_schema.

I looked trough numerous posts and arguments on numerous boards, but I'm not finding a solution.

The thing is, I don't understand what causes this. I don't ever recall having it before, or I might have some memory of how to fix it.

The other problem is that I don't even have clue as to how to troubleshoot this. Can anyone point me to a troubleshooting tree or condition table that will allow me to track this error down? It must come from somewhere!

I am able to add databases, both through the mysql cli and phpmyadmin. I can apparently add tables and data to these databases, both ways.

However, I cannot seem to restore a database that was stored in a .sql file.

If we can get a list of verification steps or a troubleshooting tree or a decision table, I will post it somewhere where we will all be able to get to it.

Mike
 
Old 02-26-2012, 11:53 PM   #2
roboticist
LQ Newbie
 
Registered: Jan 2011
Posts: 4

Original Poster
Rep: Reputation: 0
More info

I'm sure to be asked if I actually set the password, granted the privileges, etc., etc... The answer is yes, I'm pretty sure I did all that. The interesting thing is that phpmyadmin shows that I have full privileges on the information_schema database.

So, one question worth answering is, "Why does having no access to the information_schema database prevent me from importing the database?

The import file is named, localhost.sql and the tech exported it from phpmyadmin on the original webhosting system.
I built a new (local) server so we could have root access and develop new goodies for the website. I have just verified again that I can add databases, create tables and add data to the tables manually.

I just created a small test website and can load data from a login screen and a data screen, BUT, I can't export that data and reload it from a .sql file.

Thank you for your help.
 
Old 02-27-2012, 08:54 AM   #3
Satyaveer Arya
Senior Member
 
Registered: May 2010
Location: Dehradun, Uttarakhand, India
Distribution: RHEL, CentOS, Debian, Oracle Solaris 10
Posts: 1,413

Rep: Reputation: 303Reputation: 303Reputation: 303Reputation: 303
Did you create EVENT in INFORMATION_SCHEMA?
 
Old 02-27-2012, 09:01 AM   #4
Satyaveer Arya
Senior Member
 
Registered: May 2010
Location: Dehradun, Uttarakhand, India
Distribution: RHEL, CentOS, Debian, Oracle Solaris 10
Posts: 1,413

Rep: Reputation: 303Reputation: 303Reputation: 303Reputation: 303
But what I found in some other forums, it seems to be a bug.
 
  


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 - phpmyadmin: Access denied for user 'test'@'localhost' kirby1111 Linux - Server 1 03-18-2011 10:09 PM
phpmyadmin shows blank page; no "phpmyadmin" database in mysql qajaq Linux - Software 2 12-20-2009 01:23 PM
"Access denied" in MySQL server seprob Linux - Server 3 10-27-2008 01:17 PM
squid "access.log" access denied no user name jatender Linux - Server 1 10-02-2007 05:28 AM
why I got "Access denied for user: 'root@localhost'" likedreamer Red Hat 1 11-09-2003 06:06 AM


All times are GMT -5. The time now is 12:30 PM.

Main Menu
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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration