LinuxQuestions.org
Go Job Hunting at the LQ Job Marketplace
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
Search this Thread
Old 03-10-2005, 09:26 AM   #1
basq3
LQ Newbie
 
Registered: Mar 2005
Location: baton rouge
Distribution: fedora 3
Posts: 21

Rep: Reputation: 15
Unhappy phpmyadmin login issues


I recently switched over to linux fedora to put up a server. I got mysql running, but I've tried to get phpmyadmin to run and I get the login screen, but it does nothing no matter what name- just like if i had put nothing in the login box.

I checked and recheck the config files- what could cause such an issue?

fedora 3

MySQL-python-0.9.2-4
mysql-devel-3.23.58-14
mod_auth_mysql-20030510-5
libdbi-dbd-mysql-0.6.5-9
perl-DBD-MySQL-2.9003-5
qt-MySQL-3.3.3-8
php-mysql-4.3.10-3.2
mysql-3.23.58-14
mysql-server-3.23.58-14
mysql-bench-3.23.58-14

php-mysql-4.3.10-3.2
php-ldap-4.3.10-3.2

apache

without any special config- just genaric localhost as I dont have a domain name setup yet.

httpd works. no .htaccess file

Any help is appreciated
 
Old 03-10-2005, 10:12 AM   #2
ravikumarG
Member
 
Registered: Feb 2005
Location: India
Distribution: Fedora -2 ,Rhel3.0,CentOs 4.0-rc2
Posts: 60

Rep: Reputation: 15
"I get the login screen, but it does nothing no matter what name"

means is it denying your logins ? or after entering login info showing blank page ?

Is your Mysql server password contains any non alphabet chars like

$@* etc ?
 
Old 03-10-2005, 11:19 AM   #3
basq3
LQ Newbie
 
Registered: Mar 2005
Location: baton rouge
Distribution: fedora 3
Posts: 21

Original Poster
Rep: Reputation: 15
the login box stays after pressing ok- but clears both fields. if i press cancel i get the default not authorized. and no there arent any special charactors, the mysql part runs queries fine. im at a loss and new to configuring this software.
 
Old 03-10-2005, 01:07 PM   #4
basq3
LQ Newbie
 
Registered: Mar 2005
Location: baton rouge
Distribution: fedora 3
Posts: 21

Original Poster
Rep: Reputation: 15
if this issue is a major problem to fix timewise -let me know that as well. I need to get this server up and running with the db's and phpmyadmin or another front end for mysql if anyone has any suggestions or urls.
 
Old 03-10-2005, 04:30 PM   #5
Not now, John!
Member
 
Registered: Jul 2004
Distribution: LFS 5.1
Posts: 161

Rep: Reputation: 30
Look in your config.inc.php file. There shoul be:
Code:
$cfg['Servers'][$i]['auth_type']     = 'cookie';
 
Old 03-10-2005, 08:22 PM   #6
basq3
LQ Newbie
 
Registered: Mar 2005
Location: baton rouge
Distribution: fedora 3
Posts: 21

Original Poster
Rep: Reputation: 15
ok i set cookie in the config and set the blowfish phrase, but still the same problem.

when i cancel it says: the system couldnt verify whether or not you were authorized to view this page. this is due to a bad password or user credentials.

is there a way to check the access log to see? maybe i didnt set it up right. im using firefox if that helps.

how can i make sure the users are setup correctly in mysql and for the control user?
 
Old 03-11-2005, 01:16 AM   #7
TMH
Member
 
Registered: Nov 2004
Location: UK
Distribution: Gentoo
Posts: 61

Rep: Reputation: 15
By default the root password is blank.
 
Old 03-11-2005, 07:15 AM   #8
basq3
LQ Newbie
 
Registered: Mar 2005
Location: baton rouge
Distribution: fedora 3
Posts: 21

Original Poster
Rep: Reputation: 15
right -but ive already setup the mysql "root" user and password, the phpmyadmin control user using grants, and anonther user.

same result when trying to login- but at the command line they all are able to login. I know I've done something wrong. Is there a way to redo the users?
 
Old 03-11-2005, 11:32 AM   #9
basq3
LQ Newbie
 
Registered: Mar 2005
Location: baton rouge
Distribution: fedora 3
Posts: 21

Original Poster
Rep: Reputation: 15
ive redid the users in the gui and with command line.

-rw-r--r-- 1 mysql mysql 2520 Mar 9 07:30 my.cnf
drwx------ 2 mysql mysql 4096 Mar 6 20:19 mysql
srwxrwxrwx 1 mysql mysql 0 Mar 11 11:02 mysql.sock
drwx------ 2 mysql mysql 4096 Mar 9 09:22 phpmyadmin

[root@localhost ~]# mysqlcheck -A -u myusernamehere -p
Enter password:
mysql.columns_priv OK
mysql.db OK
mysql.func OK
mysql.host OK
mysql.tables_priv OK
mysql.user OK
phpmyadmin.pma_bookmark OK
phpmyadmin.pma_column_info OK
phpmyadmin.pma_history OK
phpmyadmin.pma_pdf_pages OK
phpmyadmin.pma_relation OK
phpmyadmin.pma_table_coords OK
phpmyadmin.pma_table_info OK


mysql> use mysql;
Database changed
mysql> show tables;
+-----------------+
| Tables_in_mysql |
+-----------------+
| columns_priv |
| db |
| func |
| host |
| tables_priv |
| user |
+-----------------+
6 rows in set (0.00 sec)

mysql> select user();
+--------------------+
| user() |
+--------------------+
| myusernamehere@localhost |
+--------------------+
1 row in set (0.02 s

so im able to login through the mysql command line and see and function, so the problem must be in how i did the phpmyadmin.

are there any experts out there who would eb willing to help?
 
Old 03-11-2005, 10:53 PM   #10
basq3
LQ Newbie
 
Registered: Mar 2005
Location: baton rouge
Distribution: fedora 3
Posts: 21

Original Poster
Rep: Reputation: 15
well i got the mysqlcc to work and got my db loaded and ready without to much fuss. though i really like the phpmyadmin i can live without it. at least it not like working dbase iii on a wang pc with a green screen.

if you know phpmyadmin please get in touch with me - if i have to pay to get it working it's worth it.
 
Old 04-21-2005, 01:46 AM   #11
BrianKDav
LQ Newbie
 
Registered: Feb 2003
Location: Santa Rosa, CA
Distribution: RedHat on servers, trying Debian on Laptop
Posts: 1

Rep: Reputation: 0
Try MS Internet Explorer

Firefox has done this to me before: I get, then fix, a problem with a web page on my server, but Firefox keeps displaying the same problem. When I dust off IE6 and try the same URL there, I get right in. The problem had been fixed, but Firefox retained the error page in its cache somewhere, refusing to show me I'd successfully fixed the original problem. I blew 4-5 hours on this the first time it happened.

Tonight, I had the problem after upgrading to phpmyadmin 2.6.2 on my debian box. Clearing history does not seem to fix it. I can't remember what does.

--Brian
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
phpMyAdmin, mysql - setup issues cornleader Linux - Software 6 03-09-2007 01:24 AM
phpmyadmin: can not login quarry_06 Linux - Software 1 04-27-2005 10:37 AM
phpmyadmin can't login vladimir@ares Linux - Software 2 12-31-2004 03:00 AM
phpMyAdmin login rejection as root ??? cdrobsonjr Linux - Software 2 12-01-2004 09:12 PM
Login Issues cactus-bob Linux - Newbie 4 03-02-2004 09:16 AM


All times are GMT -5. The time now is 02:51 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration