sasori Posted February 7, 2010 Share Posted February 7, 2010 I don't have any idea is going on sir(s) please help me, am having trouble importing my database dump here's the first screen shot here's the second one, as you can see, all the priveleges are set Quote Link to comment https://forums.phpfreaks.com/topic/191229-access-denied-for-root-localhost-help/ Share on other sites More sharing options...
Mchl Posted February 7, 2010 Share Posted February 7, 2010 CHeck if you're using correct password. Quote Link to comment https://forums.phpfreaks.com/topic/191229-access-denied-for-root-localhost-help/#findComment-1008294 Share on other sites More sharing options...
sasori Posted February 7, 2010 Author Share Posted February 7, 2010 CHeck if you're using correct password. yes sir, am using the correct password. i even changed it twice, after receiving a reply notification from you Quote Link to comment https://forums.phpfreaks.com/topic/191229-access-denied-for-root-localhost-help/#findComment-1008295 Share on other sites More sharing options...
Mchl Posted February 7, 2010 Share Posted February 7, 2010 Where exactly are you getting this error message? Is from PHP code, or some application? And don't call me 'sir', I'm not your sergeant Quote Link to comment https://forums.phpfreaks.com/topic/191229-access-denied-for-root-localhost-help/#findComment-1008297 Share on other sites More sharing options...
sasori Posted February 7, 2010 Author Share Posted February 7, 2010 Where exactly are you getting this error message? Is from PHP code, or some application? And don't call me 'sir', I'm not your sergeant I am getting this error after importing my db dump from, tables are being imported but then an error appears that root@localhost is accessed denied on information_schema when all of the privileges for my root account is all set..this is weird Quote Link to comment https://forums.phpfreaks.com/topic/191229-access-denied-for-root-localhost-help/#findComment-1008299 Share on other sites More sharing options...
Mchl Posted February 7, 2010 Share Posted February 7, 2010 How are you importing this database dump? Quote Link to comment https://forums.phpfreaks.com/topic/191229-access-denied-for-root-localhost-help/#findComment-1008306 Share on other sites More sharing options...
sasori Posted February 7, 2010 Author Share Posted February 7, 2010 How are you importing this database dump? - click "import" tab from the top navigation menu - click browse button and load the dbsqldump.sql file - click go an then all tables gets loaded, and boom,, root@localhost is accessed denied on information_schema Quote Link to comment https://forums.phpfreaks.com/topic/191229-access-denied-for-root-localhost-help/#findComment-1008308 Share on other sites More sharing options...
Mchl Posted February 7, 2010 Share Posted February 7, 2010 Is this dump trying to insert anything into information_schema database? This database is read-only. http://dev.mysql.com/doc/refman/5.0/en/information-schema.html Quote Link to comment https://forums.phpfreaks.com/topic/191229-access-denied-for-root-localhost-help/#findComment-1008315 Share on other sites More sharing options...
sasori Posted February 7, 2010 Author Share Posted February 7, 2010 daemn..ok sir, thanks for the info..i'll just try to re-export the dbdump from the source ..thanks. Quote Link to comment https://forums.phpfreaks.com/topic/191229-access-denied-for-root-localhost-help/#findComment-1008316 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.