Kai Posted May 4, 2003 Share Posted May 4, 2003 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? Quote Link to comment https://forums.phpfreaks.com/topic/429-access-denied-for-user/ Share on other sites More sharing options...
shivabharat Posted May 5, 2003 Share Posted May 5, 2003 Does the login u used have all the rights? try to login using the super user login. Quote Link to comment https://forums.phpfreaks.com/topic/429-access-denied-for-user/#findComment-1463 Share on other sites More sharing options...
Kai Posted May 5, 2003 Author Share Posted May 5, 2003 Yup, that it is the super. I haven\'t changed anything. Quote Link to comment https://forums.phpfreaks.com/topic/429-access-denied-for-user/#findComment-1464 Share on other sites More sharing options...
phpfreak Posted May 5, 2003 Share Posted May 5, 2003 If you haven\'t changed anything from the default installation, use the username: root and no password. Good luck! Quote Link to comment https://forums.phpfreaks.com/topic/429-access-denied-for-user/#findComment-1467 Share on other sites More sharing options...
Kai Posted May 5, 2003 Author Share Posted May 5, 2003 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. Quote Link to comment https://forums.phpfreaks.com/topic/429-access-denied-for-user/#findComment-1468 Share on other sites More sharing options...
shivabharat Posted May 5, 2003 Share Posted May 5, 2003 Try to change the authentictaion mode in the config.inc.php read documentation for more details phpMyAdmin/Documentation.html#config Quote Link to comment https://forums.phpfreaks.com/topic/429-access-denied-for-user/#findComment-1469 Share on other sites More sharing options...
phpfreak Posted May 5, 2003 Share Posted May 5, 2003 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. Quote Link to comment https://forums.phpfreaks.com/topic/429-access-denied-for-user/#findComment-1470 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.