You are not logged in.

#1 2012-02-17 22:46:20

shadowmoses
Member
Registered: 2008-07-14
Posts: 8

[SOLVED] Phpmyadmin - Can't log in

I have searched everywhere for this and could not turn up any useful information.

First off, I have been able to log in to phpmyadmin since I installed my Arch Linux server.  I did an update the other day (was a month behind on updating) and now cannot log in through phpmyadmin.

When I try I get #1043 Cannot log in to the MySQL server.

Things I have tried.
1) Updated my config.inc.php in /etc/webapps/phpmyadmin/
2) Checked over my my.cnf in /etc/mysql/
3) Search google for numerous days!
4) Tried to Enabling Configuration Storage.  I read in a few places that this could solve my issue.
I could not complete this as when I run

mysql -u root -p < /usr/share/webapps/phpMyAdmin/scripts/create_tables.sql

I get an error stating

ERROR 1064 (42000) at line 30: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS 'pma_bookmark' ('id' int(11) NOT NULL auto_increment' at line 10

I am really at a loss of words here and am about to pull my hair out.  Help would be much appreciated.

Last edited by shadowmoses (2012-02-24 03:26:38)

Offline

#2 2012-02-18 00:57:16

yaffare
Member
Registered: 2011-12-29
Posts: 71

Re: [SOLVED] Phpmyadmin - Can't log in

fail

Last edited by yaffare (2012-02-18 01:00:47)


systemd is like pacman. enjoys eating up stuff.

Offline

#3 2012-02-18 01:02:37

shadowmoses
Member
Registered: 2008-07-14
Posts: 8

Re: [SOLVED] Phpmyadmin - Can't log in

Thanks for you constructive criticism.  I must say that is quite a douche bag statement.

Offline

#4 2012-02-18 01:19:23

yaffare
Member
Registered: 2011-12-29
Posts: 71

Re: [SOLVED] Phpmyadmin - Can't log in

you have to add this to your config.inc.php

$cfg['Servers'][$i]['AllowRoot'] = TRUE;
$cfg['Servers'][$i]['AllowNoPassword'] = TRUE;
$cfg['Servers'][$i]['AllowNoPasswordRoot'] = TRUE;

see docs: http://wiki.phpmyadmin.net/pma/Config#AllowRoot


systemd is like pacman. enjoys eating up stuff.

Offline

#5 2012-02-18 01:20:17

yaffare
Member
Registered: 2011-12-29
Posts: 71

Re: [SOLVED] Phpmyadmin - Can't log in

sorry the "fail" was ment for me, I just missclicked


systemd is like pacman. enjoys eating up stuff.

Offline

#6 2012-02-18 01:28:12

shadowmoses
Member
Registered: 2008-07-14
Posts: 8

Re: [SOLVED] Phpmyadmin - Can't log in

yaffare wrote:

you have to add this to your config.inc.php

$cfg['Servers'][$i]['AllowRoot'] = TRUE;
$cfg['Servers'][$i]['AllowNoPassword'] = TRUE;
$cfg['Servers'][$i]['AllowNoPasswordRoot'] = TRUE;

see docs: http://wiki.phpmyadmin.net/pma/Config#AllowRoot

I have AllowRoot enabled and the others are false as this is a public server.  This still does not solve the issue though.  Like I said it was working until the upgrade hmm .

Offline

#7 2012-02-18 02:19:20

yaffare
Member
Registered: 2011-12-29
Posts: 71

Re: [SOLVED] Phpmyadmin - Can't log in

strange cause you obviously can login from cli.
but you login in from localhost, meaning lamp all on 1 server?

maybe try create another user

mysql -u root -p
CREATE USER 'test123'@'localhost' IDENTIFIED BY 'test123';
GRANT ALL PRIVILEGES ON *.* TO 'test123'@'localhost' WITH GRANT OPTION;

then login with
username test123
password test123

if not I would remove phpmyadmin completely then check manually if all files are gone and reinstall.
I also tested mysql -u root -p < /usr/share/webapps/phpMyAdmin/scripts/create_tables.sql, it works for me,
wonder why you get an sql error here.


systemd is like pacman. enjoys eating up stuff.

Offline

#8 2012-02-18 06:41:47

ssfdre38
Member
From: South San Francisco CA
Registered: 2012-02-05
Posts: 6
Website

Re: [SOLVED] Phpmyadmin - Can't log in

its saying that on that .sql file on line 30, there is an syntax error and its not going to import due to that error. so you should check your .sql file and see what your missing or what shouldnt be there and if you need help, post lines 28 - 32  on here just so we can help you better


A Complex man who likes the simple things in life.
Owner of YourIRC networks at http://yourirc.net/ and ssfdre38.com

Offline

#9 2012-02-18 09:52:16

technolog
Member
From: Europe / Slovenia / Grosuplje
Registered: 2012-01-28
Posts: 117

Re: [SOLVED] Phpmyadmin - Can't log in

As said, your login data is ok and you are connected.

The problem is - your .SQL file is probably corrupted.

Offline

#10 2012-02-18 10:15:47

Awebb
Member
Registered: 2010-05-06
Posts: 6,383

Re: [SOLVED] Phpmyadmin - Can't log in

How did you update phpmyadmin? Manually (like I hope you installed it in the first place) or with pacman? It's probably a permission thing.

Online

#11 2012-02-24 03:15:40

shadowmoses
Member
Registered: 2008-07-14
Posts: 8

Re: [SOLVED] Phpmyadmin - Can't log in

I installed it with pacman.  I think I have discovered the issue though.

I re-installed the config.inc.php and I could log in fine.  So when I tried to add $cfg['Servers'][$i]['ssl'] = true; I could no longer log in.

Really weird, I have been running that for years.  Maybe they removed that feature, who knows.

Oh and that sql error is the actual file distributed with pacman for phpmyadmin.  It is in the /usr/share/webapps/phpMyAdmin/scripts folder.

Offline

#12 2012-02-24 03:16:28

shadowmoses
Member
Registered: 2008-07-14
Posts: 8

Re: [SOLVED] Phpmyadmin - Can't log in

I would also like to everyone for attempting to help. smile

Offline

#13 2012-02-24 03:27:42

shadowmoses
Member
Registered: 2008-07-14
Posts: 8

Re: [SOLVED] Phpmyadmin - Can't log in

They change the force SSL option to:

$cfg['ForceSSL'] = true;

Again thanks for the help all.

Offline

Board footer

Powered by FluxBB