Jump to content

My phpMyAdmin Questions

coollinux

By coollinux
in PHP

 Share

Recommended Posts

coollinux Newbie

coollinux

Posted
Posted

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
coollinux Newbie

coollinux

Posted
  • Author
Posted
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
Jack McKalling Dedicated Member

Jack McKalling

Posted
Posted

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
coollinux Newbie

coollinux

Posted
  • Author
Posted
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
Jack McKalling Dedicated Member

Jack McKalling

Posted
Posted
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
reportingsjr Dedicated Member

reportingsjr

Posted
Posted

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
justsomeguy w3schools Guru

justsomeguy

Posted
Posted
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
coollinux Newbie

coollinux

Posted
  • Author
Posted
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
coollinux Newbie

coollinux

Posted
  • Author
Posted
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
reportingsjr Dedicated Member

reportingsjr

Posted
Posted

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
coollinux Newbie

coollinux

Posted
  • Author
Posted
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
justsomeguy w3schools Guru

justsomeguy

Posted
Posted

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
Go to topic listing
×
×
  • Create New...