jayman2 Posted February 27, 2009 Share Posted February 27, 2009 Hi, I've got php and mysql setup and running fine on my pc. I'm running windows xp. I've installed a few php apps, that don't require mysql on localhost. They run great. But I cannot get into phpmyadmin. At first I was getting errors, but I tweaked my system to where I don't get anymore errors. When I bring up h**p://localhost/phpmyadmin and enter my login, root with no passward, I get a box on top that says "x access denied". If I try with no password, the screen just sits there and the progress bars at the bottom of my browser just slowly go about half way across. In my config.inc.php I have user set as root with no password. I've tried root root and I've tried without any username or password and neither work. I've been googling this, but I can't find the soulution. Any suggestions? Thanks in advance. Quote Link to comment https://forums.phpfreaks.com/topic/147155-phpmyadmin-wont-connect-to-mysql/ Share on other sites More sharing options...
rhodesa Posted February 27, 2009 Share Posted February 27, 2009 Try using this for a config.inc.php: <?php $cfg['Servers'][1]['host'] = 'localhost'; $cfg['Servers'][1]['extension'] = 'mysql'; $cfg['Servers'][1]['connect_type'] = 'tcp'; $cfg['Servers'][1]['compress'] = false; $cfg['Servers'][1]['auth_type'] = 'http'; ?> Quote Link to comment https://forums.phpfreaks.com/topic/147155-phpmyadmin-wont-connect-to-mysql/#findComment-772495 Share on other sites More sharing options...
jayman2 Posted February 27, 2009 Author Share Posted February 27, 2009 Thanks for your reply. I put that info in my config.inc.php and tried again. The first time a windows login box popped up, saying a username and password was required. I clicked on ok and the webpage came up with the "! Internet Explorer cannot display the webpage" message. Now everytime I go to h**p://localhost/phpmyadmin and try to login, that page displays. Quote Link to comment https://forums.phpfreaks.com/topic/147155-phpmyadmin-wont-connect-to-mysql/#findComment-772507 Share on other sites More sharing options...
rhodesa Posted February 27, 2009 Share Posted February 27, 2009 do you know your root username and password for mysql? you need that to login Quote Link to comment https://forums.phpfreaks.com/topic/147155-phpmyadmin-wont-connect-to-mysql/#findComment-772515 Share on other sites More sharing options...
jayman2 Posted February 27, 2009 Author Share Posted February 27, 2009 I installed mysql, unistalled and then reinstalled it. I don't remember what I used the last time. Is there a way I can check? Quote Link to comment https://forums.phpfreaks.com/topic/147155-phpmyadmin-wont-connect-to-mysql/#findComment-772517 Share on other sites More sharing options...
rhodesa Posted February 27, 2009 Share Posted February 27, 2009 http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html#resetting-permissions-windows Quote Link to comment https://forums.phpfreaks.com/topic/147155-phpmyadmin-wont-connect-to-mysql/#findComment-772526 Share on other sites More sharing options...
jayman2 Posted February 27, 2009 Author Share Posted February 27, 2009 http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html#resetting-permissions-windows I tried that and still the same thing. Quote Link to comment https://forums.phpfreaks.com/topic/147155-phpmyadmin-wont-connect-to-mysql/#findComment-772578 Share on other sites More sharing options...
rhodesa Posted February 27, 2009 Share Posted February 27, 2009 so, can you connect to mysql server via the command line as root? mysql -u root -p Quote Link to comment https://forums.phpfreaks.com/topic/147155-phpmyadmin-wont-connect-to-mysql/#findComment-772587 Share on other sites More sharing options...
jayman2 Posted February 27, 2009 Author Share Posted February 27, 2009 so, can you connect to mysql server via the command line as root? mysql -u root -p I can get to the mysql> prompt, but when I entered that command I got a password prompt. I entered root and got an error. Now this is how my cmd window looks. mysql> -> -> whatever I enter, I just get another one of those prompts. If I type help, I get a list of commands. I had tried that mysql-init.txt, thru windows, following that tutorial link above. Quote Link to comment https://forums.phpfreaks.com/topic/147155-phpmyadmin-wont-connect-to-mysql/#findComment-772603 Share on other sites More sharing options...
rhodesa Posted February 27, 2009 Share Posted February 27, 2009 if you get the mysql prompt, then you have connected to the mysql server (fyi, typing 'quit' there next time will exit the prompt) open a new browser window, go to phpmyadmin again, and use the same username/password in the prompt that comes up Quote Link to comment https://forums.phpfreaks.com/topic/147155-phpmyadmin-wont-connect-to-mysql/#findComment-772615 Share on other sites More sharing options...
jayman2 Posted February 27, 2009 Author Share Posted February 27, 2009 No good. I'm back to the "! access denied" again. Quote Link to comment https://forums.phpfreaks.com/topic/147155-phpmyadmin-wont-connect-to-mysql/#findComment-772635 Share on other sites More sharing options...
rhodesa Posted February 27, 2009 Share Posted February 27, 2009 Not sure what else to say. There is nothing more complicated then that. Quote Link to comment https://forums.phpfreaks.com/topic/147155-phpmyadmin-wont-connect-to-mysql/#findComment-772645 Share on other sites More sharing options...
jayman2 Posted February 27, 2009 Author Share Posted February 27, 2009 Thanks for your help. I'm going to keep on trying and searching for more info. Maybe I'll uninstall everything and try and start from scratch. Quote Link to comment https://forums.phpfreaks.com/topic/147155-phpmyadmin-wont-connect-to-mysql/#findComment-772650 Share on other sites More sharing options...
jayman2 Posted February 28, 2009 Author Share Posted February 28, 2009 Thanks for your help. I'm going to keep on trying and searching for more info. Maybe I'll uninstall everything and try and start from scratch. I found a great, FREE application. It's called HeidiSQL. In my opinion, it's much better than phpmyadmin. After you install it, you just enter your password to connect to mysql and everything you could ever want is right there. You can create/delete databases/create users/drop tables/import & export/backup & restore/generate reports and more. As soon as I connected to mysql, all of the databases that I had created from the command prompt were right there. I'll never use phpmyadmin again, except on my web provider's site. Here's the link: hxxp://www.heidisql.com/ Just scroll down to the bottom app. This should help anyone having a problem using phpmyadmin. As a result of my googling, I know there are a lot of those people out there. I forgot to mention. I've got smf 1.1.8 installed and running on my local windows machine. Quote Link to comment https://forums.phpfreaks.com/topic/147155-phpmyadmin-wont-connect-to-mysql/#findComment-773420 Share on other sites More sharing options...
rhodesa Posted March 2, 2009 Share Posted March 2, 2009 whatever floats your boat i guess thanks for info and glad you found something that works for you Quote Link to comment https://forums.phpfreaks.com/topic/147155-phpmyadmin-wont-connect-to-mysql/#findComment-774730 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.