coollinux Posted August 29, 2006 Share Posted August 29, 2006 Hi all,I would like to seek for your help or advice on my phpMyAdmin problems.I have already installed the latest versions of Apache, PHP, Peril, MySQL and phpMyAdmin for creating my own blog site but I have a problem with phpMyAdmin:- When I typed "http://localhost/phpMyAdmin on my browser, I received the error message saying that MySQL said: #1045 - Access denied for user 'root@localhost'. Is there something wrong in my "C:\htdocs\phpMyAdmin\config.inc.php"? The codes in "config.inc.php" are:<?php$cfg['PmaAbsoluteUri'] = 'http://localhost/phpMyAdmin/';$cfg['Servers'][$i]['extension'] = 'mysqli';$cfg['Servers'][$i]['auth_type'] = 'http';?>Hope to hear from you soon. Thank you very much. Link to comment Share on other sites More sharing options...
lordfa9 Posted August 29, 2006 Share Posted August 29, 2006 double check the calues in the top 2 $cfg lines, i think its not correct.a friend say that the address should be http://localhost, not sure bout it thoughdid you make any changes to config.inc.php? The root pw should be blank Link to comment Share on other sites More sharing options...
coollinux Posted August 29, 2006 Author Share Posted August 29, 2006 double check the calues in the top 2 $cfg lines, i think its not correct.a friend say that the address should be http://localhost, not sure bout it thoughdid you make any changes to config.inc.php? The root pw should be blankhi, can you please correct me for the top 2 $cfg lines? I opened "config.inc.php" file under phpMyAdmin folder and then entered the same codes that I mentioned earlier. Where can I find the root password to verify its status? thanks lot. Link to comment Share on other sites More sharing options...
Millar Posted August 29, 2006 Share Posted August 29, 2006 May I ask what version of phpMyAdmin are you using? Link to comment Share on other sites More sharing options...
Jack McKalling Posted August 29, 2006 Share Posted August 29, 2006 My I come in between and say that I think phpMyAdmin sucks? :)But that is my opinion, ignore me This is besides the point.I always create my own admin control panel, less danger in doing something wrong, and possibility to hanbd over permissions to your mods if you have. Link to comment Share on other sites More sharing options...
reportingsjr Posted August 29, 2006 Share Posted August 29, 2006 phpMyAdmin isnt actually all too bad, but I guess you could go with making your own MySQL center.. Its sounds like your username. are you sure its root? Link to comment Share on other sites More sharing options...
coollinux Posted August 29, 2006 Author Share Posted August 29, 2006 May I ask what version of phpMyAdmin are you using?phpAdmin version I installed earlier is 2.8.2.4.phpMyAdmin isnt actually all too bad, but I guess you could go with making your own MySQL center.. Its sounds like your username. are you sure its root?well, it is my first time to do the programming. What is the actual user for root@localhost? I think that I need to source out more on this so please enlighten me. Thank you.My I come in between and say that I think phpMyAdmin sucks? :)But that is my opinion, ignore me This is besides the point.I always create my own admin control panel, less danger in doing something wrong, and possibility to hanbd over permissions to your mods if you have.It's ok as long as I learn new things from here. So what is the programming software for creating your own admin control panel? Link to comment Share on other sites More sharing options...
Jack McKalling Posted August 29, 2006 Share Posted August 29, 2006 It's ok as long as I learn new things from here. So what is the programming software for creating your own admin control panel?You should go for PHP there But you may also choose ASP.NET, that is up to you. I prefer PHP, but who am I :)A server-side language (php) can print your forms, and process your actions at the same file (if you want). Almost anything you can think of, is possible with php Read the tutorial at the site, and try it out. Your host must have php support installed to use it though. Link to comment Share on other sites More sharing options...
reportingsjr Posted August 29, 2006 Share Posted August 29, 2006 root would be the main default user for your mysql, you can log into it and change it if you need, it should have been an option to change when you instaled mysql.. Link to comment Share on other sites More sharing options...
Millar Posted August 29, 2006 Share Posted August 29, 2006 When you installed MySQL, did you set a password for your root account, it asks if you want to set a password in the installation. Link to comment Share on other sites More sharing options...
coollinux Posted August 29, 2006 Author Share Posted August 29, 2006 When you installed MySQL, did you set a password for your root account, it asks if you want to set a password in the installation.Yes, I set my password for MySQL. Link to comment Share on other sites More sharing options...
justsomeguy Posted August 29, 2006 Share Posted August 29, 2006 I have already installed the latest versions of Apache, PHP, Peril, MySQL and phpMyAdminThe problem is obviously that you installed Peril! It creates a very perilous environment!You need to put your password for MySQL in the phpMyAdmin config file. Add these lines to the config file:$cfg['Servers'][$i]['controluser'] = 'root';$cfg['Servers'][$i]['controlpass'] = 'your password';Also, I think phpMyAdmin kicks ######! It's a great tool. Link to comment Share on other sites More sharing options...
Millar Posted August 29, 2006 Share Posted August 29, 2006 Yes, you needed a password or phpMyAdmin couldn't connect.Also I agree, phpMyAdmin is awesome and a great tool. Link to comment Share on other sites More sharing options...
Jack McKalling Posted August 29, 2006 Share Posted August 29, 2006 PhpMyAdmin is a great tool indeed, very advanced and thouroughly. But that makes me dislike it. funny Link to comment Share on other sites More sharing options...
justsomeguy Posted August 29, 2006 Share Posted August 29, 2006 I wonder if that is somehow related to why you prefer IE..Sorry, I can't resist taking punches at IE. It's too easy. Link to comment Share on other sites More sharing options...
coollinux Posted August 30, 2006 Author Share Posted August 30, 2006 The problem is obviously that you installed Peril! It creates a very perilous environment!You need to put your password for MySQL in the phpMyAdmin config file. Add these lines to the config file:$cfg['Servers'][$i]['controluser'] = 'root';$cfg['Servers'][$i]['controlpass'] = 'your password';Also, I think phpMyAdmin kicks ######! It's a great tool.Should I remove Peril? I did add these lines to config.inc.php but the results are still same; failed connection. I cannot wait to start my blog site. Link to comment Share on other sites More sharing options...
Little Goat Posted August 30, 2006 Share Posted August 30, 2006 Should I remove Peril?lol, he was just joking with you. Link to comment Share on other sites More sharing options...
coollinux Posted August 30, 2006 Author Share Posted August 30, 2006 lol, he was just joking with you. Oh man, I thought that he means it seriously! Thanks... Anyways, I finally accessed to phpMyAdmin by adding php codes in config.inc.php:<?php$i = 0;$i++;$cfg['PmaAbsoluteUri'] = 'http://localhost/phpMyAdmin/';$cfg['Servers'][$i]['extension'] = 'mysqli';$cfg['Servers'][$i]['auth_type'] = 'http';?> Link to comment Share on other sites More sharing options...
reportingsjr Posted August 30, 2006 Share Posted August 30, 2006 Do you have any idea what was wrong? Was it just that you were using mysql for the extension when it was really mysqli? (How exactly are those two different, ive never used mysqli, only mysql..) Link to comment Share on other sites More sharing options...
coollinux Posted August 30, 2006 Author Share Posted August 30, 2006 Do you have any idea what was wrong? Was it just that you were using mysql for the extension when it was really mysqli? (How exactly are those two different, ive never used mysqli, only mysql..)I forgot these codes totally till I got the answer from other forum. Since I plan for blog design, I decided to explore new things like this. I did add extension=php_mysqli.dll after extension=php_mysql.dll (removing the semicolon) in php.ini file of C:\php5 folder. This enables support for the MySQL-specific functions that will be used by my blog. Link to comment Share on other sites More sharing options...
justsomeguy Posted August 30, 2006 Share Posted August 30, 2006 The mysqli extension is for PHP5, and supports some new features of the newer MySQL server versions that the old mysql extension does not support. The i stands for "improved". Also, I think you misspelled "Perl" as "Peril", and of course "peril" means "danger", so that was the joke. In fact, it reminded me of Monty Python. Sir Lancelot: We were in the nick of time. You were in great peril. Sir Galahad: I don't think I was. Sir Lancelot: Yes, you were. You were in terrible peril. Sir Galahad: Look, let me go back in there and face the peril. Sir Lancelot: No, it's too perilous. Sir Galahad: Look, it's my duty as a knight to sample as much peril as I can. Sir Lancelot: No, we've got to find the Holy Grail. Come on. Sir Galahad: Oh, let me have just a little bit of peril? Sir Lancelot: No. It's unhealthy. Sir Galahad: I bet you're ghey. Sir Lancelot: Am not. Link to comment Share on other sites More sharing options...
Jack McKalling Posted August 30, 2006 Share Posted August 30, 2006 Whaha they're childish, lol "Am not." mwoahahaha Link to comment Share on other sites More sharing options...
coollinux Posted August 31, 2006 Author Share Posted August 31, 2006 Link to comment Share on other sites More sharing options...
reportingsjr Posted August 31, 2006 Share Posted August 31, 2006 lol cool.. I think you need to un-install Peril !Thats just too good.. Link to comment Share on other sites More sharing options...
coollinux Posted August 31, 2006 Author Share Posted August 31, 2006 lol cool.. I think you need to un-install Peril !Thats just too good.. i better keep my feet stand up from PERIL! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now