SunQuest
           PHP Installation
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Codewalkers ForumsPHP RelatedPHP Installation

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Codewalkers Forums Sponsor:
You eat, breathe and sleep innovation. Build your mobile intelligence with BlackBerry® experts this July. Register Today!
  #1  
Old April 1st, 2005, 07:16 AM
Nathaniel Nathaniel is offline
Codewalkers Newbie (0 - 499 posts)
 
Join Date: Apr 2007
Posts: 96 Nathaniel User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 2
PHPmyadmin

Hello, i am having trouble with phpmyadmin. I seem to have all the stuff correct, but when i try to log in, i use the proper info and it does not allow me to log in with the account/pass ... there is no .htaccess file and just wondering how to fix it!

Reply With Quote
  #2  
Old April 1st, 2005, 01:21 PM
Matt Matt is offline
Moderator
Codewalkers Specialist (4000 - 4499 posts)
 
Join Date: Apr 2007
Location: Florida
Posts: 4,158 Matt User rank is Private First Class (20 - 50 Reputation Level)Matt User rank is Private First Class (20 - 50 Reputation Level) 
Time spent in forums: 4 h 10 m 20 sec
Reputation Power: 6
RE: PHPmyadmin

What authentication method are you using? (you would have chosen this in the config file).

What login information are you using? Where did you get it?

Reply With Quote
  #3  
Old April 1st, 2005, 03:48 PM
Anonymous Anonymous is offline
Registered User
Codewalkers God 35th Plane (22000 - 22499 posts)
 
Join Date: Apr 2007
Posts: 22,309 Anonymous User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 24
RE: PHPmyadmin

I am using http and the login information from mysql

Reply With Quote
  #4  
Old April 1st, 2005, 03:49 PM
Nathaniel Nathaniel is offline
Codewalkers Newbie (0 - 499 posts)
 
Join Date: Apr 2007
Posts: 96 Nathaniel User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 2
RE: PHPmyadmin

that was me, forgot i wasn't logged in

Reply With Quote
  #5  
Old April 1st, 2005, 04:41 PM
Nathaniel Nathaniel is offline
Codewalkers Newbie (0 - 499 posts)
 
Join Date: Apr 2007
Posts: 96 Nathaniel User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 2
RE: PHPmyadmin

my mysql is in C:mysql and the phpmyadmin is in citamiwebpagesphpmyadmin

i don't know if this has anything to do with it.. but it might

Reply With Quote
  #6  
Old April 1st, 2005, 05:23 PM
Matt Matt is offline
Moderator
Codewalkers Specialist (4000 - 4499 posts)
 
Join Date: Apr 2007
Location: Florida
Posts: 4,158 Matt User rank is Private First Class (20 - 50 Reputation Level)Matt User rank is Private First Class (20 - 50 Reputation Level) 
Time spent in forums: 4 h 10 m 20 sec
Reputation Power: 6
RE: PHPmyadmin

Can you log onto mysql via the command line utility using this same information?

Reply With Quote
  #7  
Old April 1st, 2005, 05:53 PM
Nathaniel Nathaniel is offline
Codewalkers Newbie (0 - 499 posts)
 
Join Date: Apr 2007
Posts: 96 Nathaniel User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 2
RE: PHPmyadmin

I'm not that great at mysql.. what is the command to do that?

Reply With Quote
  #8  
Old April 1st, 2005, 06:13 PM
Matt Matt is offline
Moderator
Codewalkers Specialist (4000 - 4499 posts)
 
Join Date: Apr 2007
Location: Florida
Posts: 4,158 Matt User rank is Private First Class (20 - 50 Reputation Level)Matt User rank is Private First Class (20 - 50 Reputation Level) 
Time spent in forums: 4 h 10 m 20 sec
Reputation Power: 6
RE: PHPmyadmin

You would go to the mysql directory and from there in the bin directory there is an executable called mysql

do a :

mysql -u<username> -p

and then it will prompt for password

Reply With Quote
  #9  
Old April 1st, 2005, 06:24 PM
Nathaniel Nathaniel is offline
Codewalkers Newbie (0 - 499 posts)
 
Join Date: Apr 2007
Posts: 96 Nathaniel User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 2
RE: PHPmyadmin

well, i am doing that and nothing happens.. is it like

mysql> -u admin -p
--> pass

?

Reply With Quote
  #10  
