Arch Linux

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)

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.

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.

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.

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.

shadowmoses

Member

Registered: 2008-07-14

Posts: 8

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

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 .

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.

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

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.

Awebb

Member

Registered: 2010-05-06

Posts: 6,406

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.

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.

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.

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.