Jump to content

Archived

This topic is now archived and is closed to further replies.

Kai

Access denied for user

Recommended Posts

My database which was working perfectly yesterday now won\'t let me \"Insert data from a textfile into table\" on the SQL tab in phpMyAdmin. I get the following error:

 

MySQL said: 



Access denied for user: \'myusername@localhost\' (Using password: YES)

 

Do you think this is a transient problem since it was working yesterday?

Share this post


Link to post
Share on other sites

Does the login u used have all the rights? try to login using the super user login.

Share this post


Link to post
Share on other sites

Yup, that it is the super. I haven\'t changed anything.

Share this post


Link to post
Share on other sites

If you haven\'t changed anything from the default installation, use the username: root and no password.

 

Good luck!

Share this post


Link to post
Share on other sites

Thanks :-) The thing is it doesn\'t ask me for my username or pwd at any point. I log into cPanel with my normal site username and pwd, go to phpmyadmin, click on the database I want and the table I want, all as usual. I click on SQL and \"Insert data into table from text file\" and pop the same options in I normally do. Then I click insert and I get that error.

 

I\'m not really sure what\'s going on... I might try deleting my cookies to see if refreshing them helps...

 

Edit - nope didn\'t help.

Share this post


Link to post
Share on other sites

Try to change the authentictaion mode in the

 

config.inc.php

 

read documentation for more details

phpMyAdmin/Documentation.html#config

Share this post


Link to post
Share on other sites

If you are using CPanel, I would contact your web hosting provider and ask them what the username and password is. Chances are, it\'s the same as your login. It might be username@domain.name for the username and your CPanel password.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.