Linux Database error!

[Believer]

I am getting this error when trying to import .sql file to database at phpmyadmin.. Whats wrong?:O

I am typing this command: mysql -u root -p server < /home/localhost.sql

ERROR 1044 (42000) at line 22: Access denied for user 'root'@'localhost' to database 'information_schema'

Please help, rep++!!

 

[Ninja]

Could you paste your lighttpd.conf in phpmyadmin folder?

 

[Believer]

Could you paste your lighttpd.conf in phpmyadmin folder?

Where is that?

EDIT: my phpadmin is not in www folder..

 

[Ninja]

I assume that you've got a dedicated server so I would say in etc/phpmyadmin/lighttpd.conf

 

[Believer]

# Alias for phpMyAdmin directory
alias.url += ( 
	"/phpmyadmin" => "/usr/share/phpmyadmin",
)

# Disallow access to libraries
$HTTP["url"] =~ "^/phpmyadmin/libraries" { 
    url.access-deny = ( "" ) 
}
$HTTP["url"] =~ "^/phpmyadmin/setup/lib" { 
    url.access-deny = ( "" ) 
}

# Limit access to setup script
$HTTP["url"] =~ "^/phpmyadmin/setup" {
	auth.backend = "htpasswd"
	auth.backend.htpasswd.userfile = "/etc/phpmyadmin/htpasswd.setup"
	auth.require = (
		"/" => (
			"method" => "basic",
			"realm" => "phpMyAdmin Setup",
			"require" => "valid-user"
		)
	)
}

 

[Ninja]

Remove

# Alias for phpMyAdmin directory 
alias.url += (      
         "/phpmyadmin" => "/usr/share/phpmyadmin", 
)

Add this at the end to your lighttpd.conf in /etc/lighttpd

alias.url = ( "/phpmyadmin" => "/usr/share/phpmyadmin/")

EDIT: You might need to add fastcgi.server under server modules aswell.

fastcgi.server = ( ".php" => ((
                     "bin-path" => "/usr/bin/php-cgi",
                     "socket" => "/tmp/php.socket",
                     "max-procs" => 2,
                     "bin-environment" => (
                       "PHP_FCGI_CHILDREN" => "16",
                       "PHP_FCGI_MAX_REQUESTS" => "10000"
                     ),
                     "bin-copy-environment" => (
                       "PATH", "SHELL", "USER"
                     ),
                     "broken-scriptfilename" => "enable"
                 )))

 

[Believer]

Still not working lol

 

[Believer]

I've been searching whole google for this.. nothing helps-.-

 

[Believer]

new problem

 

[Believer]

now I am getting this error when trying to import .sql file to database at phpmyadmin.. Whats wrong?:O

I am typing this command: mysql -u root -p server < /home/localhost.sql

ERROR 1044 (42000) at line 22: Access denied for user 'root'@'localhost' to database 'information_schema'

Please help, rep++!!