Jump to content

My phpMyAdmin Questions


coollinux
 Share

Recommended Posts

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

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
hi, 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

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

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

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

I have already installed the latest versions of Apache, PHP, Peril, MySQL and phpMyAdmin
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.
Link to comment
Share on other sites

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

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

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

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

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...