To register for an Internet.com membership to receive newsletters and white papers, use the Register button ABOVE.
To participate in the message forums BELOW, click here


EIT Planet's Security News
 Security Vulnerabilities Prove Increasingly Costly
 IPS Market Approaches $1 Billion
 U.S. Named Top Spammer

Security Products
 Family Keylogger (Family Keylogger)
 modusGate (Vircom Inc.)
 Kernel Hotmail MSN Password Recovery (Nucleus Data Recovery)
 Outlook 2003 PST Password Recovery (PST Password Recovery)
 PST Password Remove (PST Password Remove)
 Zemana Anti Keylogger (Vickit, Inc.)


Go Back   Antionline Forums - Maximum Security for a Connected World > General Technology Forums > Web Development

Web Development Talk about technologies used to develop cool websites like AntiOnline.

Reply
 
Thread Tools Display Modes
Old February 21st, 2010, 03:43 PM   #1
Walt49
Junior Member
 
Join Date: May 2003
Posts: 2
Walt49 is on a distinguished road
Exclamation phpmyadmin connection to mysql problem

I have Windows 7 box with PHP 5.3.1, MySQL 5.1 and Apache 2.2.14 installed. Everything is working smoothly, except phpmyadmin connection is rejected by MySQL. I tried all
possible ways with the same negative result. Phpmyadmin config.inc.php file has exactly
the same user name and password like MySQL, but MySQL rejects them. I tested MySQL
from a command line with -u root -p johndoe , it works fine. I created a new database with new user name and password. Tested it. From command line its OK, but
same user and password from phpmyadmin was again rejected by MySQL. Thanks in advance.
Walt49 is offline   Reply With Quote
Old February 22nd, 2010, 09:03 PM   #2
westin
Gonzo District BOFH
 
westin's Avatar
 
Join Date: Jan 2006
Location: SW MO
Posts: 888
westin has a reputation beyond reputewestin has a reputation beyond reputewestin has a reputation beyond reputewestin has a reputation beyond reputewestin has a reputation beyond reputewestin has a reputation beyond reputewestin has a reputation beyond reputewestin has a reputation beyond reputewestin has a reputation beyond reputewestin has a reputation beyond reputewestin has a reputation beyond repute
Not sure if it will help, and is kind of dated, but you might give this thread a read:

http://lists.mysql.com/mysql/163034

Quote:
In that
case, root@localhost has a password, so you must supply it to connect as
root@localhost using phpmyadmin. First, make sure that the correct password
is set in config.inc.php. If the password is set correctly, phpmyadmin
should connect to mysql. If it fails, and mysql says "Using password: NO",
it means mysql didn't receive a password, but if mysql says "Using password: YES", it means mysql received the password but didn't recognize it.
Welcome to AO!
__________________
\"Those of us that had been up all night were in no mood for coffee and donuts, we wanted strong drink.\"

-HST
westin is offline   Reply With Quote
Old February 22nd, 2010, 11:06 PM   #3
Walt49
Junior Member
 
Join Date: May 2003
Posts: 2
Walt49 is on a distinguished road
phpmyadmin connection problem

Thanks for the response.
This is the result of my last attempt to connect from phpmyadmin:
--------------------------------------------------------------------------------------

Error
MySQL said:

Cannot connect: invalid settings.

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.
--------------------------------------------------------------------------------------- config.inc.php
/* User for advanced features */
// $cfg['Servers'][$i]['controluser'] = 'root';
// $cfg['Servers'][$i]['controlpass'] = 'johndoe';
---------------------------------------------------------------------------------------
And this is my attempt to connect from the command line:

C:\>mysql -u root -p
Enter password: *******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 5.0.90-community-nt MySQL Community Edition (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>
--------------------------------------------------------------------------------------
I can't figure out where is the problem ? Thanks.
Walt49 is offline   Reply With Quote
Old March 1st, 2010, 01:20 PM   #4
TG2
Junior Member
 
Join Date: Jul 2009
Posts: 16
TG2 is just really niceTG2 is just really niceTG2 is just really niceTG2 is just really nice
what are your host, connection type and auth type set to in config.inc.php?
TG2 is offline   Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Linux connection problem aura2 General Computer Discussions 7 December 21st, 2005 08:37 AM
Problem with internet connection fl34bit3 *nix Security Discussions 6 October 21st, 2003 12:04 AM
MySQL problem phaza7 Oops! A Bug! 0 April 30th, 2003 02:21 AM
Strange UDP(137) connection attempts KissCool Newbie Security Questions 10 December 23rd, 2002 09:29 PM
The Hayes Modem Command Set magickal1 Other Tutorials Forum 0 November 17th, 2002 12:11 PM


All times are GMT +1. The time now is 11:49 AM.












Acceptable Use Policy

Internet.com
The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.