Old April 1st, 2005, 06:40 PM
Matt Matt is offline
Moderator
Codewalkers Specialist (4000 - 4499 posts)
 
Join Date: Apr 2007
Location: Florida
Posts: 4,158 Matt User rank is Private First Class (20 - 50 Reputation Level)Matt User rank is Private First Class (20 - 50 Reputation Level) 
Time spent in forums: 4 h 10 m 20 sec
Reputation Power: 6
RE: PHPmyadmin

If you have a

mysql>

prompt, then you are already in the utility. What user name and password did you use to get in it?


Reply With Quote
  #11  
Old April 1st, 2005, 06:48 PM
Nathaniel Nathaniel is offline
Codewalkers Newbie (0 - 499 posts)
 
Join Date: Apr 2007
Posts: 96 Nathaniel User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 2
RE: PHPmyadmin

well i put the stuff i put for the pass on root and it said it was wrong...

Reply With Quote
  #12  
Old April 1st, 2005, 06:50 PM
Nathaniel Nathaniel is offline
Codewalkers Newbie (0 - 499 posts)
 
Join Date: Apr 2007
Posts: 96 Nathaniel User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 2
RE: PHPmyadmin

[WinMySQLadmin]
Server=C:/mysql/bin/mysqld.exe
user=root
password=mypass


i am using the: root and mypass from that

Reply With Quote
  #13  
Old April 1st, 2005, 06:51 PM
Nathaniel Nathaniel is offline
Codewalkers Newbie (0 - 499 posts)
 
Join Date: Apr 2007
Posts: 96 Nathaniel User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 2
RE: PHPmyadmin

i forgot i had the <> so the root and mypass work, but in the phpmyadmin it stil ldoes not

Reply With Quote
  #14  
Old April 1st, 2005, 06:55 PM
Nathaniel Nathaniel is offline
Codewalkers Newbie (0 - 499 posts)
 
Join Date: Apr 2007
Posts: 96 Nathaniel User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 2
RE: PHPmyadmin

Incase this might help:

php Code:
Original - php Code
  1.  
  2. $i++;
  3. $cfg['Servers'][$i]['host']          = 'localhost'; // MySQL hostname or IP address
  4. $cfg['Servers'][$i]['port']          = '3306';          // MySQL port - leave blank for default port
  5. $cfg['Servers'][$i]['socket']        = '';          // Path to the socket - leave blank for default socket
  6. $cfg['Servers'][$i]['connect_type']  = 'tcp';       // How to connect to MySQL server ('tcp' or 'socket')
  7. $cfg['Servers'][$i]['extension']     = 'mysql';     // The php MySQL extension to use ('mysql' or 'mysqli')
  8. $cfg['Servers'][$i]['compress']      = FALSE;       // Use compressed protocol for the MySQL connection
  9.                                                     // (requires PHP >= 4.3.0)
  10. $cfg['Servers'][$i]['controluser']   = 'root';          // MySQL control user settings
  11.                                                     // (this user must have read-only
  12. $cfg['Servers'][$i]['controlpass']   = 'mypass';          // access to the "mysql/user"
  13.                                                     // and "mysql/db" tables).
  14.                                                     // The controluser is also
  15.                                                     // used for all relational
  16.                                                     // features (pmadb)
  17. $cfg['Servers'][$i]['auth_type']     = 'http';    // Authentication method (config, http or cookie based)?
  18. $cfg['Servers'][$i]['user']          = 'root';      // MySQL user
  19. $cfg['Servers'][$i]['password']      = 'mypass';          // MySQL password (only needed
  20.                                                     // with 'config' auth_type)
  21. $cfg['Servers'][$i]['only_db']       = 'nathaniel';          // If set to a db-name, only
  22.                                                     // this db is displayed in left frame
  23.                                                     // It may also be an array of db-names, where sorting order is relevant.
  24.  

Reply With Quote
  #15  
Old April 1st, 2005, 06:57 PM
Matt Matt is offline
Moderator
Codewalkers Specialist (4000 - 4499 posts)
 
Join Date: Apr 2007
Location: Florida
Posts: 4,158 Matt User rank is Private First Class (20 - 50 Reputation Level)Matt User rank is Private First Class (20 - 50 Reputation Level) 
Time spent in forums: 4 h 10 m 20 sec
Reputation Power: 6
RE: PHPmyadmin

the same username and password (root and mypass) work from the command line, but not phpmyadmin?

are you 100% all the settings in the config file are ok? double check them.

Reply With Quote